The payroll relationship action ID isn't valid
We are using pay_balance_view_pkg.get_balance_matrix to fetch balance values in a BI Publisher report, however getting " ORA-20001: The payroll relationship action ID isn't valid. Contact your help desk." error. Do you know any diagnostic report to identify employee with invalid payroll relationship action id.
We are using TABLE ( pay_balance_view_pkg.get_balance_matrix ( p_balance_group_usage_id => ( SELECT bal_grp_usage_id
WHERE base_group_usage_name = 'XX Net Exception Ded')
,p_payroll_rel_action_id => PPRA.PAYROLL_REL_ACTION_ID))
to fetch balance values in a bi publisher report, however we are getting following error: