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.

Symptoms

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.


ERROR
-----------------------
ORA-01555: snapshot too old: rollback segment number 21 with name "_SYSSMU21_1227766224$" too small

STEPS
-----------------------
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)

Cause

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