Customising the EBS GL Balances to EPM Cloud Connection

In my first blog on the EPM Integration Agent, I covered pulling EBS GL Balances from on-premises Oracle EBS to EPM Planning, using the out-of-the-box Oracle connector in data management. However, as described, there are a few shortcomings with the connector which make it more desirable to use a custom SQL query to pull EBS GL balances into EPM. The main issue being that the Oracle data load rules can only be run for a single Ledger and Period each time, making it difficult to update multiple historic periods at once and inefficient if there are multiple Ledgers in Oracle. Fortunately, it is possible to retrieve the full ‘EBS GL Balance’ SQL query and tweak it, rather than having to start from scratch (thanks Oracle!) This blog will cover the below points, detailing a few simple ways that the SQL can be adapted to improve usability: Retrieving the original EBS GL SQL query Updating SQL WHERE Criteria to: Remove the Ledger filter, allowing import of all Ledgers at once Use a L