My Oracle Support Banner

Error ORA-01555 The Concurrent Request 'Payroll Reconciliation (New Zealand) (XML)' Is Ending In Error (Doc ID 2242003.1)

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)


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.