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.
- Manual Load
- Data Management
- EPM Automate
- REST APIs
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
- Run Auto Match (Yes / No)
- Date Format
- Select file(s) from your local system
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.
