Need help in integrating EBS system AP and AR with ARCS

Summary:

We're currently working on integrating ARCS with the EBS subledger, focusing on developing the Account Payable and Account Receivable subledger modules, which also involve aging analysis. Following discussions with the EBS team, it's been noted that constructing a report for integration using SQL queries is proving to be complex. Presently, reports from AR and AP subledgers are being extracted at a single Ledger level, but we aim to consolidate all ledger data into a single file or single integration. Are there alternative methods for direct integration between ARCS and EBS subledger for AP and AR, or could you provide guidance