My Oracle Support Banner

Stock on Hand out of Sync in RMS and SIM After Posting a Late Sales (Doc ID 2499490.1)

Last updated on DECEMBER 04, 2019

Applies to:

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


When Late sale is posted in SIM, Stock on hand(SOH)/Total_quantity is out of sync in Retail Merchandising System (RMS) and Store Inventory Management (SIM).

Steps To Recreate:

1. Create the stock count for 08-NOV-2018 for all items and auto authorize on.
2. Upload the file in SIM on the same day night (08-nov-2018 8 PM) and run the corresponding batches for SIM and RMS to process the stock count in both SIM and then in RMS. This stock count is processed in RMS and STKVAR ran in nightly when vdate is 08-NOV-2018.
3. Process the sales the next day for both RMS and SIM for transaction date of 8-NOV-2018. Means, this sales processed in RMS when VDATE is 09-Nov-2018.
4. After sales processed in RMS and SIM, observe, SIM and RMS SOH is not in sync.




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.