OBIA11g: Inserting a New Record in Type2 SCD Employee Dimension Ends in Duplicates
Last updated on MARCH 30, 2018
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
BI Apps 22.214.171.124 and higher
Financial Analytics, Project Analytics, Procurement and Spend Analytics, Supply Chain and Order Management Analytics, HR Analytics
A record with integration_id 'X' with effective_to_dt as '3712/01/01' for example is present in the type2 dimension. When the new record with same integration_id 'X' is inserted into the table, the older record effective_to_dt must be updated to Current record Effective_from_dt. But the older record is not getting updated. Due to this multiple records with effective_to_dt as '3712/01/01' for the same integration_id are being seen.
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