My Oracle Support Banner

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.

Symptoms

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.

Cause

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
Symptoms
Cause
Solution


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