SQL query for AR-GL reconciliation opening balances

As part of the month-end and period-close reconciliation process, our Finance team performs validation between Oracle Fusion Receivables and General Ledger (GL) using the Receivables to General Ledger Reconciliation Report.

Currently, we are required to validate and analyze the opening balances that are carried forward from the prior period to the current one to ensure accuracy and completeness of accounting data across subledgers and GL. However, the standard report output does not provide direct visibility into the detailed opening balance derivation.

To support audit and compliance requirements, and to facilitate data validation and troubleshooting during reconciliation, we request Oracle’s assistance in providing the