The payroll relationship action ID isn't valid
Summary:
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.
Content (required):
We are using TABLE ( pay_balance_view_pkg.get_balance_matrix ( p_balance_group_usage_id => ( SELECT bal_grp_usage_id
FROM pay_bal_grp_usages
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:
Tagged:
0