4 Ways To Load Data to ARCS Transaction Matching Module

In this article lets see the different ways we can load data into Transaction Matching module in Oracle Account Reconciliation Cloud Service (ARCS). Click here to know more about Oracle ARCS and feel free to connect with me if you have questions on implementing Transaction Matching in Oracle ARCS.

So what are the 4 different ways and let’s take a look at each one in detail.

  1. Manual Load

Manual Load

If you have a pre-formatted file then navigate to “Application > Jobs > Transaction Matching”. Click on Actions > Import Transactions. Select the following and then click on “Submit”.

  • Match Type

In the example above, I have selected EDI_820_File.csv file to be loaded to the EDI820 data source.

Load Data using Data Management

The second option is to load the data using Data Management. For this you need to setup the Transaction Matching data source as a target application in Data Management.

Select the “Local” option while adding a new Target Application. Set Type as “Transaction Matching Data Sources” and then select the “Data Source” for the Application Name field. You may also provide a prefix if needed.

Click Ok and the new target application will be setup. Once this is complete make sure to create the Import Format, Location, Data Load Rule and Data Mapping.

To load the data manually, you can upload the file to data management and then execute the data load rule.

Load Data Using EPM Automate

If you have a pre-formatted file you can use EPM Automate to upload the file and the invoke the import process. Using EDI File load as an example, we will use the following commands to upload and import.

epmautomate uploadFile EDI_820_File.csv

epmautomate importTmPremappedTransactions Invoice_EDI EDI820 EDI_820_File.csv MM/dd/yyyy

Invoice_EDI is the Match Type, EDI820 is the data source name, EDI_820_File.csv is the file name and the date format is MM/dd/yyyy. Click here to learn more about the EPM Automate importTmPremappedTransactions command.

If you are configured Data Management to import data to Transaction Matching data source then you can utilize the runDataRule command. Click here to learn more about the syntax for the command. Make sure to upload the file to Data Management before executing the data load rule.

Load Data using REST APIs

The last option is to load data using REST APIs. If you have a pre-mapped file then you can use upload the file and then invoke the Import Transactions job.

  • Use the upload API to upload the file to ARCS
{
"jobName" : "importtmpremappedtransactions",
"parameters": {
"dataSource":"EDI820",
"reconciliationType":"Invoice_EDI",
"file":"EDI_820_File.csv",
"dateFormat": "MM/dd/yyyy"
}
}

If you have configured Data Management to import data to Transaction Matching data source then you would:

  • Use the upload API to upload the file to Data Management (this step is needed only if the data source is a File)

Other options to consider:

  1. Data Management can connect directly to load data from Oracle ERP Cloud

Let me know which one you use the most in your implementations. Have fun. If you have questions feel free to connect with me.

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