EGL: Interunit/Intraunit Processor Performance Issue At IU_PROCESSOR.U300 When Processing Journal Entries

(Doc ID 1961048.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

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

Symptoms

CUSTOMER ENVIRONMENT
=======================
Application Release 9.1
Bundles # 9
Tools 8.51

Environment Production

ISSUE/ERROR
============
Performance issue: Initial feedback indicates that when running large interunit journals through edit, when the IU_PROCESSOR is called from GL Journal Edit Program the steps IU_PROCESSOR.U300seq.rowproc and IU_PROCESSOR.U300upd.saveprev are taking time to process due to which the program take more time to execute. Usually 90% of execution time taken in the steps mentioned above.

The Main Source of this Performance Issue is Looping at the following Step/ Action in the Application Engine. (IU_PROCESSOR.U300Seq.RowProc) (Do Select)

 There are some journals where-in there are about 400,000 Intra-Unit lines and this particular Loop Takes days to complete.


Business impact
===================
Not able to carry day to day operations effectively

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