OBIA 11g - HR Analytics – Wrong Accrual for Bi-Weekly payments
(Doc ID 2184965.1)
Last updated on OCTOBER 04, 2019
Applies to:Business Intelligence Applications Consumer - Version 220.127.116.11.2 and later
Information in this document applies to any platform.
OBIEE: 18.104.22.168.150120 (Build 150111.1659 64-bit)
OS: Linux 64 bit
Source: EBS 12.1.3
Modules: Human Resources Analytics
When the customer runs the Absence and Accrual KPI Dashboard, he observes that all the values for Accrual are populated as 0. Following is the screenshot of the Dashboard:
It was observed that the issue is with the Accrual Balance Duration being captured for the PERIOD_END_DT which has data as 0 for the Last Day of Month.
The OOTB Dashboard physical query which runs is -
This query returns the result for last month as -
Since Customer is having BI-Weekly Payments there is no Accrual or Payment on Last Day of the Month.
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