OBIA 11g: ETL fails with 'W_CUSTOMER_ACCOUNT_D_M1 => ORA-00968: missing INDEX keyword'

(Doc ID 1581140.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

Full load fails with the following error:

ORA-20000: Error creating Index/Constraint : W_CUSTOMER_ACCOUNT_D_M1 => ORA-00968: missing INDEX keyword
ORA-06512: at line 207

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