My Oracle Support Banner

Wrong Status in SIM Warehouse_Item Table After It Was Modified in RMS (Doc ID 2340051.1)

Last updated on MAY 27, 2020

Applies to:

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


 In Oracle Retail Store Inventory Management (SIM), WAREHOUSE_ITEM table contains the item to warehouses relationship and item's status.
In Oracle Retail Merchandising System (RMS) side, ITEM_LOC table holds the data for this combination.

After status modification in RMS, ITEM_LOC table is updated to reflect the new status, but the status in the SIM WAREHOUSE_ITEM table remains unchanged.

Steps to Recreate:

1. From RMS, create an item/loc for a warehouse.
2. Check if this item/loc was sent to SIM and updated in the WAREHOUSE_ITEM table.
3. From RMS, Change the status of the item/loc, and notice that it was updated in the RMS ITEM_LOC table.
4. Check and notice that the modification is not reflected on the SIM side (WAREHOUSE_ITEM table).


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.