OBIA 7964 Unable To Create Unique Index W_MCAL_YEAR_D_P1: Duplicate Records Found
Last updated on AUGUST 09, 2016
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199 and later
Information in this document applies to any platform.
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
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