OBIA 11g ETL fails Due With "ORA-01452: Cannot CREATE UNIQUE INDEX; Duplicate Keys Found" For W_GL_ACCOUNT_DS_U1 (Doc ID 2166170.1)

Last updated on JUNE 06, 2017

Applies to:

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

Symptoms

SDE_ORAR1213_ADAPTOR_SDE_ORA_GLACCOUNTDIMENSION is failing with error "ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found" on W_GL_ACCOUNT_DS_U1.

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