My Oracle Support Banner

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


On : version, Global Payroll

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.

The function to return Assignment Run balance.

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

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


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.