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.
OTBI Reports over Payroll Data
Summary
We experience terrible performance when we run OTBI reports over subject areas such as Payroll Balances Real TimeContent
The OTBI reports tool is struggling to provide data over Subject Areas such as Payroll Balances Real Time. Our users are trying to run summary info for periods that may span a year and are experiencing run times over 10 hours or more.
Note we have 20,000 employees and 52 payrolls a year. With simple math (looks like about 450+ records per employee per week) that puts us at about 450,000,000 records for a year's worth of data.
We find that unacceptable and would like to get some guidance.
Tagged:
2