My Oracle Support Banner

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

Last updated on SEPTEMBER 02, 2020

Applies to:

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


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.




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

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