EGL9.1: GL_JEDIT Journal Edit Step GL_JIUNIT.EA000.Step09 Performing Slowly For Large InterUnit Journals. (Doc ID 1346544.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, the large journal (with 209K lines) created from allocation took 8.5 hours to complete journal edit.

From AE trace file provided, the majority time is spent on step  GL_JIUNIT.EA000.Step09.

ENVIRONMENT
----------------------
- 9.1 MP5 with Bundle FCM  9.1 Bundle #10 applied. 
- PeopleTools 8.51.09.
- Oracle database 11g

ACTUAL BEHAVIOR  
---------------
- the same slow performance is observed when the journal edit is requested by allocation step or when it is requested in a separate journal edit batch process.
- most time is spent on step  GL_JIUNIT.EA000.Step09 ( 8452.4 out of 9346.7 seconds) as shown in AE trace.
- the process, which generated the above AE trace, was eventually killed.
- by comparison, journal with 32K lines takes 11 min to complete journal edit.

EXPECTED BEHAVIOR
-----------------------
- The site had journal edit on similar sized journal completed in 1.5 hours on 8.8 hence they expect the same performance on 9.1.


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 8 hours to complete the journal edit.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the journal edit process cannot be completed in the expected timeframe. 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