My Oracle Support Banner

EGL9.2: Need A Way to Change Status of a GL Account Reconciliation if Approved and Account Balance Changes (Doc ID 2256903.1)

Last updated on FEBRUARY 04, 2019

Applies to:

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


Need a way to change status of a GL account reconciliation if approved and account balance changes.
Need to identify reconciliations that have been approved, and subsequent to that approval, had a change
in the account balance due to additional journal postings.  Last minute postings during close can cause this to happen.

Testing shows that General Ledger > Perform Reconciliations > Create Reconciliations can be used to update the balance
and set the status to one selected in the run control parameters.

However, if user allow it to recreate existing reconciliations that have status "Approved", it updates the status on all reconciliations, whether the balance changed or not.

The other process which calculates reconciliation balances (General Ledger > Perform Reconciliations > Calculate Balances),
always updates the balances, but doesn't appear to provide a way to change the reconciliation status if the balance has changed.

Steps to replicate:

1. Reconciliation has been approved, as shown in Reconciliation Workbench:
  Navigation: General Ledger > Perform Reconciliation > Workbench

2. Additional journal entry is posted:
  Navigation: General Ledger > Journals > Journal Entry > Create/Update Journal Entries

3. Run the Calculate Balance Process:
  Navigation: General Ledger > Perform Reconciliation > Calculate Balances

Reconciliation balance has been updated, but the status remains as Approved.


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.