My Oracle Support Banner

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

Last updated on FEBRUARY 08, 2021

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


***Checked for relevance on 05-FEB-2019***


***Checked for relevance on 01-FEB-2021***


Symptoms

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.

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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