Fusion Global HR - HCM Extract Fails With "ORA-01555: Snapshot Too Old: Rollback Segment Number" Error When Submitted (Doc ID 1988987.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Oracle Fusion Global Human Resources - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms


When attempting to run the HCM extract ,the following error occurs.

ERROR
-----------------------
Name PAY_PAYPROC_UNKNOWN_ERR
Token1 null
Token2 null
Token3 null
PAY_PAYPROC_UNKNOWN_ERR
Name HR_6881_HRPROC_ORA_ERR
Token1 ReportUtil.CallReportProc
Token2 ORA-01555: snapshot too old: rollback segment number 37 with name "_SYSSMU37_993278623$" too small
ORA-06512: at "SYS.DBMS_SQL", line 1830
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 709
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 1820
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1426
ORA-06512: at line 1

Token3 20
HR_6881_HRPROC_ORA_ERR
Name null
Token1 null
Token2 null
Token3 null
ORA-01555: snapshot too old: rollback segment number 37 with name "_SYSSMU37_993278623$" too small
ORA-06512: at "SYS.DBMS_SQL", line 1830
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 709
ORA-06512: at "FUSION.PAY_REPORT_GENERIC", line 1820
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1426
ORA-06512: at line 1




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