Incorrect Update of In Transit Quantity when a Received Transfer is Adjusted (Doc ID 2279183.1)

Last updated on JULY 05, 2017

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 a received transfer is adjusted, the in transit quantity is wrongly updated.


Steps to reproduce:
1. Create a store to store transfer for 10 units.
2. Ship and dispatch 10 units. Notice that STORE_ITEM_STOCK.QUANTITY_IN_TRANSIT column is updated as10.
3. In receiving store, receive 0 units and confirm. Notice that STORE_ITEM_STOCK.QUANTITY_IN_TRANSIT is 0.
4. Adjust received qty from 0 to 3 and confirm. Notice the STORE_ITEM_STOCK.QUANTITY_IN_TRANSIT is updated incorrectly to -10. It should be 0.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms