Process Initialize And Load Collections Metrics Ends -In Error Ora-01555- snapshot too old- Roll back segment - too small
(Doc ID 2518652.1)
Last updated on AUGUST 24, 2020
Applies to:
Oracle Fusion Advanced Collections Cloud Service - Version 11.13.19.01.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.19.01.0 version, Manage Collections-Manage Collections Work
Process Initialize and Load Collections Metrics Ends in Error Status - Rollback Segment Too Small
In Advanced Collections execution of the p Initialize and Load Collections Metrics process resulted in the following error message:
oracle.apps.financials.collections.metrics.ess.program.InitialLoadDashboardMetrics: InitialLoadDashboardMetrics():: SQL Exception error out:ORA-01555: snapshot too old: rollback segment number 204 with name "_SYSSMUXXX_1049258525$" too small
ERROR
-----------------------
ORA-01555 snapshot too old: rollback segment number 204
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run scheduled Process: Initialize and Load Collections Metrics
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 |