My Oracle Support Banner

Modification From RMS For LWH_UOM And WEIGHT_UOM Of Items Did Not Update RWMS (Doc ID 2557812.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Warehouse Management System - Version 13.2.4 and later
Information in this document applies to any platform.


The modification coming from Retail Merchandising System(RMS) for the Dimension and weight of the items does not update Retail Warehouse Management System(RWMS) in ITEM_SUPP_COUNTRY_DIM table.

Steps To Recreate:

1. Make sure in OVERWRITE_SETUP_COLUMNS table, OVERWRITE_COLUMN is Y for the column_name  "LWH_UOM" and "WEIGHT_UOM" and table_name "ITEM_SUPP_COUNTRY_DIM" 
        FACILITY_ID    TABLE_NAME                               COLUMN_NAME                 OVERWRITE_COLUMN 
        XX                   ITEM_SUPP_COUNTRY_DIM         WEIGHT_UOM                   Y 

Steps to change the value of OVERWRITE_COLUMN from N to Y:
a. RWMS GUI > Main Menu,
b. select Support Functions > Item Setup > Item 
Field Ownership 
c. Change the setting to 'Host' for the given field. 

Steps to Reproduce:
1. Edit the item "ITEM1" in RMS.

2. Modify the LHW_UOM from IN  to M and WEIGHT_UOM from LBS to LB.
3. Notice, changes are not reflected in RWMS ITEM_SUPP_COUNTRY_DIM 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!

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.