ITEM_SUPP_COUNTRY_DIM Overwrites CREATE_DATETIME Column When Processing an Update Message (Doc ID 2188420.1)

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

ITEM_SUPP_COUNTRY_DIM.CREATE_DATETIME is being overwritten with the current timestamp when an ISCD_UPD message is sent thru the XItem API.
This behavior should only occur for the ITEM_SUPP_COUNTRY_DIM.LAST_UPDATE_DATETIME column.


Steps to Reproduce:

  1. Create an item with dimensions.
  2. Check the CREATE_DATETIME value for this item/supplier in the ITEM_SUPP_COUNTRY_DIM table.
  3. Update this ITEM_SUPP_COUNTRY_DIM record thru the XITEM api with an "ISCD_UPD" message.
  4. Check the CREATE_DATETIME value for this item/supplier again.  Note that the CREATE_DATETIME value has changed. It was replaced by the current timestamp, same as the LAST_UPDATE_DATIME field.

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