OBIA 11g ETL Failed Due To Duplicates After Loading W_PSFT_SUPERVISOR_EQ_TMP Table (Doc ID 1929082.1)

Last updated on DECEMBER 16, 2015

Applies to:

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

Symptoms

Mapping: SDE_PSFT_91_ADAPTOR_SDE_PSFT_ASSIGNMENTSUPERVISORDIMENSION_EVENTQUEUE fails with following error:

Error: ORA-20000: Error creating Index/Constraint : W_PSFT_SUPERVISOR_EQ_TMP_U1 => ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Unique key in W_PSFT_SUPERVISOR_EQ_TMP table is DATASOURCE_NUM_ID,EMPLID,EMPL_RCD.

 

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