Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Issues using the YTD values in BIP report
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):
0