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 11.1.1.9.2 and later
Information in this document applies to any platform.

Symptoms

Environment Details:

OBIA: 11.1.1.9.2
OBIEE: 11.1.1.7.150120 (Build 150111.1659 64-bit)
WLS: 10.3.6
ODI: 11.1.1.7.0
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.

Cause

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