Is it possible to integrate non oracle systems to ARCS and get reconciliation done frequently without any manual intervention?

Problem Statement

Is it possible to integrate non oracle systems to ARCS and get reconciliation done frequently without any manual intervention?

ARCS Functionality

Oracle ARCS is a robust and secure solution for managing and automating account reconciliation period end processes, and performing large scale transaction matching, improving efficiency and accuracy of financial processes and statements. With ARCS key capabilities, you can perform tasks such as automate high volume transaction matching and directly integrate with period end reconciliations.

It is a purpose-built solution on the cloud for managing the global reconciliation process.

You can load transactions for past and current period and can perform complex reconciliations across unlimited data sources using unlimited attributes.

Solutions

To load data to ARCS you can use file-based integration. It does not matter what ERP system you are using be it Oracle or Non -Oracle or your non-financial data systems. You can extract data in file in required format and can automate the whole data upload process. There are various ways to load data into Oracle Account Reconciliation.

Methods of Loading Data into Account Reconciliation

There are various ways to load data:

1. Use the Account Reconciliation user interface to load pre-mapped data.
2. Importing Transactions directly from Excel using the Smart View Extension for Reconciliation Compliance.
3. Use the EPM Automate Utility 
4. Use the Data Management or Data Integration
5. Use the EPM Integration Agent 

1. Use the Account Reconciliation user interface to load pre-mapped data

 Transactions and balances can be imported using flat files in ARCS. it allows to - 

• Import pre-mapped balances for both Reconciliation Compliance and Transaction Matching
• Import pre-mapped transactions for Reconciliation Compliance
• Import pre-mapped transactions for Transaction Matching

2. Importing Transactions directly from Excel using the Smart View Extension for Reconciliation Compliance
You can use Excel to load transactions into Reconciliation Compliance by using the Smart View Account Reconciliation extension. The direct integration requires the base installation of Smart View plus the Smart View extension for Reconciliation Compliance.

3. Use the EPM Automate Utility 
EPM Automate enables users to remotely perform tasks within ARCS. EPM Automate provides the commands to import pre-mapped balances, import pre-mapped transactions, import balances using Data Management or Data integration, import mapping, import rates and import attributes values.

4. Use the Data Management or Data Integration

ARCS provides the flexibility to import balances and transactions by using Data Management or Data Integration.

5. Use the EPM Integration Agent 

Data and Metadata can be extracted from on-premises data source and then load the data directly to the ARCS using the EPM Integration Agent. The EPM Integration Agent executes a query against an on-premises relational database and then loads the data or metadata to the EPM Cloud. The EPM Integration Agent is defined as a data source for an integration. The EPM Integration Agent may also be extended by way of scripting to access other data sources including third-party REST APIs, non-relational sources, or any system or systems that can be accessed using a Jython, Groovy, or Java program.

Thank you!