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

Last updated on MARCH 10, 2019

Applies to:

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 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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.