SIL_TimeDimension_MCalYear Mapping fails during an Incremental Load after the addition of new Periods to the Source OLTP data (Doc ID 1448117.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms


BI Apps 7.9.6.3 ETL fails with the following error :-

ANOMALY INFO::: Error while executing : CREATE INDEX:W_MCAL_YEAR_D:W_MCAL_YEAR_D_P1
MESSAGE:::java.lang.Exception: Error while execution : CREATE UNIQUE INDEX
W_MCAL_YEAR_D_P1
ON
W_MCAL_YEAR_D
(
ROW_WID Asc
)
NOLOGGING
with error DataWarehouse:CREATE UNIQUE INDEX
W_MCAL_YEAR_D_P1
ON
W_MCAL_YEAR_D
(
ROW_WID Asc
)
NOLOGGING

 

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