OBIA 11g: Duplicate Records In Employee Dimension: all the EFFECTIVE_TO_DT is '01-JAN-14' and CURRENT_FLG is 'Y' for all the records (Doc ID 1617427.1)

Last updated on JANUARY 30, 2017

Applies to:

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

Symptoms

OBIA 11.1.1.7.1
Oracle EBS 12.1.3

After loading Employee dimension the employee dimension is getting populated with huge number of duplicates.
Unfortunately all the EFFECTIVE_TO_DT is '01-JAN-14' and CURRENT_FLG is 'Y' for all the records.
Though SRC_EFF_FROM_DT, SRC_EFF_TO_DT is showing correct value.

This fact is causing duplicate records in all the subsequent fact. and causing wrong output in BI reports.

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