Problem In Fetching Balances From Balance Group Usages Using Pay_balance_view_pkg.get_balance_matrix (Doc ID 2192354.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Global Payroll

ACTUAL BEHAVIOR
---------------
Have a requirement to build a report where we are fetching lot of balances so for that we have configured Balance Group and Balance Group Usage and in the query calling function pay_balance_view_pkg.get_balance_matrix to retrieve it.
Have some of the balances with two dimensions added in the balance group.
For example balance group contains Pay Report Monthly Provision Balance with two dimensions ‘Relationship Inception to Date’ and ‘Assignment Run’ but when we use above function to retrieve these two balances only one balance with dimension ‘_REL_ITD ’ comes up. This function is not returning Assignment Run balance.
Have also tried creating a balance group that has only one balance with Assignment Run and tried to fetch the same but even it does not retrieve any balance.

EXPECTED BEHAVIOR
-----------------------
The function to return Assignment Run balance.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a query to call function pay_balance_view_pkg.get_balance_matrix
 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use a seeded function.

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