OBIA 11g - HR Analytics – Wrong Accrual for Bi-Weekly payments
Last updated on JULY 17, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.2 and later
Information in this document applies to any platform.
OBIEE: 188.8.131.52.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.
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