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