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!