My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2021

Applies to:

Oracle Retail Store Inventory Management - Version 15.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.

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!

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