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:

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

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