My Oracle Support Banner

How To Handle Unbalanced Reconciliced Journal Lines in GL (Doc ID 748959.1)

Last updated on AUGUST 16, 2019

Applies to:

Oracle Financials Common Country - Version 11.5.9 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Information in this document applies to any platform.
FORM:JGZZJERM.FMB - Manual Reconciliation
FORM:GLXJEENT.FMB - Enter Journals/Encumbrances
REPORT:JGZZLERA.RDF - General Ledger Automatic Reconciliation
REPORT:JGZZLERR.RDF - General Ledger Reconciled Transactions Report tmp
ConcurrentProgram:RXJGUTPB - General Ledger Unreconciled Transactions Report
ConcurrentProgram:RXJGRTPB - General Ledger Reconciled Transactions Report

Goal

Unbalanced reconciled journal entries in GL may be caused by several possibilities:
a. Usability - badly use of the product by Users;
b. Old bugs in the system (when Applications are running in old code versions).


Support prepared in this NOTE some scripts to debug, collect and prepare all the information required to fix this situation in a proactive (to prevent future situations) and reactive way, depending of the 'scenario' you are facing - see below.


After you collect all this information you may open a SR with :
- Subject  like:  « Unbalanced Reconciled Lines Exists and need to be fixed»
- Product code = 375
- Component = GLRECON

Solution

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
Goal
Solution
 Scenario 1: The lines are reconciled  and are unbalanced (the total debit is different from total credit) and you know the reconciliation ID of those lines
 Scenario 2: The lines are reconciled and are unbalanced (the total debit is different from total credit) but you don't know the reconciliation ID and the JE HEADER ID  of those lines
 Scenario 3: The lines are reconciled and are unbalanced (the total debit is different from total credit) but you only know  the JE HEADER ID of those lines
 Scenario 4:  When attempting to change in an unreconciled line the 'reconciliation reference' field information without having to 'mark' that line with another (to balance and to turn reconciliation possible) system does not allows: 
  APP-JG-68011: You cannot save your work unless the balance is zero and the debit and credit totals are not zero. How to change the 'reconciliation reference' field in an unreconciled line ?
References

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