You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

The payroll relationship action ID isn't valid

Received Response
61
Views
5
Comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!