Duplicate PO Lines Are Created When Supplier Item (Vendor_Product_Num) Is Modified Using PDOI (Doc ID 2143523.1)

Last updated on MARCH 02, 2023

Applies to:

Goal

Can you modify the Supplier Item on a BPA PO Line (corresponding Database Field is "Vendor_Product_Num") using the PDOI interface?

For example,

Modifying the Supplier Item on a BPA PO Line (corresponding Database Field is "Vendor_Product_Num") using the PDOI interface; a new PO Line is created.

However, when we try to modify the Supplier Item on a BPA PO Line using Oracle UI screen (Purchase Order Summary); it updates that particular BPA Line without creating a new BPA Line.

The data is initially inserted into PO_HEADERS_INTERFACE and PO_LINES_INTERFACE. The value for the "ACTION" field is given as "UPDATE".
Then, call is made to the PO_PDOI_GRP.start_process to process the records in the interface.

Within the Oracle Standard Packages namely PO_PDOI_MAINPROC_PVT (or) PO_PDOI_LINE_PROCESS_PVT ; validations are performed to check uniqueness.

In situations, where the Vendor_Product_Num value changed; the Oracle Validation code changes the "ACTION" mode from "UPDATE" to "ADD".

Due to this a new BPA Line is created instead of modifying existing BPA Line.
 

Solution

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