My Oracle Support Banner

How to Utilize Purchasing Documents Open Interface (PDOI) Tables and Program to Import Amounts/Quantity Billed and Amounts/Quantity Delivered (Doc ID 2704401.1)

Last updated on MARCH 15, 2022

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.


There is a requirement to Import Approved Standard POs from legacy with directly QUANTITY_RECEIVED, QUANTITY_DELIVERED and QUANTITY_BILLED from legacy (We have plan for ONLY Standard PO Import but NO Receipt Import and/or Invoice Import).

For example, if legacy PO Shipment quantity is 5 and in legacy 3 quantity already received and 2 quantity already billed then we need to Import that legacy PO Line in Oracle with (PO Shipment and 1 distribution)-
Oracle PO Shipment Quantity: 5
Oracle PO Shipment Quantity Received: 3
Oracle PO Shipment Quantity Accepted : 3 [If Routing is Inspection Required, else 0]
Oracle PO Shipment Quantity Billed: 2
Oracle PO Distribution Quantity Delivered: 3
Oracle PO Distribution Quantity Billed: 2

Does Oracle Purchasing PDOI (Purchasing Documents Open Interface) support this functionality?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.