11 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 11-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 |
Yes* |
*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 |
Yes* |
*Balances are pulled from Data Management into Account Reconciliation (i.e. not a push from Data Management into Account Reconciliation) |
| Reconciliation Compliance Transactions |
Yes Importing Pre-Mapped Transactions in Reconciliation Compliance |
Yes |
Yes |
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 |
Yes |
Yes |
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 | 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 |
No | |
| ERP Data - GL Balances from Oracle Financials Cloud | No | No |
Yes |
|
| ERP Data - GL Balances from Oracle NetSuite | No | No |
Yes |
Helpful Videos About Data Integration
Here is a list of available tutorial and overview videos that help you understand data integration topics: