Fusion Application - Global Payroll - HCM Extract - A system error ORA-01555: snapshot too old: rollback segment number .. with name "..........." too small (Doc ID 2297662.1)

Last updated on AUGUST 16, 2017

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Global Payroll

When attempting to run an HCM Extract ,the following error occurs.

ERROR
-----------------------
HCM extract failing with ORA-01555: snapshot too old: rollback segment number 19 with name "_SYSSMU19_1510942260$

ORA_PAY_BL_ENCRYPTION_TYPE = PGPSIGNED
THREADS = 8
-----------------------------------------------------------------------------
PLSQL Log Messages
End PLSQL Log Messages
111
Name PAY_PAYPROC_UNKNOWN_ERR
Token1 null
Token2 null
Token3 null
A system error occurred during processing. Your help desk was notified.
Name HR_6881_HRPROC_ORA_ERR
Token1 ReportUtil.CallReportProc
Token2 ORA-01555: snapshot too old: rollback segment number 19 with name "_SYSSMU19_1510942260$" too small
ORA-06512: at "SYS.DBMS_SQL", line 1712
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 706
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 1718
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1932
ORA-06512: at line 1

Token3 20
A system error ORA-01555: snapshot too old: rollback segment number 19 with name "_SYSSMU19_1510942260$" too small
ORA-06512: at "SYS.DBMS_SQL", line 1712
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 706
ORA-06512: at "FUSION.PAY_REPORT_
Name null
Token1 null
Token2 null
Token3 null
ORA-01555: snapshot too old: rollback segment number 19 with name "_SYSSMU19_1510942260$" too small
ORA-06512: at "SYS.DBMS_SQL", line 1712
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 706
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 1718
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1932
ORA-06512: at line 1

PLSQL Log Messages
End PLSQL Log Messages
PLSQL Log Messages
End PLSQL Log Messages

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run HCM Extract
2. Error is returned



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