XITEM API Child Item LAST_UPDATE_DATETIME Not Updated after Parent Item Is Updated

(Doc ID 2242689.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Retail Merchandising System - Version 14.1.2 and later
Information in this document applies to any platform.


XITEM API- Child item's LAST_UPDATE_DATETIME is not getting updated after the parent item is updated.

When a parent item's FORECAST_IND is updated thru the XITEM API, this update is also applied to it's child items, as expected.
However, the LAST_UPDATE_DATETIME column only gets updated for the parent item, leaving this column inconsistent for the child item.

Steps to Reproduce:
1. Create a parent item thru the xitem API (xitemcre), with FORECAST_IND=N.
2. Create a child item for this item through the xitem API (xitemcre).
3. Update the parent_item through the xitem API(xitemmod), setting it's FORECAST_IND to Y.
4. Check the ITEM_MASTER table, the LAST_UPDATED_DATETIME will be incorrect for the child item.

Relying on this field to control changes to item data.




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