R12: CE: General Ledger Reconciliation Report Performance Issues

(Doc ID 2155908.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Cash Management - Version 12.1.3 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms