Requisition Loader Process (PO_REQLOAD) Fails with ORA-01427 Error at Step PO_REQLOAD.RL660A.UPDUPN (Doc ID 2673164.1)

Last updated on FEBRUARY 27, 2023

Applies to:

Symptoms

Requisition Loader process fails at Step PO_REQLOAD.RL660A.UPDUPN while processing requisitions for the same item configured with multiple units of measures (UOM) associated with different GTIN numbers (Global Trade Item numbers).

The following error occurs:

Steps to Reproduce the Issue:

1. Go to Items > Define Items > Pick an item with multiple UOMs. In the Purchasing Attributes (Item Supplier UOM), setup a supplier for both the UOMs. Note: Default UOM in EA
2. Setup Mfg ID and Mfg item ID for the item, with default ID type as GTIN. Configure different GTINs for both the UOMs (EA and BX)
3. Go to Purchasing > Requisitions > Stage for Loading. Stage the first Requisition for processing with UOM Each (EA), by doing the following: Fill in the requestor and the item ID that was earlier configured with multiple GTINs. Select the supplier that was earlier configured for the item. Put in the Quantity. Note: UOM will be set to the default UOM (EA) after entering the Quantity.
4. Save this transaction. This completes the staging of the first requisition.
5. Now go back to the Purchasing Attributes setup in the Item Definition and change the default UOM to Box (BX), which was earlier ‘EA’.
6. Stage the second Requisition for processing with UOM BX, using the same steps as above. Note: UOM will be set to the new default UOM (BX) after entering the Quantity.
7. Save this transaction. This completes the staging of the second requisition.
8. Run the Requisition Loader process to process both staged requisitions. The above Error occurs.

Changes

 N/A

Cause

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