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 188.8.131.52.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document