Image by Gerd Altmann from Pixabay

Load Balances in Oracle ARCS using EPM Automate

In this post we will understand how to import Balances into Oracle Account Reconciliation Cloud using EPM Automate. To learn more about Oracle ARCS head over to Oracle Documentation.

Prerequisites

  • Access to Oracle ARCS
  • EPM Automate has been installed
  • Basic understanding of EPM Automate and ARCS

There are two ways to import balances (Source and Sub System) data into ARCS. Those are using Pre-Mapped Balances and using Data Management.

Loading Pre Mapped Balances
The data file is formatted in a specific format and is ready to be consumed by ARCS. The file has to be comma delimited or tab delimited file. The minimum number of fields that you need are

  • Reconciliation Account ID (see below for example)
  • Amount
  • Currency

Once you have the data file ready, login to EPM Automate using the login command. Issue the following commands to upload the files and load balances into ARCS using EPM Automate.

# upload the files
epmautomate uploadFile GLBalances.csv
epmautomate uploadFile SubSystemBalances.csv
# load source system data
epmautomate importPreMappedBalances Jun-20 GLBalances.csv SRC Functional
# load sub system data
epmautomate importPreMappedBalances Jun-20 SubSystemBalances.csv SUB Functional
  • Jun-20 is the period
  • SRC / SUB denotes whether the data is Source System (GL)balance or Sub System Balance (Sub Ledger)
  • Functional denotes the currency bucket. The other options are Entered and Reporting

Import Balances using Data Management

In this approach we use data management to extract the fields that we need from the data file and load into ARCS. You will need to setup the following in Data Management before you can load balances data.

  • Source System
  • Import Format
  • Location
  • Data Load Rule
  • Data Mapping

One of the key configurations is the data load rule. This is where you specify the file name / file name format and the location of the file.

  • File Name : this can be a static file name or can be suffixed with Period Name or Period Key. In the above example, I am using Period Key
  • Directory : Location of the file
  • File Name Suffix Type : This can be Period Name or Period Key
  • Period Key Date Format : If you select Period Key as the File name suffix type, you will have to provide the format. In the above example Data Management looks for a file that ends in GL_Balances-YYYYmmdd.csv. For example, GL_Balances-20200728.csv.

If you need a detailed example let me know and I can create a video tutorial for you.

Let’s see how we can load the balances using data management. Login to ARCS from EPM Automate. The following code snippet can be used to upload the file and load balances into ARCS using Data Management.

# upload file to DM
epmautomate uploadFile GL_Balances-20200728.csv inbox
# invoke import Balances command
epmautomate importBalances OF_GL_BAL Jun-20
  • OF_GL_BAL : this is the Data Load definition you configure in ARCS. Navigate to Application > Configure > Data Loads to configure the data loads.
  • Jun-20 : Period Name

importBalances looks for a file in the inbox directory. Since we are not passing the location and file name in the importBalances command, the system gets that information from the Data Load Rule defined in Data Management.

Which Method Should You Choose?

This depends on your requirements. Here are few things to consider so that you can make an informed decision.

  • Drill Through : If you want to drill through from ARCS to ERP Cloud / Oracle EBS, you should use Data Management
  • Group Reconciliations : If you have multiple accounts being mapped to a single reconciliation ID in ARCS, you can maintain the mapping in Data Management. Using data management will allow you to audit the data in case you see any mistakes and want to investigate.
  • Keep it as simple as possible : Go for pre mapped balances option.

I hope this was helpful. What are some of the other factors you consider while deciding between Pre Mapped vs Data Management balances load options? Let me know. If you have questions, comments or suggestions let me know.

Manager Strategic Cloud Services (Oracle Cloud ERP, EPM), Integration Specialist, Big Data, Data Science & Python Enthusiast)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store