My Oracle Support Banner

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 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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.