My Oracle Support Banner

OBIA 11g Incorrect Date in Absence End Date, it Defaults Null End Date To SYSDATE (Doc ID 2057127.1)

Last updated on JUNE 26, 2019

Applies to:

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


On : OBIA DataWarehouse,SDE_ORA_AbsenceEventDimension the default null end dates are changed to sysdate.

You have noticed a that a number of absences with end-dates equal to the ETL run date are inconsistent with the source system where they were NULL.

Further investigation has shown that the issue appears to be in the interface as follows:

  1. "SDE_ORA_AbsenceEventDimension.W_ABSENCE_EVENT_DS_SQ_PER_ABSENCE_ATTENDANCES.TAB" of the "SDE_ORA_AbsenceEventDimension" mapping, where the date_end column is derived by the expression "NVL(PAA.DATE_END,SYSDATE)".
  2. This gives a completely wrong view of the data because it looks like absences that are still open have ended on the date that the ETL has run.


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

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