Purchasing Interfaces

[svssravan]

Hi All,

Can anyone tell me or send me a document which can provide the interfaces in Purchasing and Inventory and also interfaces between Purchasing and Inventory.

Regards,
Sravan.

[svssravan]

Can anyone provide me the open interfaces details in P2P functional flow.

[arun1203]

Hi [:)],

<font color="red"><u><b>Open Interfaces in Purchasing</b></u></font id="red">

In Purchasing we have the following Open Interfaces/API(s).

<font color="red"><b>1.Requisitions Open Interface:</b></font id="red">

With this open interface you can automatically import from other Oracle Applications or your existing non Oracle Systems.

Tables in this interface are as follows:

(i)PO_REQUISITIONS_INTERFACE_ALL
(ii)PO_REQ_DIST_INTERFACE_ALL

etc.,

<font color="red"><b>2.Purchasing Documents Open Interface</b></font id="red">

With this interface you can automatically import and update price/sales catalog information and request for quotation (RFQ) responses from suppliers.You can also import standard purchase orders (for example, from a legacy system) through the Purchasing Documents Open Interface.

Tables in this interface are as follows:

(i)PO_HEADERS_INTERFACE
(ii)PO_LINES_INTERFACE
(iii)PO_DISTRIBUTIONS_INTERFACE
(iv)PO_PRICE_DIFF_INTERFACE

<font color="red"><b>3.Receiving Open Interface</b></font id="red">

With this interface we can process and validate receipt data that
comes from sources other than the Receipts window in Purchasing.

Tables in this interface are as follows:

(i)RCV_HEADERS_INTERFACE
(ii)RCV_TRANSACTIONS_INTERFACE

In addition to this we have got various other API's by which we can apply changes to standard purchase orders , Cancel the PO's ,Custom Pricing on PO's etc.

<font color="blue"><b>Best Regards[:)],
Arun Reddy.
E-Mail:arunapps@gmail.com</b></font id="blue">

[admin]

Thanks Arun Reddy for your detailed explanation. The following topic is also informative,

topic.asp?TOPIC_ID=3701