My Oracle Support Banner

No Inventory (NI) Sostatus Message is Decrementing Twice TSF_RESERVED_QTY and TSF_EXPECTED_QTY on ITEM_LOC_SOH (Doc ID 2247286.1)

Last updated on APRIL 16, 2020

Applies to:

Oracle Retail Merchandising System - Version 14.1 to 14.1.3 [Release 14.1]
Information in this document applies to any platform.


No Inventory (NI) Sostatus message is decrementing twice TSF_RESERVED_QTY and TSF_EXPECTED_QTY on ITEM_LOC_SOH table.

Steps To Recreate:

1. Create a Warehouse to store transfer in RMS.

2. Note that the TSF_RESERVED_QTY and TSF_EXPECTED_QTY were populated in ITEM_LOC_SOH table correctly.

3. Send an Sostatus message NI against this stock order.

4. Note that the TSF_RESERVED_QTY and TSF_EXPECTED_QTY were decremented twice and become negative.


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.