Create Reconciliations in Oracle Account Reconciliation using Data Pipeline
In my last article we explored how to create a data pipeline in Account Reconciliation to set the period status. That was a pretty simple one. I hope you are feeling awesome about creating that one.
Let’s now explore how to create a pipeline that will create reconciliations in Account Reconciliation.
Reconciliation Creation Process Overview
Before we configure the pipeline to create the reconciliations, let’s review the general process to create a reconciliation from the profile.
Navigate to Application > Profiles
Actions > Create Reconciliations
Select the Period
Click on the Apply button
Select whether you want to create the reconciliation for the selected profile or all the profiles based on the filters currently applied
Click on the Apply Button
The key take away from this overview is that we create the reconciliations from the profiles.
Creating the Pipeline
Alright, let’s go ahead and create the pipeline. Navigate to Application > Data Exchange > Create Pipeline
Give the Pipeline Name and Pipeline Code
Pipeline Name : create recon
Pipeline Code : CREATERECON
Press enter or click to view image in full size
Click on Save and Continue
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.
Press enter or click to view image in full size
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
Once you create the stage, go ahead and create a new job in the Stage. Provide the following information.
Type: Create Reconciliations
Tile: create recon
Press enter or click to view image in full size
You will notice that we need to provide values for “Period” and “Filter”.
For period, we will use the variable we defined (periodName). For Filter, we need to create a filter in the application. Let’s do that and then come back and edit the pipeline. Go ahead and click the “Save” button.
Creating a Filter
To select the filter in pipeline, we need to first create a filter. Follow the steps below:
Navigate to Application > Configuration > Filters
Create a new filter and provide a name
Select the type as Profile
Create new Condition
Set the condition as shown below
Once finished, click on OK button
The above condition filters the profiles based on the method and specifically looks at Profiles that has a method of “Balance Comparison”.
The next step is to publish the filter and make it public.
Press enter or click to view image in full size
That is it for creating the filters.
Complete the Data Pipeline Configuration
Let’s edit our data pipeline and profile the filter that we published.
Edit the pipeline
Navigate to the job
Select the filter “BC Profiles” from the available list of filters
- Click on Save
Testing the Pipeline
Now that we have configured the pipeline, let’s go ahead and test the pipeline.
👉 Navigate to Data Exchange and run the pipeline
Provie the period name and other parameter values as necessary.
Click the “Run” button to execute the pipeline.
The pipeline has executed successfully.
Let’s check the reconciliations and make sure the reconciliations were created successfully.
Navigate to Recoconcliations and select the period as “Jun-24” and Method as “Balance Comparison”.
All the Balance Comparison reconciliations are created successfully for the period. Great job!!!
Conclusion and Next Steps
The pipeline allows you to create the reconciliations based on the filter. You can invoke the pipeline from another application like Planning or FCC.
📽️📽️ I will be making a video explaining the process as well. So make sure to subscribe to my YT channel.
If you like the articles and want to support me, you can join my YT channel as a member or Buy Me a Coffee 🍵.
