OBIA 7964 Unable To Create Unique Index W_MCAL_YEAR_D_P1: Duplicate Records Found (Doc ID 1960445.1)

Last updated on AUGUST 09, 2016

Applies to:

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

Symptoms

This is regarding failure of DAC sub task while creating W_MCAL_YEAR_D_P1 in SIL_TimeDimension_MCalYear. On verifying we noticed some duplicates in ROW_WID

Investigating further, for W_MCAL_PERIOD_D, value of MCAL_CAL_WID||MCAL_YEAR is duplicate.
We are using value 

$$GBL_CALENDAR_ID as PXR USF ACCTG~Month

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