Duplicate Inventory History Impacts Inventory Summary Report
(Doc ID 2448771.1)
Last updated on MARCH 27, 2019
Applies to:Oracle Warehouse Management Enterprise Edition Cloud Service - Version 8.0.2 to 9.0.0 [Release 8.0.0 to 9.0.0]
Information in this document applies to any platform.
Problem version 8.0.2
Duplicate Inventory History is written for the same group number and same Item and same LPN. System should not write same Inventory History for the same group number and same Item and same LPN.
1) Create PO(TEST_PO1) with Item(SKUA) with Order_qty = 10.
2) Create Shipment(ASNJHB00540028) from PO Header.
3) Received above Shipment in the same IBLPN(513685) using Sort Receive QTY RF Screen.
a) Scanned the Receiving station(RTN039S_).
b) Scanned the IB Load(LASNJHB00540028).
c) Scanned the Item(SKUA).
d) Scanned the same Tote(513685)(I have reused the LPN) and I ended the Tote and I scanned the Tote again.
4)Here two Inventory History record got written below is the issue.
(Group No:93449914, Activity Code:1 - LPN Received, LPN:513685,Adj Qty =10,PO_Nbr:TEST_PO1, ASN_Nbr:ASNJHB00540027)).
(Group No:93449914, Activity Code:1 - LPN Received, LPN:513685,Adj Qty =10,PO_Nbr:TEST_PO1, ASN_Nbr:ASNJHB00540028)).
Due to this issue, data discrepancy happens in Inventory Summary Report
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