OBIA Multi source Absence Event Fact Is Not Populated From the 2nd Source Onwards
(Doc ID 2189332.1)
Last updated on FEBRUARY 03, 2019
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
While configuring HR Analytics by extracting data from 9 EBS instances, the Absence Event Fact (W_ABSENCE_EVENT_F) is not getting populated from the 2nd source onwards. It is observed that the data is not getting populated into W_ABSENCE_EVENT_EQ_TMP table from the 2nd source. It is because of below filter conditions in SIL_AbsenceEventFact_EventQueue.W_ABSENCE_EVENT_EQ_TMP_SQ_W_ABSENCE_EVENT_DS interface has below filter conditions which is causing issue when we executed the ETL for 2nd source onwards..
W_ABSENCE_EVENT_DS.CHANGED_ON_DT > TO_DATE_VAR('#LAST_EXTRACT_DATE')
W_ABSENCE_EVENT_D.W_UPDATE_DT <= TO_DATE_VAR('#LAST_EXTRACT_DATE')
And the variable LAST_EXTRACT_DATE is picking date on which 1st source has executed.
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