My Oracle Support Banner

Status For Records In WAREHOUSE_ITEM From SIM Is Not Being Updated When The Status Is Changed In RMS (Doc ID 2969161.1)

Last updated on AUGUST 21, 2023

Applies to:

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

Symptoms

Status for the WAREHOUSE_ITEM records in SIM is not being updated when the corresponding Item status is changed in RMS ITEM_LOC to 'C'.

Steps to reproduce:

1. Change the status for a virtual warehouse/item in RMS (ITEM_LOC);
2. Notice the corresponding ItemLocMod message in the MPS_STAGED_MESSAGE table in SIM referencing the physical warehouse;
3. Notice the status in the warehouse_item table in SIM was not changed accordingly.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.