My Oracle Support Banner

OBIA 11g: SIL_ARTRANSACTIONFACT_DIFFMANLOAD Index Create Using Same Column Name (Doc ID 2626357.1)

Last updated on JANUARY 13, 2020

Applies to:

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

Symptoms

OBIA 11.1.1.10.2

After the upgrade from OBIA 11.1.1.8.1 to 11.1.1.10.x the following issue shows while executing the main Load Plan, error creating indexes for index W_AR_XACT_F_PSR1 ETL:

Both index W_AR_XACT_F_PSR1 and W_AR_XACT_F_M7 are indexed on the same column. These are both constraints in the mappings in the ETL.

Changes

 Recent upgrade from 11.1.1.8.1 whether to 11.1.1.9.2 or 11.1.1.10.x.

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
Changes
Cause
Solution


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