EGL: Interunit/Intraunit Processor Performance Issue At IU_PROCESSOR.U300 When Processing Journal Entries
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.
Application Release 9.1
Bundles # 9
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.
Not able to carry day to day operations effectively
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms