OBIA 11g Incorrect Date in Absence End Date, it Defaults Null End Date To SYSDATE
(Doc ID 2057127.1)
Last updated on JULY 18, 2017
Applies to:Business Intelligence Applications Consumer - Version 22.214.171.124.1 and later
Information in this document applies to any platform.
On : OBIA 126.96.36.199.1 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:
- "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)".
- 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