My Oracle Support Banner

Fusion Global HR: Extracts Are Failing With Errors and Affect Payroll Downstream Data - An Application Error Occurred. An Assertion Failure Was Detected at Location PayrollAction.setStatus:1. and ORA-01555: Snapshot Too Old: Rollback Segment Number (Doc ID 2500085.1)

Last updated on OCTOBER 02, 2023

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.04.0 and later
Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.13.18.10.0. The note has been reviewed and is current for release 11.13.20.04.0.

Symptoms

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.

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
References


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