Duplicate PO Lines Are Created When Supplier Item (Vendor_Product_Num) Is Modified Using PDOI
(Doc ID 2143523.1)
Last updated on MAY 02, 2022
Applies to:Oracle Purchasing - Version 12.2.3 and later
Information in this document applies to any platform.
Can you modify the Supplier Item on a BPA PO Line (corresponding Database Field is "Vendor_Product_Num") using the PDOI interface?
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.
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