My Oracle Support Banner

STORE_ITEM_STOCK_HIST Incorrect When Receiving Unavailable Transfer Shipment (Doc ID 2583432.1)

Last updated on NOVEMBER 02, 2021

Applies to:

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


When a transfer is received  with unavailable inventory, the receiving store's QUANTITY_NON_SELLABLE, and STORE_ITEM_STOCK_NON_SELL is correctly updated, however the record in STORE_ITEM_STOCK_HISTORY shows delta in QUANTITY_TOTAL_DELTA but not in QUANTITY_NON_SELLABLE_DELTA.

Steps to Reproduce:

1. Create a transfer for unavailable inventory in SIM PC client.
2. Create a shipment for unavailable inventory on MAF handheld and attach it to the transfer.
3. Dispatch shipment.
4. Receive shipment.
5. Note that the QUANTITY_NON_SELLABLE has been updated, but there is no record to indicate that in STORE_ITEM_STOCK_HISTORY.
6. Note that "useUnavailable" is set to true in ASNOut message, but set to false in ReceiptCre Message.




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

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