OBIA 7964:Task "SDE_ORA_BOMItemFact" Failed During ETL Load With The Error Message 'Error while execution : CREATE UNIQUE INDEX W_BOM_HEADER_DS_U1' Error: "ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found"

(Doc ID 2353544.1)

Last updated on JANUARY 26, 2018

Applies to:

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

Symptoms

Problem Summary
---------------------------------------------------

OBIA 7964:Task "SDE_ORA_BOMItemFact" Failed During ETL Load With The Error Message 'Error while execution : CREATE UNIQUE INDEX W_BOM_HEADER_DS_U1'
Error: "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found"

Problem Description
---------------------------------------------------
OBIA 7964 Task "SDE_ORA_BOMItemFact" Failed During ETL Load With The Error Message 'Error while execution : CREATE UNIQUE INDEX W_BOM_HEADER_DS_U1'
--------------------------------------------------------------------------

Task Create_W_BOM_HEADER_DS_U1 Index failed

2017-12-28 04:30:30.584 Acquiring Resources

2017-12-28 04:30:30.585 Acquired Resources


2017-12-28 04:30:30.586 SDE_ORA_BOMItemFact:PRECEDING_ACTION:"Create_W_BOM_HEADER_DS_U1 Index" template has started.



ANOMALY INFO::: Error while executing : SDE_ORA_BOMItemFact:PRECEDING_ACTION:"Create_W_BOM_HEADER_DS_U1 Index" template
MESSAGE:::
Irrecoverable Error
Running Custom Sql list SDE_ORA_BOMItemFact:PRECEDING_ACTION:"Create_W_BOM_HEADER_DS_U1 Index" template


Source: "ORA_R1213"
Tables:
FND_LOOKUP_VALUES
W_BOM_HEADER_DS
BOM_EXPLOSION_TEMP

Target: "DataWarehouse"
Tables:
W_BOM_ITEM_FS
OPI_OBIA_W_BOM_HEADER_DS

Default retries for this custom SQL is 1.

executing sql (Create U1 Index:DataWarehouse)
CREATE UNIQUE INDEX W_BOM_HEADER_DS_U1 on W_BOM_HEADER_DS(INTEGRATION_ID, DATASOURCE_NUM_ID, SRC_EFF_FROM_DT)

"Create U1 Index" failed on "DataWarehouse"
SQL: CREATE UNIQUE INDEX W_BOM_HEADER_DS_U1 on W_BOM_HEADER_DS(INTEGRATION_ID, DATASOURCE_NUM_ID, SRC_EFF_FROM_DT)
Error: MESSAGE:::ORA-01452: cannot CREATE UNIQUE INDEX; 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