My Oracle Support Banner

OBIA11.1.10.3 PS4: Duplicate Records Inserted In SIL Job In Autocorrect Mode (Doc ID 3065179.1)

Last updated on JANUARY 09, 2025

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.3 - PS4 - Patch Set 4 and later
Information in this document applies to any platform.

Symptoms

OBIA 10.3 PS4: Duplicate records inserted in SIL job in autocorrect mode

OOTB SIL mappings re-inserts data when it runs again in autocorrect mode after failure. This jobs fails in 'Update Existing Rows' step due to a known source data issue.

This job uses IKM BIAPPS Oracle Slowly Changing Dimension, and insert new dimensional records step is already run when it fails on update step. After failure when it restarts in autocorrect mode, the same records are inserted again in insert new dimensional records.

This feature is working fine in ODI 11g and everything matches. 


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.