My Oracle Support Banner

Stock On Hand Discrepancy Between Store Inventory Management (SIM) And Retail Merchandising System (RMS) (Doc ID 1338054.1)

Last updated on MARCH 02, 2018

Applies to:

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


In Store Inventory Management (SIM) system, find that the stock on hand (SOH) is different when compared to the one from Retail Merchandising System (RMS).

Steps To Recreate:

  1. Create new transfer from store S1 to store S2 in SIM.
  2. Add item A to this transfer.
  3. Add item B to this transfer.
  4. Click on Done.
  5. Check in RMS and observe the values from ITEM_LOC_SOH table for TSF_RESERVED_QTY & TSF_EXPECTED_QTY columns.
  6. Check in SIM and observe the values from RK_STORE_ITEM_SOH for RESERVED_QUANTITY columns.
  7. Reopen the Transfer and in place of item A id insert item C id and fill some quantity.
  8. After entering new quantity for C item push Dispatch button.
  10. Check table ITEM_LOC_SOH.TSF_RESERVED_QTY & TSF_EXPECTED_QTY - for item B&C the values OK, but for item A are the same as in step 5.


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.