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

Issues using the YTD values in BIP report

in Payroll and Global Payroll Interface (GPI) 2 comments

Summary:

I am trying to create a custom BIP report which can pull data similar to that of the seeded extract 'Payroll Statutory Deduction Register'. I also need to pull the YTD values and to get the YTD values in this BIP report I am using the package 'table(pay_balance_view_pkg.get_balance_dimensions(pbt.balance_type_id, pra.payroll_rel_action_id,null,null))'. Using this package I am getting performance issues, the query will throw a timeout error.

Can someone please suggest/help me fix the performance issue?

Content (please ensure you mask any confidential information):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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