EGL91: Performance Issue In Online Journal Edit GL_JEDIT_0 During Truncate of TAO Tables

(Doc ID 2014801.1)

Last updated on DECEMBER 28, 2017

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

***Checked for relevance on 28-DEC-2017***


Online journal edit GL_JEDIT_0 process 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 files 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.

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

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


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