Error ORA-01555 The Concurrent Request 'Payroll Reconciliation (New Zealand) (XML)' Is Ending In Error
(Doc ID 2242003.1)
Last updated on FEBRUARY 25, 2019
Applies to:Oracle HRMS (New Zealand) - Version 12.2.3 and later
Information in this document applies to any platform.
On : 12.2.3 version, New Zealand Payroll
The Concurrent request 'Payroll Reconciliation (New Zealand) (XML)' is taking days to run and is ending with an error status.
Note that this request will run and complete for a payroll run with 80employees, however when we run it for a payroll with 5000 employees it takes almost 3 days to run and completes with an error status.
ORA-01555: snapshot too old: rollback segment number 21 with name "_SYSSMU21_1227766224$" too small
The issue can be reproduced at will with the following steps:
1. Login to HRMS Manager
2. Navigate to View > Submit Request
3. 'Payroll Reconciliation (New Zealand) (XML)
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document