My Oracle Support Banner

EGL 9.2: Account Reconciliation Processes Inactive Rules and Create Extra Rows which is Impacting Performance (Doc ID 2558278.1)

Last updated on JULY 06, 2020

Applies to:

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


GL Recon is processing Rules that are set to Inactive and inserts inactive rows with zero amounts.
If running process for many Business Units many unnecessary rows are inserted, even though not contributing to recon processing, since the rows are inserted with zero dollars

Recon should process only active rules

The issue can be reproduced at will with the following steps:
1. Navigate to General Ledger > Perform Reconciliation > Reconciliation Rule and set a Recon Rule to Inactive
2. Add the inactive Rule to a Recon Set (General Ledger > Perform Reconciliation > Reconciliation Set)
3. Run Create Recon process for above Recon Set (General Ledger > Perform Reconciliation > Create Reconciliation)
4. Data Inserted into GLRN_RECON_TBL for all BU from Recon Rule with 0.00 for all amounts

See replication document attached.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.