My Oracle Support Banner

AR To GL Reconciliation Report shows Out of balance Entries and Differences After Upgrade to Release 12.2.10 (Doc ID 2968814.1)

Last updated on AUGUST 18, 2023

Applies to:

Oracle Receivables - Version 12.2 and later
Information in this document applies to any platform.


AR to GL Reconciliation Report is showing out of balance data, even for closed months
When running the AR to GL Reconciliation Report, with the parameter Out of balance only='Y' and for a specific period,
the output shows many lines (account entries) with out of balance.
This eve happens for old closed months that were reconciled without any difference.
The report shows that columns under "Receivables Posted" Debit and Credit amounts are changed in the latest version and same is appearing as Difference in the last column.

There should not be any difference in AR to GL Reconciliation Report

The issue can be reproduced at will with the following steps:
Responsibility: Receivables Manager Responsibility 
View --> Requests
Submit a New Request
Run AR to GL Reconciliation Report
Out of balance only='Y' 
Other parameters like Ledger and Period Name can be selected as per business need.

The Report shows lot of entries in the output with lot of Differences in the Last section.
The same report does not return any output when run in Release 12.1.3 and also difference was zero.

Please review sample output


NOTE: In the images above and/or the attached document, amounts/ user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


 Customer has upgraded from EBS Release 12.1.3 to Release 12.2.10


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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