Catchweight_uom Field Information Updated As Null Through XITEMMOD Message
Last updated on JULY 25, 2017
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, as per the attache stub create_regular_item_CW.sql (catchweight_ind='Y'/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.
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