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
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
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.
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