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.

Symptoms

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.

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

STEPS
-----------------------
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
Parameter
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.