OBIA 7964 MESSAGE :::Error While Execution : CREATE UNIQUE INDEX W_GL_GRP_ACT_D_U1 (Doc ID 1961613.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

BI Apps 7.9.6.4

When loading ETL for financials it fails in PLP_GLGroupAccountDimension ===> Create Index W_GL_GRP_ACT_D_U1 (ETL)

2014-12-30 18:31:25.306 Acquiring Resources
2014-12-30 18:31:25.307 Acquired Resources
2014-12-30 18:31:25.308 CREATE INDEX:W_GL_GROUP_ACCOUNT_D:W_GL_GRP_ACT_D_U1 has started.

ANOMALY INFO::: Error while executing : CREATE INDEX:W_GL_GROUP_ACCOUNT_D:W_GL_GRP_ACT_D_U1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_GL_GRP_ACT_D_U1
ON
W_GL_GROUP_ACCOUNT_D
(
INTEGRATION_ID ASC
,DATASOURCE_NUM_ID ASC
)
NOLOGGING
with error DataWarehouse:CREATE UNIQUE INDEX
W_GL_GRP_ACT_D_U1
ON
W_GL_GROUP_ACCOUNT_D
(
INTEGRATION_ID ASC
,DATASOURCE_NUM_ID ASC
)
NOLOGGING
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