My Oracle Support Banner

OBIA 7.9.6.4: Error While CREATE INDEX:W_SALES_BACKLOG_LINE_F:W_SLS_BCK_LN_F_U1 Error "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found" (Doc ID 2385460.1)

Last updated on DECEMBER 03, 2021

Applies to:

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

Symptoms

On: Oracle Business Intelligence Applications

 

Execution plan failed with error. Task_Group_Load_BacklogFacts failed.

ANOMALY INFO::: Error while executing : CREATE INDEX:W_SALES_BACKLOG_LINE_F:W_SLS_BCK_LN_F_U1
  MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
  W_SLS_BCK_LN_F_U1
  ON
  W_SALES_BACKLOG_LINE_F
  (
  INTEGRATION_ID ASC
  ,DATASOURCE_NUM_ID ASC
  )
  NOLOGGING
  with error DW_PROD:CREATE UNIQUE INDEX
  W_SLS_BCK_LN_F_U1
  ON
  W_SALES_BACKLOG_LINE_F
  (
  INTEGRATION_ID ASC
  ,DATASOURCE_NUM_ID ASC
  )
  NOLOGGING
  ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.