My Oracle Support Banner

OBIA HR The Half day (0.5) of Absence in PS is Counted as 1 day in BI fact table W_ABSENCE_EVENT_F (Doc ID 1957676.1)

Last updated on JANUARY 13, 2020

Applies to:

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


OBIA /OBIEE configuration.  
HCM Source system: PeopleSoft HCM 9.1.

The half day (0.5) of absence in PS is counted as 1 day in BI fact table w_absence_event_f.
For Absence (Days) you found the divergence between PS and BI: Half day (0.5) of absence in PS are counted as a different result in BI:

1.    In BI dimension table w_absence_event_d, it is counted as 0.5 for the table column DAYS_DURATION. This is correct and it matches to the source.
2.    In BI fact table w_absence_event_f, it is counted as 1 for the table column DAYS_DURATION. This is wrong, and it should be counted as 0.5 day to match to the  source.

Note:Absence (Days) is mapped to the column W_ABSENCE_EVENT_F.DAYS_DURATION

How can you see 0.5 for Absence (Days) instead of 1.0 when the Absence (Hours) is 4 (use case when the absence hours is less than the actual work hours in a day)?


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.