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
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.
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
- Invoke the Import Transactions job using the Jobs API. Here is a sample payload while invoking the REST API.
"jobName" : "importtmpremappedtransactions",
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)
- Invoke the Import Transactions job using data management API.
Other options to consider:
- Data Management can connect directly to load data from Oracle ERP Cloud
- EPM Integration agent can be used to connect to variety of data sources; cloud and on-premise, oracle and non-oracle.
Let me know which one you use the most in your implementations. Have fun. If you have questions feel free to connect with me.