OBIA 11g: Error creating unique Index/Constraint W_ORA_PURCH_AGREEMENT_PS_U1 due to ORA-01452 (Doc ID 2078729.1)

Last updated on DECEMBER 04, 2015

Applies to:

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

Symptoms

Error creating unique Index/Constraint W_ORA_PURCH_AGREEMENT_PS_U1 ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found ;ORA-06512: at line 233

ODI-1519: Serial step "Start Load Plan (Internal ID:114411500)" failed because child step "Global Variable Refresh (Internal ID:114412500)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:114412500)" failed because child step "Source Extract Phase (InternalID:114416500)" is in error.
ODI-1519: Serial step "Source Extract Phase (InternalID:114416500)" failed because child step "1 SDE Extract (InternalID:115005500)" is in error.
ODI-1519: Serial step "1 SDE Extract (InternalID:115005500)" failed because child step "2 SDE Fact Group (InternalID:115006500)" is in error.
ODI-1519: Serial step "2 SDE Fact Group (InternalID:115006500)" failed because child step "Parallel (Fact Groups) (InternalID:115074500)" is in error.
ODI-1518: Parallel step "Parallel (Fact Groups) (InternalID:115074500)" 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 SDE Fact PROCPO_FG (InternalID:115804500)
ODI-1519: Serial step "3 SDE Fact PROCPO_FG (InternalID:115804500)" failed because child step "Finalize PROCPO_FG (InternalID:115828500)" is in error.
ODI-1518: Parallel step "Finalize PROCPO_FG (InternalID:115828500)" 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: Finalize W_ORA_PURCH_AGREEMENT_PS (InternalID:115829500)
ODI-1519: Serial step "Finalize W_ORA_PURCH_AGREEMENT_PS (InternalID:115829500)" failed because child step "CREATE INDEXES (InternalID:115830500)" is in error.
ODI-1518: Parallel step "CREATE INDEXES (InternalID:115830500)" 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: Create Indexes : W_ORA_PURCH_AGREEMENT_PS 2/2 (InternalID:115832500)
ODI-1217: Session EXEC_TABLE_MAINT_PROC (358601500) 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_ORA_PURCH_AGREEMENT_PS_U1 => ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at line 233

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