Catchweight_Uom Field Information Updated As Null Through XITEMMOD Message
(Doc ID 2268356.1)
Last updated on MARCH 10, 2019
Applies to:Oracle Retail Merchandising System - Version 14.1.2 and later
Information in this document applies to any platform.
When an an item is created through the XITEM API(xitemcre), with catchweight_ind='Y' and catchweight_uom='KG' this information gets properly saved in the ITEM_MASTER.
However, when the same item is modified through an xitemmod message, the catchweight_uom field information is set to NULL in the ITEM_MASTER table.
Steps to Reproduce:
1. Create a catchweight item thru the xitem API with catchweight_ind='Y' and catchweight_uom='KG'.
2. Check the item_master table, these fields will be properly filled.
3. Update this same item using an xitemmod message, as per the attached stub update_regular_item_CW.sql. (catchweight_ind='Y'/catchweight_uom='KG').
4. Check the item_master table, the catchweight_uom field data is gone.
The same issue also happens for the "catch_weight_type" field for pack items.
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