EGL- Journal Edit Performance Issue On Oracle 10G With Interunit Transactions (Doc ID 658840.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 SP1 to 9 [Release 8.8 to 9]
Information in this document applies to any platform.
8.9

This document was previously published as Customer Connection Solution 201057126


***Checked for relevance on 13-Apr-2010***
***Checked for relevance on 27-Jan-2012***
***Checked for relevance on 06-Nov-2013***


Symptoms

Journal Edit performance issue on Oracle 10G with interunit transactions
Journal Edit process taking Longer time when processing interunit transaction
GL_JEHDR took 198 seconds
EditBal.UpdStat1.S   64
InsBalT.UpdStat.S    127

GL_IUNIT took 48 seconds
JA000.DelLIU.S         12
JA000.UpdStatL.S     12

IU_PROCESSOR took 150 seconds
B003.B003-999.S       49
U100.U100-020.S       25

out of a total of  464

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