While Receiving a Fully Allocated PO the Quantities Does Not Match (Doc ID 2795389.1)

Last updated on OCTOBER 02, 2022

Applies to:

Symptoms

While receiving a fully allocated PO(purchase order), the quantities do not match in the event of receiving over the quantities ordered.
The process is made by customer on an environment where a PO is uploaded with an Allocation using the 'Upload Orders from File' functionality from RMFCS user interface.

Steps to replicate the issue, provided by customer:

1. Created a fully allocated PO, with qty 70, (supplier delivers to a Warehouse, cross docked to store).
2. Receipt integrated from the Warehouse, with 2 ReceiptDtl - each ReceiptDtl with a different carton for the same SKU with total of 70.09 (one container with 35.04, and the other with 35.05).
3. Receipt was integrated successfully (the payload was generated with the correct quantities - please refer to the Receipt_payload.xml), Shipment and Receipt were processed but in the:
    3.1. SHIPSKU table records were created, but with the wrong quantities in the second row (34.95 instead of 35.04).
    3.2. ORDLOC table records were updated, but with wrong quantities in the QTY_RECEIVED (70 instead of 70.09).
    3.3. ALLOC_DETAIL table records were updated, but with wrong quantities in the PO_RCVD_QTY (70 instead of 70.09).
    3.4. TRAN_DATA_HISTORY table records were created with the correct quantities (entries 35.05 and 35.04), like the Receipts payload.
4. Shipment from the Warehouse to Store was successfully integrated.
   4.1. BOL created with the correct quantities (entries 35.05 and 35.04) .
   4.2. TRAN_DATA_HISTORY table records were created with the correct quantities (entries 35.05 and 35.04).

Cause

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