My Oracle Support Banner

Fusion Global HR: Exatracts Are Failing With Error ORA-01555: Snapshot Too Old: Rollback Segment Number (Doc ID 2500085.1)

Last updated on JANUARY 27, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, Global Human Resources

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

ERROR
-----------------------
An application error occurred. An assertion failure was detected at location PayrollAction.setStatus:1.
Name HR_6881_HRPROC_ORA_ERR
Token1 SystemExtract.PreProcess
Token2 ORA-01555: snapshot too old: rollback segment number 188 with name "_SYSSMU188_1288901325$" too small
ORA-06512: at "FUSION.PAY_REPORT_PROCESS", line 1554
ORA-06512: at line 1


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run an extract
2. Check extract logs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run an extract

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
Cause
Solution
References


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