OBIA 11g: Duplicated Rows For W_INT_ORG_DS_TL With Tree WPO_PROGRAM_UNIT Causes Error "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found" (Doc ID 1616131.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

In OBIA 11.1.1.7.1 with PeopleSoft FSCM 9.1:

The following error occurs when loading tree “WPO_PROGRAM_UNIT” with tree Structure ID”WPO_UNIT_CODE” for the Cost Center Dimension.

ODI-1519: Serial step "Start Load Plan (InternalID:31968500)" failed because child step "Global Variable Refresh (InternalID:31969500)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:31969500)" failed because child step "Warehouse Load Phase (InternalID:32556500)" is in error.
ODI-1519: Serial step "Warehouse Load Phase (InternalID:32556500)" failed because child step "1 SIL Load (InternalID:32557500)" is in error.
ODI-1519: Serial step "1 SIL Load (InternalID:32557500)" failed because child step "2 SIL Dimension Group (InternalID:32558500)" is in error.
ODI-1519: Serial step "2 SIL Dimension Group (InternalID:32558500)" failed because child step "Parallel -Independent DimGroup (InternalID:32566500)" is in error.
ODI-1518: Parallel step "Parallel -Independent DimGroup (InternalID:32566500)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: 3 SIL Dims INTORG_DIM (InternalID:32597500)
ODI-1519: Serial step "3 SIL Dims INTORG_DIM (InternalID:32597500)" failed because child step "Finalize INTORG_DIM (InternalID:32604500)" is in error.
ODI-1519: Serial step "Finalize INTORG_DIM (InternalID:32604500)" failed because child step "EXEC_TABLE_MAINT_PROC (InternalID:32605500)" is in error.
ODI-1217: Session EXEC_TABLE_MAINT_PROC (47781500) fails with return code 20000.
ODI-1226: Step TABLE_MAINT_PROC fails after 1 attempt(s).
ODI-1232: Procedure TABLE_MAINT_PROC execution fails.
ODI-1228: Task TABLE_MAINT_PROC (Procedure) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20000: Error creating Index/Constraint : W_INT_ORG_D_TL_U1 => ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at line 1126

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