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

Last updated on JUNE 14, 2017

Applies to:

Oracle Project Costing - Version 12.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 31-OCT-2013***

PAXEXCPD
PAXEXCPS


Symptoms


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
  cache
  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 

Cause

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