Catchweight_uom Field Information Updated As Null Through XITEMMOD Message (Doc ID 2268356.1)

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.

Symptoms

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.


Changes

 

Cause

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