My Oracle Support Banner

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 later
Information 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


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