OBIA 11g Number Of Absence Employees Are Not Matching With EBS Data (Doc ID 2060692.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

OBIA 11.1.1.7.1

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.


If you take an example of one employee who is absent in the month of May is 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
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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms