My Oracle Support Banner

EGL9.2:Open Item Reconciliation (GL_OI_RECON) Performance. (Doc ID 2708180.1)

Last updated on AUGUST 11, 2021

Applies to:

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

Symptoms

Whether Open Item Reconciliation is run via Post Journal Request, or directly via Open Items Reconciliation Request page, the process takes time to complete.

Example:

A.  For a 1,000 line journal that has been edited and marked to Post, when posted via Post Journal Request run control with 'Skip Open Item Reconciliation' option not selected
    (meaning it will include to run the Open Item Recon), the process took about 7.5 minutes.  

B.  For the same 1,000 line journal, after running Post Journal with 'Skip Open Iten Reconciliation' option selected (and run the Open Item Recon separately later), this took 30 seconds. 
     Running Open Items Reconciliation Request (GL_OI_RECON) process, thereafter, took 17 minutes.

     Note that the standalone GL_OI_RECON process will run longer than the posting process because it has to check all data to see if an update to an open item is required,
     whereas the posting process only needs to check the data specific to the journal being posted.  However, even with the consideration that the GL_OI_RECON process is 'checking all data',
     and its processing time is still considered slow for the amount of data.

Steps to replicate:

A.  In Post Journal Request page, uncheck 'Skip Open Iten Reconciliation' option.
B.  Run Post Journal Request with 'Skip Open Iten Reconciliation' option selected.
     Then, run Open Items Reconciliation Request (GL_OI_RECON) 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.