Data Pipeline in Oracle EPM Account Reconciliation

Hey everyone. Today I wanted to cover a topic that is dear and near to me — Data Pipeline in Oracle EPM.

While Pipeline was introduced way back (its been that looong that I dont event remeber when), it was never available in Account Reconciliation. It was a long wait. However, as part of the August 2025 updates, Pipeline was introduced in Account Reconciliation.

In the next few articles, I will cover data pipeline specifically for Oracle EPM Account Reconciliation. In the first article, we will look at what job types are available as of September 2025. Without any further delay, let’s look into what is available for Account Reconciliation.

Pipeline jobs in Oracle Account Reconciliation

Here is a quick look at what job types are available as of September 2025. Some jobs are specific to either the Reconciliation Compliance module or the Transaction Matching module.

Press enter or click to view image in full size

You can read more about these jobs here.

Invoking the Pipeline

You have a few different ways to invoke a data pipeline.

• Manually exeucting the pipeline

• Scheduling the pipeline using the Job Scheduler

• Using EPM Automate

• Using REST API

Use the runPipeline command to execute or invoke the Data Pipeline using EPM Atuomate. You can read more about it here.

If you want to use REST API, use the Data Integration REST API to invoke the pipeline. Here is a sample code snippet.

{
    "jobName": "DAILYLOAD",
    "jobType": "pipeline",
    "variables": {
                    "STARTPERIOD": "Jan-23",
                    "ENDPERIOD": "Jan-23",
                    "IMPORTMODE": "Replace",
                    "EXPORTMODE": "Merge",
                    "ATTACH_LOGS": "N",
                    "SEND_MAIL": "ALWAYS",
                    "SEND_TO": "user@company.com"
                }
}

• jobName is Short name of the Pipeline

• jobType should be pipeline

You can read more about the REST API usage here.

What’s Next

In the next few articles, I will dive deeper into individual job types and how you can configure them. I will also be making accompanying videos so can follow along.