Reference: Information on Loading Data

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

Table 13-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	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 Integrating Oracle NetSuite