OBIA 11g Number Of Absence Employees Are Not Matching With EBS Data
(Doc ID 2060692.1)
Last updated on DECEMBER 21, 2020
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
In BI, some employees who are absent for particular period in EBS are not displaying. You notice that the employees ABSENCE_DT is not present.
ABSENCE_DT is populated from W_DAY_D.CALENDAR_DATE and not directly from EBS data.
Take an example of one employee who is absent in the month of May and not displaying in OBIEE. The following condition is failing for that employee for that particular month.
Looking at a Standard OBIEE report in the Absence and accrual Dashboard - Report Name - Absence KPI
(W_DAY_D.CALENDAR_DATE >= WRKFC_FACT.EFFECTIVE_FROM_DT AND W_DAY_D.CALENDAR_DATE < WRKFC_FACT.EFFECTIVE_TO_DT)
1. Full absence periods are not available in absence fact table.
2. All future dated absence (those absence whose start date is greater than the ETL run date) will have absence metrics as 0.
1. Even a single absence date for an absence period should not missed in absence event fact table otherwise it will give wrong results at report level.
2. Metrics for future dated absence should not be zero as future can be tomorrow /next week/next Month.
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