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.
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.
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.
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
For more information for these three interface, you can refer these documenst.
No comments:
Post a Comment