R12: CE: General Ledger Reconciliation Report Performance Issues (Doc ID 2155908.1)

Last updated on AUGUST 11, 2023

Applies to:

Goal

The General Ledger Reconciliation Report is having Performance Issues. 
The request runs about 7 hours and completes with the following error.

ERROR

Enter Password:
ORA-01555: snapshot too old: rollback segment number 23 with name "_SYSSMU23_328445721$" too small
==> /*----
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: snapshot too old: rollback segment number 23 with name "_SYSSMU23_328445721$" too small
 
 Any known performance issues with the report ?
 

Solution

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