Error ORA-01555 The Concurrent Request 'Payroll Reconciliation (New Zealand) (XML)' Is Ending In Error
Last updated on MARCH 08, 2017
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms