OracleERPE-BusinessOracle應用技術 Creation November1,Last November14, ReferenceNumber> DRAFT1A<Approver <Approver Copy ControlChange5Change29-Oct-DraftNoPrevious Copy1LibraryProject2Project34NoteToIfyoureceiveanelectroniccopyofthis andprintitout,pleasewriteyournameontheequivalentofthecoverpage,for controlpurposes.Ifyoureceiveahardcopyofthis,pleasewriteyournameonthefrontcover,forcontrolpurposes. 總體說 業務需 s應付【OpenInterface 快速參 開發參 已知問 APrs供應商【OpenInterface、UnopenAPI 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 CEBankStatement銀行【OpenInterface 快速參 開發參 已知問 快速參 開發參 已知問 FAMassAddtions成批添加【OpenInterface 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 INVMaterialTransactions物料事務處理【OpenInterface 快速參 開發參 已知問 INVMoveOrders挑庫單【OpenAPI 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 MRPMasterDemand/ProductionSchedules【OpenInterface 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 OMShip銷售發運【OpenAPI 快速參 開發參 已知問 PORequisitions請購單【OpenInterface 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 快速參 開發參 已知問 WIPWorkOrders工單【OpenInterface 快速參 開發參 已知問 WIPMoveTransactions工序移動【OpenInterface 快速參 開發參 已知問 WIPResourceTransactions資源事務【OpenInterface 快速參 開發參 已知問 快速參 開發參 已知問 OpenandClosedIssuesforthis Open Closed 總體說本文檔目

業務需現場用能的碼機手持式A、RD設業數據比如料事數據（ER個OracleERP系統？這些紛繁復雜的海量工作不可能全部通過手工Key到系統中，必須處理這些業務需求的方式就是“接口”：通過一組程序把數據批量寫入OracleERP相關表中，達到和在界面輸入同樣的效果：數據一致性，數據有效性，數據集（比接口模式.OpenInterface模然而作為OpenInterface，它其實是一整套程序：接口表、驗證和處理并發程序、接口通常情況下，錯誤需要用戶在EBS接口模式.OpenAPI模從功能角度看，和OpenInterface一樣；差異體現在程序開發上。通過PL/SQL直接調用開放的APIProcedure，把數據導入目標Product表。OpenAPI基本是由一套PL/SQLPackage組成的，沒有用戶界面，從Package類型看，API類說私有API，是Oracle開發團隊自己使用的程序包，每次升級可能變化，我們不能使公有API，Oracle提供給我們使用的程序包，我們可以調用；但只要沒有以文檔形公開發布過，Oracle仍有可能改變，并且風險由我們自己承公開發布的API，Oracle提供給我們使用的Public程序包，并以文檔形式公開發布，們可以調用，每次升級變化的可能性極方類必默認?4、5、6是必須要開發的；說明同OpenInterface。根據實際情況靈活選用。在可能的情況下，建議采用OpenAPI模式。問題解決方看接口處理看接口錯誤查再看激活相關模塊的DebugProfile后，出錯信息就更明確更豐富了。有些Profile是選APs應付【OpenInterface快速參開發參

內功能導N:并發請N:AP/Requests/PayablesOpenInterface接口接口Debug詳細例文115apug.pdfOraclePayablesUserTable說ap_ap_ap_ap_Table ErrorSELECTSELECTFROMap_interface_rejectionsair,WHEREair.parent_id= s_interface并發程序PayablesOpenInterfaceN:AP/Requests/PayablesOpenInterface參說來Batch批Hold放空即Hold放空即GL放空即參說TraceDebugSummarizeCommitBatchUserLogin關鍵字段（參數）+最簡單例字說經營單位來自ap_號日供應商金幣組ID，可直接用字說經營單位來自ap_財務日行金賬戶 l_iface_lines_rec NUMBER:=-- := := := := :=-l_iface_lines_rec.last_update_date:= := := :=l_iface_lines_rec.last_update_login:=---SELECT s_interface_s.NEXTVALINTO _idFROM := _type_lookup_code:= := := := := := := := := := GATEWAY';--LookuptypeSOURCE := :=INSERTINTO s_interfaceVALUES--SELECT _lines_interface_s.NEXTVALINTO _line_idFROM := := := := := := bination_id:=INSERTINTO _lines_interfaceVALUESdbms_output.put_line('group_id'|| 已知問ProfileAP:UseBatchControls，定義是否使用批控APrs供應商【OpenInterface、UnopenAPI快速參開發參

內功能導N:AP/并發請N:AP/Requests/rOpenInterfaceap_rs_int/ap_接口接口Debug詳細例文115apug.pdfOraclePayablesUserTable說ap_ap_TablerOpenInterfaceN:AP/Requests/rOpenInterface參說ImportBatch默認PrintExceptionsDebugTrace是否啟用關鍵字段（參數）+最簡單例字說UnopenAPI最簡單例子（新增供應商、地址、聯系人）（11.5.9環境測試通過） NUMBER:= x_vendor_contact_id fnd_global.apps_initialize(user_id=>4760,resp_id=>52050,resp_appl_id=> => r => => => => p_minority_group_lookup_code=> => => => =>IFnvl(x_status,'F')<>'S' dbms_output.put_line('Status'|| dbms_output.put_line('Message'|| END :=x_exception_msg:=--Profile"DefaultCountry"mustbe => => => =>'Address =>'Address =>'Address =>'Address => => => => => =>IFnvl(x_status,'F')<>'S' dbms_output.put_line('Status'|| dbms_output.put_line('Message'|| END :=x_exception_msg:= => => => => => => => => => x_vendor_contact_id=> => =>IFnvl(x_status,'F')<>'S' dbms_output.put_line('Status'|| dbms_output.put_line('Message'|| END已知問ARCustomers客戶【OpenInterface快速參開發參

客戶表（Party、Customer、PartySite、SiteUse、Location、Contact、內功能導N:并發請N:AR/Requests/Customer接口接口DebugAR:EnableDebugMessageOutput\AR:EnableSQL詳細例文115arug.pdfOracleReceivablesUser說說TableTableRelation根據orig…ref字段關聯的，也是根據這些字段找正式表的。并發程序CustomerInterfaceN:參說N。Indicatesifareciprocalcustomerrelationshipmustbecreated.Ycausesthecreationofareciprocalcustomerrelationship.Ncreationofareciprocal關鍵字段（參數）+最簡單例字說如果預制文件HZ_GENERATE_PARTY_NUMBER為Y，那么如果AR參數generate_customer_number為Y，那么放空，否若導Site，預制文件經營單位如果為空，說明不導SiteUse。常用的有：若導SiteUse，AR參數auto_site_numbering為Y，那么放空若導SiteUse，如果是主SiteUse，就給若導Shipto，該字段用來指示所使用的Bill字說必如果使用系統標準Profile，則給這個字段賦值；也可直接經營單位字說參OpenInerface最簡單例子（僅新增客戶）（11.5.9環境測試通過） l_iface_prof_rec NUMBER:=-- := := := := :=-l_iface_prof_rec.last_update_date:= := := :=l_iface_prof_rec.last_update_login:=---SELECTdecode(nvl(fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER'),'Y'),'Y',NULL, INTO FROMSELECTdecode(generate_customer_number,'Y',NULL, INTO FROMWHEREorg_id= := := :=l_iface_rec.orig_system_customer_ref:= :='Customer := := := :=INSERTINTOra_customers_interface_allVALUES-- := := :=l_iface_prof_rec.customer_profile_class_name:= := :=INSERTINTOra_customer_profiles_int_allVALUESOpenInerface最簡單例子（僅新增Address和SiteUse）（11.5.9環境測試通過） l_iface_prof_rec NUMBER:=-- :=lifacerec.lastupdated := := := :=-l_iface_prof_rec.last_update_date:= := := :=l_iface_prof_rec.last_update_login:=---SELECTdecode(nvl(fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER'),'Y'),'Y',NULL, INTO FROMSELECTdecode(generatecustomernumber,'Y',NULL, INTO FROMarsystemWHEREorg_id= := := :='PART0001';:=:=:=:= := :=--Address&SiteSELECTdecode(nvl(fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'), INTO FROMSELECTdecode(auto_site_numbering,'Y',NULL, INTO FROMWHEREorg_id= := :=l_iface_rec.orig_system_address_ref:=l_iface_rec.bill_to_orig_address_ref:= := :=--CannotupdatesiteIFIFl_iface_rec.insert_update_flag='U'THENl_iface_rec.site_use_code:=NULL;ENDINSERTINTOra_customers_interface_allVALUES-- := := :=l_iface_prof_rec.customer_profile_class_name:= := :=INSERTINTOra_customer_profiles_int_allVALUESOpenInerface最簡單例子（同時新增客戶和Site）（11.5.9環境測試通過） lifaceprofrecracustomer NUMBER:=-- := := := := :=-l_iface_prof_rec.last_update_date:= := := :=l_iface_prof_rec.last_update_login:=---SELECTdecode(nvl(fndprofile.VALUE('HZ_GENERATE_PARTY_NUMBER'),'Y'),'Y',NULL, INTO FROMSELECTdecode(generate_customer_number,'Y',NULL, INTO FROMWHEREorg_id= := := :='PART0002';l_iface_rec.orig_system_customer_ref:= :='PART0002';l_iface_rec.orig_system_customer_ref:=lifacerec.customertype:=:=lifacerec.customertype:=:= :=--Address&SiteSELECTdecode(nvl(fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'),'Y'),'Y',NULL, INTO FROMSELECTdecode(auto_site_numbering,'Y',NULL, INTO FROMWHEREorg_id= := :=l_iface_rec.orig_system_address_ref:=l_iface_rec.bill_to_orig_address_ref:=liface := :=--CannotupdatesiteIFl_iface_rec.insert_update_flag=IFl_iface_rec.insert_update_flag='U'THENl_iface_rec.site_use_code:=NULL;l_iface_rec.primary_site_use_flag:=INSERTINTOra_customers_interface_allVALUES-- := :=l_iface_prof_rec.customer_profile_class_name:= := :=--Customel_iface_prof_rec.orig_system_address_ref:=INSERTINTOra_customer_profiles_int_allVALUES--SiteUsel_iface_prof_rec.orig_system_address_ref:=INSERTINTOra_customer_profiles_int_allVALUESOpenInerface最簡單例子（新增另一OUSite）（11.5.9環境測試通過） l_iface_prof_rec NUMBER:=-- :=lifacerec.lastupdated := :=lifacerec.created := :=-l_iface_prof_rec.last_update_date:= := := :=l_iface_prof_rec.last_update_login:=---SELECTdecode(nvl(fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER'),'Y'),'Y',NULL, INTO FROMSELECTdecode(generate_customer_number,'Y',NULL, INTO FROMarsystemWHEREorg_id= := := :='PART0002'; :='Customer:=:=:=:= :=--Address&SiteSELECTdecode(nvl(fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'),'Y'),'Y',NULL, INTO FROMSELECTdecode(auto_site_numbering,'Y',NULL, INTO FROMWHEREorg_id= := :=l_iface_rec.orig_system_address_ref:=l_iface_rec.bill_to_orig_address_ref:= := :=--CannotupdatesiteIFIFl_iface_rec.insert_update_flag='U'THENl_iface_rec.site_use_code:=NULL;ENDINSERTINTOra_customers_interface_allVALUES-- := :=l_iface_prof_rec.customer_profile_class_name:= := :=--SiteUsel_iface_prof_rec.orig_system_address_ref:=INSERTINTOra_customer_profiles_int_allVALUES l_iface_prof_recl_iface_phone_rec NUMBER:=-- := := := := :=- := := := :=l_iface_prof_rec.last_update_login:=-l_iface_phone_rec.last_update_date:=lifacephonerec.lastupdated := :=lifacephonerec.created :=l_iface_phone_rec.last_update_login:=---SELECTdecode(nvl(fnd_profile.VALUE('HZ_GENERATE_PARTY_NUMBER'),'Y'),'Y',NULL, INTO FROMSELECTdecode(generate_customer_number,'Y',NULL, INTO FROMWHEREorg_id= := :=lifacerec.origsystempartyref :=lifacerec.origsystempartyref :='PART0004';:=:=:=:= := :=--Address&SiteSELECTdecode(nvl(fnd_profile.VALUE('HZ_GENERATE_PARTY_SITE_NUMBER'),'Y'),'Y',NULL, INTO FROMSELECTdecode(auto_site_numbering,'Y',NULL, INTO FROMWHEREorg_id= := :=lifacerec.origsystemaddressref:=l_iface_rec.bill_to_orig_address_ref:=liface := :=--CannotupdatesiteIFIFl_iface_rec.insert_update_flag='U'THENl_iface_rec.site_use_code:=NULL;ENDINSERTINTOra_customers_interface_allVALUES--lifaceprofrec.insertupdate := :=lifaceprofrec.customerprofileclassname:= := :=--Customel_iface_prof_rec.orig_system_address_ref:=INSERTINTOra_customer_profiles_int_allVALUES--SiteUsel_iface_prof_rec.orig_system_address_ref:=INSERTINTOra_customer_profiles_int_allVALUES-- :=lifacephonerec.origsystemcustomerref:=lifacerec.origsystemcustomer := := ephone_ref:= := :=' :='GEN';-- :=INSERTINTOra_contact_phones_int_allVALUES已知問shipto的bill_to_orig_address_ref可用billto的orig_system_address_ref，這樣可以自FUNCTIONFUNCTION IN INVARCHAR2,p_site_use_codeINRETURNVARCHAR2 l_count ref_null_exception IFpcustrefISNULLORpaddr_refISNULL RAISE END SELECT INTO FROM WHEREorig_system_reference= IFl_count=0 RETURN END IFp_site_use_codeISNULL RETURN END SELECT INTO FROMra_customerscs,ra_addressesad,ra_site_uses WHEREcs.customer_id= ANDad.address_id=ANDANDcs.orig_system_reference=ANDad.orig_system_reference= ANDsu.site_use_code= IFl_count=0 RETURN END RETURNFUNCTIONget_cust_prof_iface_flag(p_cust_refIN p_addr_refINVARCHAR2)RETURNVARCHAR2 l_count ref_null_exception IFp_cust_refISNULL RAISE END SELECT INTOl FROM WHEREorig_system_reference= IFl_count=0 RETURN END IFp_addr_refISNULL SELECT INTO FROMhz_cust_accountscs,hz_customer_profiles WHEREcs.orig_system_reference= ANDcp.site_use_idIS ANDcs.cust_account_id= SELECT INTO FROMra_customerscs,ar_customer_profilescp,ra_addressesWHEREWHEREcs.customer_id=ANDcp.customer_id=ANDANDcs.orig_system_reference=ANDad.orig_system_reference= ANDcp.site_use_idISNOT END IFlcount=0 RETURN END RETURNFUNCTION IN p_contact_refIN RETURNVARCHAR2 l_count ref_null_exception SELECT INTO FROMhzcustaccountroles WHEREcont.orig_system_reference= IFl_count>0 RETURN END SELECT INTO FROMhz_contact_points WHEREphone.orig_system_reference= IFl_count>0 RETURN END RETURN11.5.9需要打Patch3606744和3558213，否則Statement和Dunning類型的SiteUse導不ARTransactions應收【OpenInterface、OpenAPI快速參開發參

TransactionFlexfield定義；這些字段的值組合不能和正式表重復。account_classRECandlatest_rec_flagY'的ra_cust_trx_line_gl_dist_all是沒有如果沒有銷售員，可以提供一條salesrep_id=-3的NoSales記錄給接口。這個要看ARSystemOptionMiscellaneous上的設置是否要求銷售員。如果對PaymentSchedule信息“不滿意”，可以Update或者Insert表內功能導N:并發請N:AR/Requests/AutoMasterAR_接口N:AR/Control/Auto/Interface接口N:AR/Control/Auto/InterfaceDebugAR:EnableDebugMessage詳細例文115arug.pdfOracleReceivablesUser115arapi.pdfOracleReceivablesAPIUserTable說TableRelation接口表之間的關系和其他接口不同，不是通過ID關聯，而是通過描述性彈性域LineTransactionFlexfield定義；這些字段的值組合不能和正式表重復并發程序并發程序MasterN:AR/Requests/AutoMaster參說NumberofBatchSourceBatchSource隱藏參DefaultBaseDueDateonTrxYOrd關鍵字段（參數）+最簡單例字說必OpenInerface最簡單例子（更新數量和需求日期）（VIS環境測試通過）已知問BOMBills物料【OpenInterface、OpenAPI快速參開發參

內功能導N:并發請BillandRoutingN:接口接口DebugMRP:Debug詳細例文115mfgapi.pdf：OracleManufacturingAPIsandOpenInterfaces Table說頭表視圖；可單獨使用Table nvl(bom_bill_of_mtls_interface.alternate_bom_designator,chr(0))= SELECT FROMinv.mtl_interface_errorst,bom.bom_bill_of_mtls_interfaceWHEREi.transaction_id=SELECT FROMinv.mtl_interface_errorst, ps_interfaceWHEREi.transaction_id=并發程序BillandRoutingN:參說AllImportImportBillsofDeleteProcessed作Interface關鍵字段（參數）+最簡單例字說庫存CurrentInv字說庫存CurrentInv組件序字說字說組件序字說通用參YN不輸出調試信調式信 ，一般是 l_iface_lines_rec NUMBER:=204;--CurrentInv NUMBER:=0;--UserID,Sysadminl_iface_rec.last_update_date:= := := :=l_iface_rec.last_update_login:=-l_iface_lines_rec.last_update_date:= := := :=l_iface_lines_rec.last_update_login:=- := := := :=l_iface_rec.alternate_bom_designator:=INSERTINTObom.bom_bill_of_mtls_interfaceVALUES := := := :=l_iface_lines_rec.alternate_bom_designator:= := := := :=INSERTINTO ps_interfaceVALUESOpenAPI例子（VIS環境測試通過 x_bom_ref_designator_tbl ponent_tbl x_return_status x_message_listl_indexNUMBER:= NUMBER:=0;--UserID,Sysadminl_cur_mfg_org_codeVARCHAR2(240):=--Initializefirst,orcreate_bywillbe- => => resp_appl_id=>-- := := := :=l_bom_header_rec.bom_implementation_date:= ponent_tbl(l_index).transaction_type:= ponent_tbl(l_index).organization_code:= ponent_tbl(l_index).assembly_item_name:= ponent_tbl(l_index).alternate_bom_code:= ponent_tbl(l_index).item_sequence_number:= ponent_tbl(l_index).component_item_name:= ty_per_assembly:= ponent_tbl(l_index).start_effective_date:= => => => => => => x_bom_ref_designator_tbl=> ponent_tbl => => => =>--IFx_return_status<>fnd_api.g_ret_sts_success error_handler.get_message_list(x_message_list=> FORiIN1..x_message_list.COUNT dbms_output.put_line('BO :'|| dbms_output.put_line('OrganizationID:'|| dbms_output.put_line('Entity :' dbms_output.put_line('Message :' substr(x_message_list(i).message_text,1, dbms_output.put_line('Entity :'|| dbms_output.put_line('Message :'|| dbms_output.put_line('Table :'|| dbms_output.put_line('Row :'|| END IF(x_return_status=fnd_api.g_ret_sts_unexp_error) RAISE ELSIF(x_return_status=fnd_api.g_ret_sts_error) RAISE END ENDOpenAPI例子（11.5.9GITI測試環境測試通過）x_bom_ref_designator_tbl ponent_tbl xreturnstatus x_message_listl_indexNUMBER:=--Initialize?orcreateBywillbe- => => resp_appl_id=> --backupallprimarybomtoanFORhdr_recIN(SELECT mst.segment1 FROMapps.bom_bill_of_materials WHEREanization_id=ANDWHEREanization_id=ANDanization_id= ANDanization_code= ANDboms.alternate_bom_designatorIS ANDNOT (SELECT FROMapps.bom_bill_of_materials WHEREanization_id= ANDboms2.assembly_item_id ANDboms2.alternate_bom_designator='06BK')) -- := l_bom_header_anization_code:= l_bom_header_rec.assembly_item_name:= l_bom_header_rec.alternate_bom_code:= l_index:= FORline_recIN(SELECT mst.segment1component bics.effectivity FROM ponents WHEREhdr_anization_id= ponent_item_id= --AND(nvl(bics.disable_date,SYSDATE)>=SYSDATE - bics.effectivity_date<=SYSDATE - bics.effectivity_date> ANDbics.bill_sequence_id= ORDERBYbics.item_num,bics.effectivity_date) ponent_tbl(l_index).transaction_type:= ponent_tbl(l_index).organization_code:=ponent_tbl(l_index).assembly_item_nameponent_tbl(l_index).assembly_item_name:=l_bom_header_rec.assembly_item_name;lbomcomponenttbl(lindex).alternatebomcode:=lbomheaderrec.alternate_bom_code; ponent_tbl(l_index).item_sequence_number:= ponent_tbl(l_index).component_item_name ty_per_assembly ponent_tbl(l_index).start_effective_date:= ponent_tbl(l_index).disable_date:= l_index:=l_index+ ENDxbomheaderrecxbomcomponenttbl=>=>=>=>=>xbomheader=>=>xbomcomponentx_bom_ref_designator_tbl=>x_bom_ref_designator_tbl,ponent_tbl=> =>=>=> -- IFx_return_status<>fnd_api.g_ret_sts_success errorhandler.getmessagelist(xmessage_list=> FORiIN1..x_message_list.COUNT dbmsoutput.putline('BO :'|| dbms_output.put_line('OrganizationID:'|| dbms_output.put_line('Entity :' dbms_output.put_line('Message :' substr(x_message_list(i).message_text,1, dbms_output.put_line('Entity :'|| dbms_output.put_line('Message :'|| dbms_output.put_line('Table :'|| dbmsoutput.putline('Row :'|| END IF(x_return_status=fnd_api.g_ret_sts_unexp_error) RAISE ELSIF(x_return_status=fnd_api.g_ret_sts_error) RAISE END ENDEND已知問BOMRoutings工藝路線【OpenInterface、OpenAPI快速參開發參

內功能導N:并發請BillandRoutingN:接口接口DebugMRP:Debug詳細例文115mfgapi.pdf：OracleManufacturingAPIsandOpenInterfaces Table說頭表；可單獨使用，如Tablebom_op_routings_anization_id=bom_op_sequences_anization_idbom_op_routings_interface.assembly_item_number=nvl(bom_op_routings_interface.alternate_routing_designator,chr(0))=bom_op_sequences_anization_id=bom_op_resources_anization_idbom_op_sequences_interface.assembly_item_number=nvl(bom_op_sequences_interface.alternate_routing_designator,chr(0))=bom_op_sequences_interface.operation_seq_num=SELECT FROMinv.mtl_interface_errorst,bom.bom_op_routings_interfaceWHEREi.transaction_id=SELECT FROMinv.mtl_interface_errorst, ps_interfaceWHEREi.transaction_id=SELECTt.error_message,t.entity_identifier,t.bo_identifier,FROMinv.mtl_interface_errorst,bom.bom_op_sequences_interfaceWHEREi.transaction_id=SELECT FROMinv.mtl_interface_errorst,bom.bom_op_resources_interfaceWHEREi.transaction_id=并發程序BillandRoutingN:參說AllImportImportBillsofDeleteProcessedInterface 關鍵字段（參數）+最簡單例字說庫存CurrentInv字說庫存CurrentInv字說工序序部門代字說庫存CurrentInv工序序資源代資源數WIPPOPO字說通用參YN不輸出調試信調式信 ，一般是 NUMBER:=207;--CurrentInv NUMBER:=0;--UserID,Sysadminl_iface_rec.last_update_date:= := := :=l_iface_rec.last_update_login:=-l_iface_seq_rec.last_update_date:= := := :=l_iface_seq_rec.last_update_login:=-l_iface_res_rec.last_update_date:= := := :=l_iface_res_rec.last_update_login:=- := := := :=l_iface_rec.alternate_routing_designator:=INSERTINTObom.bom_op_routings_interfaceVALUES := := := :=l_iface_seq_rec.alternate_routing_designator:= := := :=INSERTINTObom.bom_op_sequences_interfaceVALUES := := := :=l_iface_res_rec.alternate_routing_designator:= := := :='LBR- := :=INSERTINTObom.bom_op_resources_interfaceVALUESl_iface_res_rec;OpenInerface最簡單例子（單獨修改資源）（11.5.9GITI環境測試通過）l_iface_res_recl_iface_res_recbom.bom_op_resources_interface%ROWTYPE;l_cur_mfg_org_idNUMBER:=443;--CurrentInvOrganization NUMBER:=0;--UserID,Sysadminherel_iface_res_rec.last_update_datel_iface_res_rec.last_update_date:=lifaceresrec.lastupdatedby :=luserid; :=SYSDATE; :=l_user_id;l_iface_res_rec.last_update_login:=-1; := := := :=l_iface_res_rec.alternate_routing_designator:=:=:= := := :=to_date('12-JUL-2006 'DD-MON-YYYYINSERTINTObom.bom_op_resources_interfaceVALUESl_iface_res_rec;OpenInerface最簡單例子（單獨新增資源）（11.5.9GITI環境測試通過）l_iface_res_recbom.bom_op_resources_interface%ROWTYPE;l_cur_mfg_org_idNUMBER:=443;--CurrentInvOrganization NUMBER:=0;--UserID,Sysadminherel_iface_res_rec.last_update_date:=SYSDATE; :=l_user_id; :=SYSDATE; :=l_user_id;l_iface_res_rec.last_update_login:=-1; := := :=l_cur_mfg_org_id; :='100E037L';l_iface_res_rec.alternate_routing_designator:=NULL; :=10; := := :=1.9; :=to_date('14-JUN-200617:59:55','DD-MON-YYYYINSERTINTObom.bom_op_resources_interfaceVALUESOpenInerface最簡單例子（標準工序的同時修改資源）（VIS環境測試liface bom.bomoproutings lifaceresrec bom.bomopresourcesinterface%ROWTYPE; NUMBER:=207;--CurrentInvl_cur_mfg_org_codeVARCHAR2(240):= NUMBER:=0;--UserID,Sysadmin VARCHAR2(240):=l_iface_rec.last_update_date:=l_iface_rec.last_update_date:=SYSDATE; :=l_user_id; :=SYSDATE; :=l_user_id;l_iface_rec.last_update_login:=-1;lifaceseqrec.lastupdatedate:=SYSDATE; :=l_user_id;lifaceseqrec.creationdate :=SYSDATE; :=l_user_id;l_iface_seq_rec.last_update_login:=-1;l_iface_res_rec.last_update_date:=SYSDATE; :=l_user_id; :=SYSDATE; :=l_user_id;l_iface_res_rec.last_update_login:=-1; := := := :=l_iface_rec.alternate_routing_designator:=INSERTINTObom.bom_op_routings_interfaceVALUES := := := :=l_iface_seq_rec.alternate_routing_designator:= :=:=:= :=INSERTINTObom.bom_op_sequences_interfaceVALUESUpdateresourcederivedfromstandard := := := :=l_iface_res_rec.alternate_routing_designator:= := :=:='LBR-:=; :=INSERTINTObom.bom_op_resources_interfaceVALUES--Addnew := :=l_iface_res_rec.usage_rate_or_amount:=INSERTINTObom.bom_op_resources_interfaceVALUESl_iface_res_rec; l_op_resource_tbl x_rtg_revision_tbl x_op_resource_tblx_sub_resource_tbl x_return_status x_message_listl_indexNUMBER:= NUMBER:=0;--UserID,Sysadminl_cur_mfg_org_codeVARCHAR2(240):=--Initializefirst,orcreate_bywillbe- => => resp_appl_id=>-- := := :=l_rtg_header_rec.alternate_routing_code:= :=l_operation_tbl(l_index).transaction_type:=l_operation_tbl(l_index).organization_code:=l_operation_tbl(l_index).assembly_item_name:=l_operation_tbl(l_index).alternate_routing_code:=l_operation_tbl(l_index).operation_sequence_number:=l_operation_tbl(l_index).department_code:=l_operation_tbl(l_index).start_effective_date:=l_op_resource_tbl(l_index).transaction_type:=l_op_resource_tbl(l_index).organization_code:=l_op_resource_tbl(l_index).assembly_item_name:=l_op_resource_tbl(l_index).alternate_routing_code:=l_op_resource_tbl(l_index).operation_sequence_number:= l_op_resource_tbl(l_index).resource_sequence_number:=l_op_resource_tbl(l_index).resource_code:='LBR-l_op_resource_tbl(l_index).usage_rate_or_amount:= l_op_resource_tbl(l_index).op_start_effective_date:= => p_api_version_number=> => => => => => => => => => => => => => =>--IFx_return_status<>fnd_api.g_ret_sts_success error_handler.get_message_list(x_message_list=> FORiIN1..x_message_list.COUNT dbms_output.put_line('BO :'|| dbms_output.put_line('OrganizationID:'|| dbms_output.put_line('Entity :'|| dbms_output.put_line('Message :' substr(x_message_list(i).message_text,1, dbms_output.put_line('Entity :'|| dbms_output.put_line('Message :'|| dbms_output.put_line('Table :'|| dbms_output.put_line('RowIdentifier:'|| END IF(x_return_status=fnd_api.g_ret_sts_unexp_error) RAISE ELSIF(x_return_status=fnd_api.g_ret_sts_error) RAISE END END已知問CEBankStatement銀行【OpenInterface快速參內功能導