Incorrect Received Quantity In Allocation Detail When Allocation Is Received For A Different ASN (Doc ID 2207012.1)

Last updated on APRIL 19, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

Incorrect Received Quantity in Allocation Detail when allocation is received for a different ASN

Scenario 1:
1- Create PO for 1200 units
2- Create alloc based on PO for 1200 units
3- Receive PO.
4- Ship Alloc for Qty 200 in shmpnt1
5- Receive a different shipment ASN (shpmnt2) using rcptCre message, for this alloc with Qty 200.
Note: Business scenario, while shipping space was found on shpmnt2 and item was loaded without updating shmpnt1 info.
Result: alloc_Detail received quantity is now 400

Scenario 2:

1.Create allocation for unit_qty "10".
2.Shipped the same with container_id "1234" and receive the same with container_id NULL
Check ITEM_LOC_SOH table.in_transit_qty is "-10".(negative)
Check ALLOC_DETAIL table ."QTY_RECEIVED" is "20"
Check Shipsku table .QTY_RECEIVED is still zero.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms