OBIA 11g - HR Analytics – Wrong Accrual for Bi-Weekly payments

(Doc ID 2184965.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


Environment Details:

OBIEE: (Build 150111.1659 64-bit)
WLS: 10.3.6
OS: Linux 64 bit
Source: EBS 12.1.3
Database: 12.0.2
Modules: Human Resources Analytics

Issue Details:
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