My Oracle Support Banner

OBIA11g: Inserting a New Record in Type2 SCD Employee Dimension Ends in Duplicates (Doc ID 2349873.1)

Last updated on FEBRUARY 22, 2019

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

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.