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 MAY 03, 2017

Applies to:

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

Symptoms

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.

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