My Oracle Support Banner

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 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


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.
Expected Behavior:
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

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