My Oracle Support Banner

R12:PA:EXC: Transaction Exception Details By GL Period has Performance Issues (Doc ID 1362410.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Project Costing - Version 12.1.1 and later
Information in this document applies to any platform.


Request "EXC: Transaction Exception Details by GL Period" running for almost 2 hours and above which usually completes within 15 minutes.

After running for multiple hours it completes in error with the following in the log file:

Error 50103 (C Engine): ERR ORA-01555: snapshot too old: rollback segment
  number 877 with name "_SYSSMU877_3791429476$" too small
   ==> SELECT
  Error 50103 (rwfdt:rwfdtprint): ERR Error occurred sending Job output to
  Error 50103 (C Engine): ERR REP-0069: Internal error
  REP-57054: In-process job terminated:Terminated with error:
  REP-300: snapshot too old: rollback segment number 877 with name
  "_SYSSMU877_3791429476$" too small
   ==> SELECT 


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

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