Oracle API Availability -Purchasing
To get the brief idea about some available standard available Oracle Application interfaces applicable within oracle purchasing modules and hopefully it should serve to familiarize individuals with limited knowledge of Oracle's API functionality.
1. Open Requisition Interface
What you can do:
By this you can Automatically import requisitions from other oracle Application system or any other system using this interface. This allows you to integrate your oracle purchasing application with new or existing applications, such as material requirement planning, inventory management.etc.
By this you can Automatically import requisitions from other oracle Application system or any other system using this interface. This allows you to integrate your oracle purchasing application with new or existing applications, such as material requirement planning, inventory management.etc.
What tables involved
- PO_REQUISITIONS_INTERFACE_ALL
- PO_REQ_DIST_INTERFACE_ALL
2. Requisition Reschedule
What you can do:
This is required when you are having Oracle Master Scheduling/MRP or a non-Oracle MRP system integrated with your oracle Purchasing, you may find that you need to reschedule requisitions as your
Planning requirements change. This API'S lets you reschedule requisition lines according to changes in your planned orders.
Planning requirements change. This API'S lets you reschedule requisition lines according to changes in your planned orders.
What tables involved
- PO_RESCHEDULE_INTERFACE
3. Purchasing Documents Open Interface
What you can do:
You can Automatically import and update standard purchase orders, price/sales catalog information, and responses to request for Quotations(RFQ's) from suppliers through this interface. This interface uses the API's to process document data in the oracle applications interface table to ensure that it is valid before importing it into oracle purchasing. After the data is validated, the program converts the information in the interface table into the appropriate document in purchasing.
What tables involved
- PO_HEADERS_INTERFACE
- PO_LINES_INTERFACE
- PO_DISTRIBUTIONS_INTERFACE
4. Receiving Open Interface
What you can do:
You can Automatically import receipt information from other oracle applications or other system using the receiving open interface. This interface lets you integrate your oracle purchasing applications with new or existing applications. E.g. you can load bar-coded and other receiving information from scanners.
More over the good things is that you can also bring Advance Shipment Notices (ASNs) sent from suppliers by this interface.
More over the good things is that you can also bring Advance Shipment Notices (ASNs) sent from suppliers by this interface.
What tables involved
- RCV_HEADERS_INTERFACE
- RCV_TRANSACTIONS_INTERFACE
What you can't done by this API's
- Serial numbering
- Separate receive and deliver
- Corrections
- Returns
- Movement statistics
- Dynamic locators
- Receiving against Internal Orders
- Receiving against Inter-Organization transfers
- Receiving against Drop Ship Orders
- Receiving against RMAs
