# Creating your first data Pipeline in Oracle EPM Account Reconciliation

In this article, we will learn how to create a Data Pipeline in Account Reconciliation to set the period status. We will be using the “S**et Period Status**” job type.

### **Creating your Pipeline**

Navigate to ***Application > Data Exchange***

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*SRMaJZH2k4sZSnvbBSi-tg.png align="left")

Once you are in the Data Exchange page, click on ***Create New > Pipeline***

![](https://miro.medium.com/v2/resize:fit:462/1*IaeiwK2KN8Ax7KvON5xciQ.png align="left")

Give the Pipeline Name and Pipeline Code

* Pipeline Name : Set Period Status
    
* Pipeline Code : SETPERIOD
    

Click on ***Save and Continue***

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*IbATM3g438WmEK6v59Suzg.png align="left")

Let’s go ahead and define a variabe to provide the Period Name as a dynamic value.

* **Variable Name**: periodName
    
* **Display Name**: Period Name
    
* **Display Sequence**: 1
    
* **Required**: Yes
    
* **Validation Type**: Text
    

> *Make sure to delete any default variables that you are not planning to use.*

![](https://miro.medium.com/v2/resize:fit:690/1*oJJiRIFSffXAcKdiarzfyQ.png align="left")

Let’s create a new stage. Provide the Stage Name and State Title as shown in the screenshot.

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*RF24eBmqVeVWPKVlAWp7cA.png align="left")

Once you create the stage, go ahead and create a new job in the Stage. Provide the following information.

* Type: Set Preiod Status
    
* Tile: Open Period
    
* Period: $periodName (this is the ariable defined earlier)
    
* Status: Open
    

> *We can also create another variable to provide the status dynamically. I will show that in the YouTube Video.*

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*POSYGk2rMRfrGc73Y9DveA.png align="left")

Click on the Save button to save the Pipeline definition.

Before executing the pipeline, lets review the status of the periods. As you can see “Jan 2025” is in Pending Status.

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*krphd2i82KYafSCogm43Zg.png align="left")

Navigate to Data Exchange and Click on the “Play / Run” icon to execute the Pipeline

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*wqg6wl20eDZaR5dZtZq3lw.png align="left")

In the next screen, provide values to parameters. We will be setting the status of “Jan 2025” to Open. Pass the value “Jan 2025” to the Period Name variable.

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*a8tfIHAbVVEHleZbs0iR5w.png align="left")

Click on “Run” button to execute the Pipeline.

After a few seconds, you will notice the status of the Pipeline show as Success.

![](https://miro.medium.com/v2/resize:fit:634/1*m10vFh73PgkM_e_FBvvsWQ.png align="left")

Let;s go ahead and check the Period Status. Navigate to “***Application > Periods***”

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*GOTvM0um2RKvI6cUDDD98Q.png align="left")

The period status has been set correctly. You can now invoke this Pipeline from EPM Automate or using REST APIs to automate this.

If you configured the Pipeline to receive emails, you will receive an email with the details of the pipeline execution.

Press enter or click to view image in full size

![](https://miro.medium.com/v2/resize:fit:700/1*XeWaB32TQ221L4lPk3YvQg.png align="left")

### **What’s Next**

In the next article and video, I will show you how to invoke this Pipeline from Planning application. This is useful so that you can schedule the Pipeline in Planning so that this runs on a schedule. I will also cover how to invoke the pipeline from epm automate and using REST APIs.

Let me know if you have any questions on this. Make sure to subscribe to the articles and my YouTube Channel for updated content.