OAS 2025 (EBS 12.2.12): Anyone has built "Project to GL Cost Reconciliation" Report

Analytics_User

We use OAS 2025, EBS 12.2.12, OBIA 7.9.6.4, Oracle 19c db on Linux. We are trying to build Project to GL Cost reconciliation report that runs for a period, currently it is done manually, by running three analytics reports (one on Project - Cost subject area to get total cost for Contract and Resources, another report on 'Financials - GL Detail Transactions' subject area to get total GL Resource Transfer and one on 'Financials- GL Balance Sheet' subject area to get the beginning and ending balance for the period). With these three reports we calculate total GL cost transfer minus Project contract cost (contract variance, similarly resource variance) and then compare it with difference of beginning, ending balance amount. If there is a variance then we tried to explain that by running bunch of SQL queries in EBS tables for finding amounts for reasons (like "PA to GL in Period, AP to PA in Later Period", "AP to GL in Period, Not Yet in PA", "AP Coded Direct with No Project", "AP Cost Missing in PA", "AP Discount on Tax Not Sent to PA", "Manual J/E's Coded Direct", "AP Not Sent to PA, Cancel in Current GL" etc. etc. till we explain the entire variance amount). All this goes in a column for a company (for the period, the GL account is same for all) of the final pivot report (similarly second column for another company and so on). Any one who has done such report, could please advise how you built this report (issue faced/resolutions), what approach based on the experience, works best? like creating a recon subject area and then building the report based on it OR using DV (creating multiple datasets, data blending, dataflow then some kind of summary table), any tips is highly appreciated.