BI Apps 11.1.1.8.1 - HR Analytics - EBS 12.1.3: ORA-20000: Error creating Index/Constraint :W_WRKFC_EVT_AGE_F_U1 => ORA-02299: cannot validate (<schema name>.W_WRKFC_EVT_AGE_F_U1_UC) - duplicate keys found (Doc ID 1991645.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

In OBIA 11.1.1.8.1, after upgrading to EBS12.1.3, the Data Load fails with the following error during FULL load:

 ORA-20000: Error creating Index/Constraint :W_WRKFC_EVT_AGE_F_U1 => ORA-02299: cannot validate (<schema name>.W_WRKFC_EVT_AGE_F_U1_UC) - duplicate keys found

 

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