OBIA 11g Adding “Absence Type” As Column Other Columns Empty (Doc ID 1918835.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

When adding “Absence Type” as prompted in “Absence and Accrual” reports  the following columns are null:-


Expression 'Employee Headcount:[DAggr(Fact - HR - Workforce - Balance Information.Employee Headcount by [ Dim - Absence Type / Reason.Absence Type] )]' is converted to NULL because
[nQSError: 14020] None of the fact tables are compatible with the query request Employee Headcount:[DAggr(Fact - HR - Workforce - Balance Information.Employee Headcount by [ Dim - Absence Type / Reason.Absence Type] )

Without a specific Absence Type selected all columns filled correctly OOTB report Absence and Accrual is working fine.

Created report Absence Type and Employee Headcount, Employee Absence Days, Average Absence Days per Employee
-> Absence type column filled , but others are empty.
There is not an OOTB report including these columns but when you create new report and include those columns Average Absence Days per Employee and Employee Headcount are empty

Reproduced using the following steps:

1. Employee Headcount
2. Employee Absence Days
3. Average Absence Days per Employee
all 3 columns filled

when you add Absence Type -> Employee Headcount and Average Absence Days per Employee empty

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