Oracle Fusion Payroll Balance Query
Summary:Performance Issue with my BI Publisher report Payroll Balance Query
Content (required): My current payroll balance query is using pay_balance_view_pkg.get_balance_dimensions function to get the balance values. But query is running for ever when I run it for multiple departments (more employees).
Looking for the alternates to fetch balance values without using pay_balance_view_pkg.get_balance_dimensions function. Please advice.
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):