Warehouse to Store Auto Received Shipment Quantity Not Updated For All Line Items in SIM
(Doc ID 2724561.1)
Last updated on JULY 17, 2023
Applies to:
Oracle Retail Store Inventory Management - Version 16.0 and laterInformation in this document applies to any platform.
Symptoms
When an (Advanced Shipment Notification) ASNIn message contains the same line item in 2 different containers, with Auto Receive set to Date Driven, not all items are being counted for the roll up during the receiving process in SIM.
The following messages are consumed by SIM:
Steps to Reproduce:
WAREHOUSE_AUTO_RECEIVE 2
WAREHOUSE_AUTO_RECEIVE_NUMBER_OF_DAYS 0
1. Auto Receive indicator enabled in SIM
2. Create a DC to ST Allocation
3. Wave the allocation in DC
4. Make sure the item is in multiple active locations in the DC
5. Pick the order in DC
6. Pack the order in DC
7. Ship/Close the manifest in DC
8. Check in SIM, order is only partially received and shipment is completed
9. Check in RMS, shipment will be open i.e., residual IN_TRANSIT
10. Check TRAN_DATA, TC 44 will be posted with 0 Units.
TSF_ALLOCATION
QUANTITY_EXPECTED QUANTITY_RECEIVED
-------------------------------------------
2 1
-------------------------------------------
TSF_DELV_LINE_ITEM
ITEM_ID QUANTITY_EXPECTED QUANTITY_RECEIVED
--------------------------------------------------------------
6004720446 1 1
6004720446 1
--------------------------------------------------------------
STORE_ITEM_STOCK
ITEM_ID STORE_ID QUANTITY_TOTAL QUANTITY_IN_TRANSIT
--------------------------------------------------------------------
6004720446 440095 1 0
--------------------------------------------------------------------
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |