We're running Oracle HRMS 12.1.3 and have 2 problems with the Payroll Register:
When Threads = 1, table PAY_US_RPT_TOTALS ends up filling up and they have to run repeatedly in order to get the Totals to be produced. (Also, Threads = 1 is not a viable long-term solution as we'll be adding an additional 13 Payrolls as of year end.
When Threads = 8, one of the worker/slave processes errors and those employees are excluded from the Payroll Register Details report. The table PAY_US_RPT_TOTALS is still populated and needs to be cleared periodically. The Totals seem to be okay.
The worker/slave process errors with:
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
REP-54002: file : Cache item is no longer valid
The only unusual thing about the way we run the Payroll Register is that multiple payroll runs for the same Payroll are run for the same pay period and check date, but with different Assignment Sets. These payrolls are run from BEE to Payroll to Prepayments and the Payroll Register as a single Assignment Set.
Thank you for any help you can give with this.