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.

Data Pipeline in Oracle EPM Account Reconciliation

Comments

Oracle EPM Account Reconciliation

Creating your first data Pipeline in Oracle EPM Account Reconciliation

More from this blog

Latest Oracle EPM REST APIs: Part 1 Dimension Details

Oracle SQL Developer Extension for VS Code

Visualize Oracle EPM Data in Python Jupyter Notebook

Oracle EPM October 2025 Updates

Create Reconciliations in Oracle Account Reconciliation using Data Pipeline

Pipeline jobs in Oracle Account Reconciliation

Invoking the Pipeline

What’s Next

Command Palette

Comments

Oracle EPM Account Reconciliation

Creating your first data Pipeline in Oracle EPM Account Reconciliation

More from this blog

Pipeline jobs in Oracle Account Reconciliation

Invoking the Pipeline

What’s Next