SDE_FUSION_Absence_EventFact.W_ABSENCE_EVENT_FS Fails with A Unique Constraint Error

(Doc ID 2384604.1)

Last updated on MAY 08, 2018

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.2 [Release 11g]
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.10.2 version with Fusion 12c Source


The scenario SDE_FUSION_Absence_EventFact.W_ABSENCE_EVENT_FS fails with unique constraint error during the execution of a full load.

ORA-00001: unique constraint on INTEGRATION_ID,DATASOURCE_NUM_ID

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