OBIA 11g Adding “Absence Type” As Column Other Columns Empty
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
When adding “Absence Type” as prompted in “Absence and Accrual” reports the following columns are null:-
- Employee Headcount
- Average Absence Days per Employee
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
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