Oracle APIs and Open Interfaces

Oracle Puchasing:
1. Requisitions Open Interface
2. Purchasing Documents Open Interface
3. Cancel PO APIs
4. Receiving Open Interface
Oracle Inventory:
1. Open Transaction Interface
2.1 Customer Item Interface
2.2 Open Item Interface
2.3 Cycle Count Open Interface
3.1 Open Replenishment Interface
3.2 Reservations Open Interface
3.3 Move Orders Open Interface
OM:
1.    Order Import
2.    Process Order API
3.    RLM Open Interfaces
Actions, APIs, and Parameters: Descriptions of the APIs used for various functions and the API parameters.
Application Parameter Initialization: Description of the application parameter initialization call.
Trip API: Create and update trip records and perform actions on trips.
Stop API: Create and update stop records and perform actions on stops.
Deliveries API: Create and update trip stop records and perform actions on trip stops.
Delivery  Details API: Assign and unassign delivery details to and from  deliveries, split a delivery detail, update a delivery detail with new
information, and create trips and deliveries for multiple delivery lines.
Container API: Create container records, update container records, autopack containers, perform actions on containers.
Freight  Cost APIs: Create freight cost records, update freight cost records,  validate freight cost types, delete freight cost records.
Tables
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
WSH_DELIVERY_DETAILS
OE_ORDER_HOLDS_ALL
OE_PRICE_ADJUSTMENTS
OE_TRANSACTION_TYPES_ALL
OE_DROP_SHIP_SOURCES
OE_SETS
OE_SYSTEM_PARAMETSR
MTL_DEMANDS
MTL_RESRVATIONS
Inventory
Open Transaction Interface
 Oracle Inventory provides an open interface for you to load  transactions from external applications and feeder systems. These  transactions could include sales order shipment transactions from an  Order Management system other than Oracle Order Management, or they  could be simple material issues, receipts, or transfers loaded from data  collection devices. The following transaction types are supported by  this interface:
• Inventory issues and receipts (including user-defined transaction types)
• Subinventory transfers
• Direct interorganization transfers
• Intransit shipments
• WIP component issues and returns
• WIP assembly completions and returns
• Sales order shipments
• Inventory average cost updates
• LPN Pack
• Unpack
• Split Transactions
• Inventory Lot Split/ Merge/ Translate Transactions
 This interface is also used as an integration point with Oracle Order  Management for shipment transactions. Oracle Order Management's  Inventory Interface program populates the interface tables with  transactions submitted through the Confirm
Shipments window.
You  must write the load program that inserts a single row for each  transaction into the MTL_TRANSACTIONS_INTERFACE table. For material  movement of items that are under lot or serial control, you must also  insert rows into MTL_TRANSACTION_LOTS_INTERFACE and  MTL_SERIAL_NUMBERS_INTERFACE respectively. If you insert WIP
 assembly/completion transactions that complete or return job assemblies,  you must also insert rows into the CST_COMP_SNAP_ INTERFACE table if  the organization referenced uses average costing. The system uses this  information to calculate completion cost.
There are two modes you can use to process your transactions through  the interface. In the first processing mode, you populate the interface  table only. Then the Transaction Manager polls the interface table  asynchronously looking for transactions to process, groups the  transaction rows, and launches a Transaction Worker to process each  group.
In the second processing mode, you insert the rows in the  interface table and call a Transaction Worker directly, passing the  group identifier of the interfaced transactions as a parameter so that  the worker can recognize which subset of transactions to process.
The Transaction Worker calls the Transaction Validator, which  validates the row, updates the error code and explanation if a  validation or processing error occurs, and derives or defaults any  additional columns. Next, the Transaction Processor records the  transaction details in the transaction history table along with relevant  current cost information. All material movement transactions update  inventory perpetual balances for the issue, receipt, or transfer  locations. Once the transaction has been successfully processed, the  corresponding row is deleted from the interface table. Finally, the  transaction is costed by the transaction cost processor, which runs  periodically, picking up all transactions from the history table that  have not yet been marked as costed.
Open Replenishment Interface
 Oracle Inventory provides an open interface for you to easily load  replenishment requests from external systems such as a barcode  application. Such requests may be in the form of stock-take counts or  requisition requests for subinventories in which you do not track  quantities.
Cycle Count Entries Interface
 You can import cycle count entries from an external system into Oracle  Inventory using the Cycle Count Entries Interface. This interface  validates all data that you import into Oracle Inventory. It also  performs foreign key validation and checks for attribute  inter-dependencies, acceptable values, and value ranges. The interface  ensures that the imported cycle count entries contain the same detail as  items entered manually using the Cycle Count Entries window. Errors  detected during validation are written to the Cycle Count Interface  Errors table.
Kanban Application Program Interface
 The Kanban API is a public API that allows you to update the supply  status of kanban cards. To accomplish this task, you use the public  procedure update_card_supply_status
Item Open Interface
 You can import items from any source into Oracle Inventory and Oracle  Engineering using the Item Open Interface. With this interface, you can  convert inventory items from another inventory system, migrate assembly  and component items from a legacy manufacturing system, convert  purchased items from a custom purchasing system, and import new items  from a product data management package. The Item Open Interface  validates your data, ensuring that your imported items contain the same  item detail as items that you enter manually in the Master Item window.
You can also import item category assignments. This can be done  simultaneously with a process of importing items, or as a separate task  of importing item category assignments only. For this purpose, the  Inventory menu contains the Import submenu with the Import Items and  Import Item Category Assignments menu entries.
Receiving Open Interface
 You use the Receiving Open Interface to process and validate receipt  data that comes from sources other than the Receipts window in Oracle  Purchasing. These sources include:
• Receipt information from other Oracle applications or legacy systems
• Brocades and other receiving information from scanners and radio frequency devices
• Advance Shipment Notices (ASNs) from suppliers
 The Receiving Open Interface maintains the integrity of the new data as  well as the receipt data that resides in Oracle Purchasing.
The Receiving Open Interface does not support:
• Movement statistics
• Dynamic locators

BOM
Bills of Materials Open Interfaces
WIP
Open Move Transaction Interface
 You can load Move transaction information into the Open Move  Transaction Interface from a variety of sources, including external data  collection devices such as bar code readers, automated test equipment,  cell controllers, and other manufacturing execution systems. You then  use the interface to load these transactions into Oracle Work in  Process. All transactions are validated and invalid transactions are  marked, so that you can correct and resubmit them.
Open Resource Transaction Interface
 You can use external data collection devices such as bar code readers,  payroll systems, and time card entry forms to collect resource and  overhead transaction data, then load the data into the Open Resource  Transaction Interface for Oracle Work in Process to process.
Work Order Interface
 The Work Order Interface enables you to import Discrete job and  Repetitive schedule header information, and Discrete job operations,  material, resource, and scheduling information from any source, using a  single process.
You can import:
• Planned orders for new Discrete jobs,
• Discrete job operations, components, resources, resource usage, and scheduling details
• Update and reschedule recommendations for existing Discrete jobs
• Suggested Repetitive schedules Work in Process then uses this information to automatically create new Discrete jobs
and pending Repetitive Schedules, or to update existing Discrete jobs.
MRP
Open Forecast Interface
 You can import forecasts from any source using the Open Forecast  Interface table. Oracle Master Scheduling/MRP automatically validates  and implements imported forecasts as new forecasts in Oracle Master  Scheduling/MRP.
Cost Management
Periodic Cost Open Interface
 The Oracle Periodic Cost Open Interface provides an open interface for  you to easily load periodic item costs from external applications or  legacy systems and migrate them into the Oracle Cost Management  Application. This interface should only be used to bring in periodic  costs for the first opened periodic period. It cannot be used for  subsequent periods. Costs in subsequent periods are calculated by the  system.
Cost Import Interface
 The Oracle Cost Import Interface enables you to import costs for items  from legacy systems, and import new cost information for existing items.  Importing resource costs and resource overhead rates is also supported.  You will also be able to replace existing cost information with the new  cost information. However, updating of existing costs is not supported.  Importing costs into frozen cost type is also not supported. The item  costs will have to be imported into another cost type and then the cost  update may be run to update the frozen cost type
OM
Order Import
Pricing Open interface
Pick release

Oracle EBS APIs

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