My Oracle Support Banner

Unavailable Inventory does not Increase Total Stock On Hand for Transfer Receiving (Doc ID 2416477.1)

Last updated on JULY 05, 2018

Applies to:

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

Symptoms

In Store Inventory Management(SIM) application, find that, when transfers are received that contain unavailable inventory, the Inventory buckets do not update appropriately.

Steps to Reproduce :

1. Create a transfer document using unavailable on hands of an item
2. Move an item to a trouble bucket via an Inventory Adjustment if needed (Stock Hold in this case)

Before moved to trouble bucket (sending location Store 1):

Total SOH = 102
Available SOH = 102
Unavailable = 0

After moving 23 to trouble bucket:

Total SOH = 102
Available SOH = 79
Unavailable = 23

Item Lookup for receiving location (Store 2):

Total SOH = 43
Available SOH = 43
Unavailable = 0

Transfer Document for Store 1:

4. Create a transfer shipment containing the unavailable item
5. Confirm and Dispatch the transfer

Note inventory at each location:
Sending location (decremented correctly):
Receiving location (correct inbound quantity):
Receive the transfer (default qty, confirm)
Note inventory at receiving location (unavailable quantity has been increased correctly, but total stock on hand remains unchanged and the Available SOH has incorrectly decreased):

Additionally, if the inventory is moved from the unavailable/trouble bucket back to the available bucket (Ready to Sell in this case), the total stock on hands still remains unchanged, but unavailable inventory is decremented. Note Available SOH increases as expected.

 

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.