Wrong Status in SIM Warehouse_Item Table After It Was Modified in RMS
Last updated on DECEMBER 20, 2017
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).
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 hundreds of Community platforms