OBIA11g: Inserting a New Record in Type2 SCD Employee Dimension Ends in Duplicates

(Doc ID 2349873.1)

Last updated on MARCH 30, 2018

Applies to:

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

Symptoms

BI Apps 11.1.1.8 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.


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