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
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.
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.
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!