EBS常用接口开发

整理了一些工作中常用的Oracle EBS接口和API，最早是看着大神黄建华文档起来的，格式内容参考他的文档，加上一些自己开发的程序和经历而已。

PO

        PO接收、检验、入库、退货-Interface+API_刘文钊1的博客-CSDN博客

基础数据

        EBS物料、bom、工艺导入程序_刘文钊1的博客-CSDN博客

1. API To Find Sales Order's Subtotal,discount,charges and Tax (OE_OE_TOTALS_SUMMARY.ORDER_TOTALS)
2. API for Cancelling the Purchase Order (PO) Document (PO_DOCUMENT_CONTROL_PUB.CONTROL_DOCUMENT)
3. API for Deleting the category assignment to an item (INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY_ASSIGNMENT)
4. API for Updating Category Assignment of an item (INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY_ASSIGNMENT)
5. API to Book a sales order (OE_ORDER_PUB.PROCESS_ORDER )
6. API to Cancel a Sales Order (OE_ORDER_PUB.PROCESS_ORDER)
7. API to Cancel an Order Line (OE_ORDER_PUB.PROCESS_ORDER)
8. API to Check Existence of an Internal Bank R12 (CE_BANK_PUB.CHECK_BANK_EXIST)
9. API to Create Item Specific UOM Conversion (INV_CONVERT.CREATE_UOM_CONVERSION)
10. API to Create a Customer Account for an existing Party TCA R12 (HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT)
11. API to Create a Customer Profile TCA R12 (HZ_CUSTOMER_PROFILE_V2PUB.CREATE_CUSTOMER_PROFILE)
12. API to Create a Customer Site TCA R12 (HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_ACCT_SITE)
13. API to Create a Customer Site Use TCA R12 (HZ_CUST_ACCOUNT_SITE_V2PUB.CREATE_CUST_SITE_USE)
14. API to Create a Party Site TCA R12 (HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE)
15. API to Create a Party Site Use TCA R12 (HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE_USE)
16. API to Create a Phone Number (Contacts) TCA R12 (HZ_CONTACT_POINT_V2PUB.CREATE_CONTACT_POINT)
17. API to Create an Internal Bank Account in R12 CE_BANK_PUB.CREATE_BANK_ACCT
18. API to Create an Internal Bank Branch R12 (CE_BANK_PUB.CREATE_BANK_BRANCH)
19. API to Delete a Sales Order (OE_ORDER_PUB.PROCESS_ORDER )
20. API to Delete an Order Line (OE_ORDER_PUB.PROCESS_ORDER)
21. API to End Date an Internal Bank Branch in R12 - CE_BANK_PUB.SET_BANK_BRANCH_END_DATE
22. API to End Date an Internal Bank in R12 - CE_BANK_PUB.SET_BANK_END_DATE
23. API to Update Customer Address in Oracle TCA R12 (HZ_LOCATION_V2PUB.UPDATE_LOCATION)
24. API to Update Oracle Applications Password (fnd_user_pkg.updateuser)
25. API to Update Purchase Order Document (PO) (PO_CHANGE_API1_S.UPDATE_PO)
26. API to Update a Customer Account TCA R12 (HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCOUNT)
27. API to Update an Internal Bank Branch R12 (CE_BANK_PUB.UPDATE_BANK_BRANCH)
28. API to Update an Internal Bank in R12 (CE_BANK_PUB.UPDATE_BANK)
29. API to apply hold on AP invoice in R12 (AP_HOLDS_PKG.INSERT_SINGLE_HOLD)
30. API to cancel single AP invoice (AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE)
31. API to confirm on Order Header Status (OE_HEADER_STATUS_PUB)
32. API to confirm on Order Line Status (OE_LINE_STATUS_PUB)
33. API to create Group in TCA R12 (HZ_PARTY_V2PUB.CREATE_GROUP)
34. API to create Party and Customer Account in R12 (HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT)
35. API to create a Person Type Party and Customer Account TCA R12 (HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCOUNT)
36. API to create customer Addresses in TCA R12 (HZ_LOCATION_V2PUB.CREATE_LOCATION)
37. API to find AP INVOICE Status (AP_INVOICES_PKG.GET_APPROVAL_STATUS)
38. API to get combination id based on segment info (FND_FLEX_EXT.GET_COMBINATION_ID)
39. API to get open sales order quantity in oracle apps (OE_LINE_UTIL.GET_OPEN_QUANTITY)
40. API to get the concatenated segment values for a code combination id (FND_FLEX_EXT.GET_SEGS)
41. API to get the formatted contact details of a Party in oracle apps R12 (HZ_FORMAT_PHONE_V2PUB.PHONE_DISPLAY)
42. API to get the segment delimiter for the specified key flex field structure (FND_FLEX_EXT.GET_DELIMITER)
43. API to populate loc_id HZ_LOCATIONS R12 (HZ_TAX_ASSIGNMENT_V2PUB. CREATE_LOC_ASSIGNMENT )
44. API to populate the Descriptive element Value of an item ( inv_item_catalog_elem_pub.process_item_descr_elements)
45. API to release hold on AP invoice in R12 (AP_HOLDS_PKG.RELEASE_SINGLE_HOLD)
46. API to update AR Invoice Printing Details in R12 AR_INVOICE_SQL_FUNC_PUB
47. API to update AR Receipt in oracle apps R12 - AR_RECEIPT_UPDATE_API_PUB (UNIDENTIFIED to UNAPPLIED)
48. API to update a Customer Account Relationship TCA R12 (HZ_CUST_ACCOUNT_V2PUB.UPDATE_CUST_ACCT_RELATE)
49. API to update a Customer Profile TCA R12 (HZ_CUSTOMER_PROFILE_V2PUB.UPDATE_CUSTOMER_PROFILE)
50. API to update an Internal Bank Account in Oracle Apps R12 (CE_BANK_PUB.UPDATE_BANK_ACCT)
51. AR: Reversal of Receipt through API (ar_receipt_api_pub.REVERSE)
52. AR: Unapplication of a Credit Memo through API (ar_cm_api_pub.unapply_on_account)
53. AR_INVOICE_API_PUB.create_single_invoice
54. AR_RECEIPT_API_PUB - Script to Create and Apply on account a AR Receipt
55. AR_RECEIPT_API_PUB.Apply_on_account ( Script to apply a receipt on account )
56. AR_RECEIPT_API_PUB.CREATE_MISC - R12 - Create Miscellaneous Cash Receipt in Oracle Apps
57. AR_RECEIPT_API_PUB.Unapply_on_account ( Script to unapply on account a Receipt in R12)
58. Add New Line to Existing Order Using the API (OE_ORDER_PUB.PROCESS_ORDER)
59. Ar_receipt_api_pub.Apply
60. Ar_receipt_api_pub.Create_and_apply
61. Ar_receipt_api_pub.Create_cash
62. Ar_receipt_api_pub.Unapply
63. Assign Delivery Details to a Delivery through API ( WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY )
64. Assigning Category set to Category via API in Oracle Apps (INV_ITEM_CATEGORY_PUB.CREATE_VALID_CATEGORY)
65. Assigning category to an Item using API (INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY_ASSIGNMENT)
66. Autocreate Deliveries Through API WSH_DELIVERY_DETAILS_PUB.AUTOCREATE_DELIVERIES
67. CASH MANAGEMENT API'S (CE_BANK_PUB) IN ORACLE APPS R12
68. CE_BANK_PUB.CHECK_BRANCH_EXISTS - API to check existence of an Internal Bank Branch in R12
69. CE_BANK_PUB.CREATE_BANK API to Create an Internal Bank in R12
70. CE_BANK_PUB.UPDATE_BANK_BRANCH API to Update an Internal Bank Branch R12
71. Create Credit Card in Oracle Payments using API (IBY_FNDCPT_SETUP_PUB.CREATE_CARD)
72. Create Party of type Organization in Oracle TCA using API hz_party_v2pub.create_organization
73. Create a Customer Account Relationship API HZ_CUST_ACCOUNT_V2PUB.CREATE_CUST_ACCT_RELATE
74. Create and Release Pciking Batch via API (wsh_picking_batches_pub.create_batch and wsh_picking_batches_pub.Release_batch)
75. Credit Memo Creation via API ( ar_credit_memo_api_pub.create_request )
76. FND_PROGRAM : Add Concurrent Program to Request Group via API
77. FND_PROGRAM : Delete Concurrent Program Definition via API
78. FND_PROGRAM : Delete Concurrent Program Executable via API
79. FND_PROGRAM : Delete Concurrent Program Parameter via API
80. FND_PROGRAM : Register Concurrent Program parameters via API
81. FND_PROGRAM : Register Concurrent Program via API
82. FND_PROGRAM : Remove Concurrent Program from Request Group via API
83. FND_PROGRAM : Create Concurrent Executable via API
84. FND_REQUEST.SUBMIT_REQUEST in R12
85. FND_USER_PKG.CREATEUSER ( Create Applications User via PLSQL)
86. GET ONHAND QUANTITIES THROUGH API in Oracle Apps R12 (INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES)
87. Generation of a LOT number for an Inventory item via API in R12
88. How to apply invoice in detail against the receipt through api (AR_RECEIPT_API_PUB.Apply_In_Detail)
89. How to attach documents from backend? ( fnd_webattch.add_attachment )
90. How to delete a attachment from backend (fnd_attached_documents2_pkg.delete_attachments)
91. How to do UOM Conversions through api? ( inv_convert.inv_um_convert_new )
92. How to get the Description of the Item based on Item catalog group using API (invicgds.inv_get_icg_desc)
93. How to get timezone based on ZIP code? (HZ_TIMEZONE_PUB.GET_TIMEZONE_ID)
94. How to set context and profile values from backend in R12 Oracle apps
95. IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK – R12 – API to Create External Bank
96. IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT – R12 – API to Create External Bank Account
97. IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH – R12 – API to Create External Bank Branch
98. IMPORT EXTERNAL BANK ACCOUNTS R12 ORACLE APPS
99. Item Categories Deletion through API in Oracle Apps (INV_ITEM_CATEGORY_PUB.DELETE_CATEGORY)
100. Item Categories Updation through API in Oracle Apps (INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY)
101. Item categories creation through API in Oracle Apps (INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY)
102. Item categories in oracle apps R12
103. Item import based on Item template in R12 (insert script)
104. OE_HOLDS_PUB.APPLY_HOLDS -- Apply Hold Script
105. OE_HOLDS_PUB.RELEASE_HOLDS -- Release Holds Script
106. OE_ORDER_PUB.GET_ORDER -- API to collect existing sales order data in R12
107. OE_ORDER_PUB.PROCESS_ORDER ( Sample Script for R12)
108. OE_ORDER_PUB.PROCESS_ORDER in Oracle Apps R12
109. OE_ORDER_PUB.PROCESS_ORDER to Apply hold on a sales order
110. OE_ORDER_PUB.PROCESS_ORDER to Release a hold on sales order in R12
111. ORA-01403: no data found in Package AR_RECEIPT_API_PUB Procedure Apply
112. Picking Batch Creation Through API ( wsh_picking_batches_pub.create_batch)
113. Price List Import via API (QP_PRICE_LIST_PUB.PROCESS_PRICE_LIST) in R12
114. Script to Submit Item Import (INCOIN) using FND_REQUEST in Oracle Apps R12
115. Script to get the Quantity reserved against an sales order line in oracle apps R12 (INV_RESERVATION_PUB.QUERY_RESERVATION_OM_HDR_LINE)
116. TRADING COMMUNITY ARCHITECTURE (TCA) API’S IN R12 ORACLE APPS
117. Unassign Delivery Details from Delivery through API ( WSH_DELIVERY_DETAILS_PUB.DETAIL_TO_DELIVERY )
118. Update Order Header Details Using the API (OE_ORDER_PUB.PROCESS_ORDER)
119. hz_party_contact_v2pub.create_org_contact - API to create a Contact person for an organization in Oracle TCA

source: List of All Posts ~ Oracle Apps Knowledge Sharing