My Oracle Support Banner

Fusion Core HR : Transaction Console Error : ORA-01555: Too Old Snapshot: Rollback Segment (Doc ID 2639514.1)

Last updated on AUGUST 29, 2020

Applies to:

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

Goal

On : 11.13.19.10.0 version, Global Human Resources


I clicked the "Refresh icon" to refresh the transaction data on Transaction Console screen, and "In Progress" status lasted almost all day. In the end, I got a refreshed failed error today morning.

For your information, I need to identify which transaction is failed.
That's because I have to take an action like recover action for the failed transaction which is caused by a server health problem.
However, I am not sure if the failed transaction has occurred since Dec. 2nd, 2019 which the last refresh was carried out.

Please find out why this error occurred and let me know how to find out which transaction is failed after Dec. 2nd, 2019.
You can also refer to the attachment.

"Executing TAC ESS Job
Some error happened while commiting the data: ORA-01555: Too Old Snapshot: Rollback Segment 169 is too small with name "_SYSSMU169_409784768 $""

 

Solution

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
Goal
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.