My Oracle Support Banner

Pre-Payments Concurrent Job Fails With ORA-01555 Rollback Too Old (Doc ID 339333.1)

Last updated on OCTOBER 03, 2023

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

PRE-PAYMENTS CONCURRENT JOB FAILS WITH HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Dynamic SQL for DB item failed : ORA-01555: snapshot too old: rollback segment
number 3 with name "XXXXX" too small
ORA-06512: at "APPS.HR_UTILITY", line 934
ORA-06512: at "APPS.PAY_BALANCE_PKG", line 1563
ORA-06512: at "APPS.PAY_BALANCE_PKG", line 2671
ORA-06512: at "APPS.PAY_BALANCE_PKG", line 2844
ORA-06512: at "APPS.PAY_BALANCE_PKG", line 4391
ORA-06512: at "APPS.PAY_BALANCE_PKG", line 5344
ORA-06512: at "APPS.PAY_BALANCE_PKG", line 5206
ORA-06512: at "APPS.PAY_BALANCE_PKG", line 5191
ORA-06

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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