FND_FLEX_VALUE_SETS.CREATION_DATE Always 15-Dec-2001 When Creating Value Set in PIM (Doc ID 2100111.1)

Last updated on FEBRUARY 22, 2016

Applies to:

Oracle Product Hub - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Actual Behavior
CREATION_DATE/LAST_UPDATE_DATE in FND_FLEX_VALUE_SETS are always 15-Dec-2001 when creating Value set in PIM.

Expected Behavior
It should use SYSDATE as the value. Not a constant value.

Steps to Reproduce

  1. Create a new value set
    (N)Setup > Setup Workbench (T)Value Set

      Value Set Name : XXXX_VS_20_NOV_2015
      Data type : Char
      Maximum Size : 150
      Validation Type : None
  2. Check FND_FLEX_VALUE_SETS  ==>CREATION_DATE/LAST_UPDATE_DATE in FND_FLEX_VALUE_SETS are always '2001/12/15'

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