EGL91: Performance Issue In Online Journal Edit GL_JEDIT_0 During Truncate of TAO Tables (Doc ID 2014801.1)

Last updated on JULY 11, 2016

Applies to:

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

***Checked for relevance on 11-JUL-2016***


Symptoms

FMS Financials 9.1 Bundle #24
Tools patch level 8.52.04
Oracle 11.2.0.4
DB Platform Linux x86-64
DB Platform Version Red Hat Enterprise 6

ISSUE  
---------------
GL_JEDIT_0 Temp table initialising taking too long  

In the online journal edit GL_JEDIT_0 process when the temp tables are being dedicated for GL_JEDIT_0 and for GL_JPROC out of 14 mins taken for editing of Journal, 12 minutes are utilised doing truncate of TAO tables and initialising the instances.  Customer's TRC and AET for online Journal Edit shows the timings for instance dedication and truncates.

NOTE: The same issue with truncate of temp tables occurring in PC_PRICING process as well.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the online journal edit process

BUSINESS IMPACT
-----------------------
Due to this issue, Close processes are being delayed because of the longer run of online GL edits.

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