10 Understanding Data Integration Overview

There are various ways to load data into Oracle Account Reconciliation. This topic helps you understand the type of data you may need to load and guides you to the right topics explaining how to accomplish it.

There are various ways to load data:

  • Use the Account Reconciliation user interface to load pre-mapped data. See Importing Pre-Mapped Balances or Transactions.
  • You can load transactions from Excel into Reconciliation Compliance using the Smart View extension for Reconciliation Compliance . See Smart View and Account Reconciliation in Working with Oracle Smart View for Office.
  • Use the EPM Automate Utility to load directly into Account Reconciliation. See Oracle Account Reconciliation Commands
  • Use Data Management to load data. See Importing Data using Data Management in this guide (Administering Oracle Account Reconciliation Cloud) and Using Data Management in Administering Data Management for Oracle Enterprise Performance Management Cloud.
  • Use Data Integration to access the simplified user interface to load data by accessing the Data Exchange card under Applications. Data Integration allows you to access the simplified user interface that allows you to accomplish the following tasks:
    • Set up a data integration that allows an incremental data load (not a full refresh of all data points) and replaces a portion of a previous data load by adding a Merge ID in Map Dimensions. See Adding an Account Reconciliation Merge Balance Dimension in Administering Data Integration for Oracle Enterprise Performance Management Cloud.
    • Use the EPM Integration Agent available under Data Exchangein order to extract data from your on-premises data sources and then load the data directly to the Oracle Enterprise Performance Management Cloud. See EPM Integration Agent

This overview helps you find the right topic based on type of data to load.

Table 10-1 Data Loading in Account Reconciliation Cloud (ARCS)

Type of Data Pre-Mapped Data Using Account Reconciliation Cloud User Interface Pre-Mapped Data Directly to Account Reconciliation Using EPM Automate Utility Use Data Management to Load Data Notes
GL Balances (Text File Load)

Yes

Importing Pre-Mapped Balances in Reconciliation Compliance and Transaction Matching

Yes

EPM Automate Utility importpremappedbalances

Yes*

Integrating Using a File in Data Management

*Balances are pulled from Data Management into Account Reconciliation (i.e. not a push from Data Management into Account Reconciliation)
Subledger Balances (Text File Load) Yes

Importing Pre-Mapped Balances in Reconciliation Compliance and Transaction Matching

Yes

EPM Automate Utility importpremappedbalances

Yes*

Integrating Using a File in Data Management

*Balances are pulled from Data Management into Account Reconciliation (i.e. not a push from Data Management into Account Reconciliation)
Reconciliation Compliance Transactions (Text File Load)

Yes

Importing Pre-Mapped Transactions in Reconciliation Compliance

Yes

EPM Automate Utility importpremappedtransactions command

Yes

Loading Reconciliation Compliance Transactions

Transactions are pulled from a source system into Data Management. You execute a data load in Data Management to export the transactions into Account Reconciliation in a CSV file with the same format as an Account Reconciliation pre-mapped transactions import file.
Transaction Matching Transactions

Yes

Importing Pre-Mapped Transactions for Transaction Matching

Yes

EPM Automate Utility importtmpremappedtransactions command

Yes

Adding a Transaction Matching Target Application

Transactions are pushed to Data Management. No need to execute a data load.
Transaction Matching BAI (Bank file) or SWIFT MT940 format bank file** (Text File Load) No No

Yes**

See Integrating Bank BAI and SWIFT MT940 Files with Oracle Account Reconciliation

**Special processor in Data Management for BAI and SWIFT MT940 formatted files.

The BAI and SWIFT MT940 files are processed entirely through Data Management

Loading Exported Journal Entries Using Data Management No No

See Loading Exported Journal Entries

To learn how to export adjustments and transactions as journal entries in Account Reconciliation, (prerequisite to using Data Management) see Exporting Adjustments or Transactions as Journal Entries in the Setting Up and Configuring Oracle Account Reconciliation Cloud guide.
Exchange Rates (Text File Load)

Yes

Yes

EPM Automate Utility importrates command
No  
Profiles (Text File Load)

Yes

Yes

EPM Automate Utility importprofiles command

No  
ERP Data - GL Balances from Oracle Financials Cloud No No

Yes

Integrate with Oracle General Ledger

 
ERP Data - GL Balances from Oracle NetSuite No No

Yes

Integrate with Oracle NetSuite