My Oracle Support Banner

Duplicate Inventory History Impacts Inventory Summary Report (Doc ID 2448771.1)

Last updated on SEPTEMBER 24, 2018

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

Symptoms


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.



STEPS
-----------------------
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

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.