Increase ADFI Spreadsheet Line Limit for Clearing Account Reconciliation / API Alternative

Summary:

ADFI Spreadsheet Line Limit for Clearing Account Reconciliation (High Volume Scenario)

Content (please ensure you mask any confidential information):

We are currently using the Clearing Account Reconciliation process via ADFI spreadsheet as described in the Oracle blog below:
https://blogs.oracle.com/erp-ace/use-clearing-accounts-reconciliation-to-manage-critical-business-processes

However, we are facing a scalability limitation, the ADFI spreadsheet currently supports a maximum of 20,000 lines per upload. In our case, we have clearing accounts with more than 300,000 journal lines that need to be reconciled.

Due to this limitation, we are required to split the data into multiple files and perform the reconciliation manually in batches, which is highly time-consuming and operationally inefficient.