My Oracle Support Banner

Stock on Hand Updates Incorrectly When Same Items are Added and Removed from Transfer (Doc ID 2460626.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

When a transfer shipment is completed in Store Inventory Management (SIM) with the same item added and removed from a transfer shipment list , it invariably causes a Stock on Hand (SOH) discrepancy and negative SOH is updated in Retail Merchandising System (RMS) and SIM.

Scenarios:

Case 1:

Initial stock position: Please note that below transfers are only created and shipped, not received. And all the transfers are created and received in SIM.

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 0 0 0 0
 B XXX 40 0 40 0

1. Create a transfer shipment to store A and add 10 quantity for the item and save. (Not confirming or shipping)

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 0 0 0 0
 B XXX 40 10 40 10

2. Get back into transfer and add the same item again and quantity10, save. (Not confirming or shipping)

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 0 0 0 0
 B XXX 40 20 40 20

3. Get back into transfer and delete the last row added, confirm and ship. Note SIM QUANTITY_RESERVED becomes negative 10

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 10 0 10 0
 B XXX 30 -10 30 -10


Case 2:

Initial stock position - Total SOH in both stores - 100: Please note that below transfers are only created and shipped, not received unless specified

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 6 0 6 0
 B XXX 94 0 94 0

1. Create a transfer to store B for quantity 4 and save

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 6 4 6 4
 B XXX 94 0 94 0

2. Get back into transfer and add same item, quantity 2 and save

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 6 6 6 6
 B XXX 94 0 94 0

3. Go back into transfer and remove the last item/quantity added and save. i.e. quantity 2. Notice warning - "All items with 0 or null quantity will be removed...” Click yes.
4. Go back into transfer, notice the UI shows transfer quantity as 4 which is correct as per user. But quantity reserved in both RMS/SIM is 2

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 6 2 6 2
 B XXX 94 0 94 0

5. Confirm and dispatch the transfer. Notice the negative QUANTITY_RESERVED in SIM.

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 2 -2 2 -2
 B XXX 94 0 94 0

6. Create another transfer to store B with same item. Note that UI now shows inventory as 4. Input quantity as 4 and save. Notice the positive Quantity_reserved 2 in SIM and 4 in RMS.

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX 2 2 2 4
 B XXX 94 0 94 0

7. Get back into transfer confirm and dispatch. Go to the receiving store and receive both transfers. Notice the final SOH. Negative SOH and qty_reserve in SIM. Negative SOH and positive reserved quantity in RMS.
Users had total SOH of only 100, but recorded as 102. Also sending store SOH resulted in negative 2 in RMS/SIM.

Sample Data
Store # Item # SIM SOH SIM Reserved Quantity RMS SOH RMS Reserved Quantity
 A XXX -2 -2 -2 0
 B XXX 102 0 102 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.