My Oracle Support Banner

Deletion of a Return Creates a Mismatch in RMS Non-Sellable Inventory (Doc ID 1941500.1)

Last updated on MARCH 09, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 13.1.4 to 13.1.9 [Release 13.1]
Information in this document applies to any platform.


In Store Inventory Management (SIM) 13.1.x, we find that when a Return To Warehouse (RTW) is created with an item that has unavailable inventory, and if the RTW is created to return the unavailable inventory back to the warehouse, SIM creates an unnecessary inventory adjustment with reason code as "Returns" and publishes it to Retail Merchandising System (RMS).  When RMS consumes the incoming inventory adjustment message, the unavailable stock increases in RMS and the Stock On Hand (SOH) between SIM and RMS go out of synch.

Steps to Recreate:

  1. Find an item+store combination, and ensure that the item has some unavailable inventory.
  2. Create a RTW for this item, so that the return is created for the entire unavailable inventory.  Ensure that you select "Yes" at the prompt that asks if the unavailable inventory should be used.  Also ensure that the reason code selected is "Unavailable inventory".
  3. Click on 'Done' (do not click on 'Dispatch') and note that SIM publishes an InvAdjCre message as well as a SoStatusCre message to RMS.
  4. Delete the RTW from Step 2 that is in 'Pending' status.
  5. Observe that SIM only publishes the 'SoStatusMod' message to RMS.
  6. Check the ITEM_LOC_SOH database table in RMS and note that the NON_AVAILABLE_QTY has increased by the RTW quantity, whereas the RK_STORE_ITEM_SOH.ADJUST_UNAVAIL_QTY value in SIM is reset back to the original unavailable quantity.




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.