FAW: HCM Absence Analysis - Sick Leave DW_ABS_DAILY_DETAIL_EF only Contains Annual Data
(Doc ID 2950820.1)
Last updated on JUNE 07, 2023
Applies to:Fusion Analytics Warehouse - Version 22.R1.x and later
Information in this document applies to any platform.
Absence Analysis - Sick Leave
The Fusion Analytic Warehouse (FAW) workbook does not show daily. The same data can be displayed in the source Fusion Application HCM.
When checking the FAW OAX schema ..it's noticed that DW_ABS_DAILY_DETAIL_EF has only annual data.
This table has no records other than for Annual Leave days.
On the other hand the DW_ABS_ENTRY_EVENT_EF table does contain the correct records. But that is not the table referenced in the workbook.
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