EGL9.1: GL_JEDIT Journal Edit AE Step GL_JIUNIT.EA000.Step09 Performing Slowly (Doc ID 1417164.1)

Last updated on SEPTEMBER 14, 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 Currency on August-19-2013****
****Checked for Currency on January-21-2015****

Symptoms

On :  9.1 version, Journal Edit runs slow.

ENVIRONMENT
----------------------
- Fix by <bug 12685513> (Update 855549, 9.1 bundle#14) has been applied (<Document 1346544.1> )
- PeopleTools 8.51.09.
- Oracle database 11g

ACTUAL BEHAVIOR  
---------------
- Slow running at step GL_JIUNIT.EA000.Step09

EXPECTED BEHAVIOR
-----------------------
- Process is completed at accepted time frame.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Allocation with one step only to create a journal with large volume of lines (209K)
2. Journal edit is either invoked by allocation process or in a separate batch.
3. It takes long time to complete the process.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the journal edit process cannot be completed in the expected time frame. This has major impact on month end closing.

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