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 Integration to Load Data | Notes |
|---|---|---|---|---|
| GL Balances (Text File Load) |
Yes Importing Pre-Mapped Balances in Reconciliation Compliance and Transaction Matching |
Yes importPreMappedBalances in Working with EPM Automate |
Yes* |
*Balances are pulled from Data Management into Account Reconciliation (i.e. not a push from Data Integration into Account Reconciliation) |
| Subledger Balances (Text File Load) | Yes
Importing Pre-Mapped Balances in Reconciliation Compliance and Transaction Matching |
Yes importPreMappedBalances in Working with EPM Automate |
Yes* |
*Balances are pulled from Data Integration into Account Reconciliation(i.e. not a push from Data Integration into Account Reconciliation) |
| Reconciliation Compliance Transactions |
Yes Importing Pre-Mapped Transactions in Reconciliation Compliance |
Yes importPreMappedTransactions in Working with EPM Automate |
Yes |
Transactions are pulled from a source system into Data Integration. You execute a data load in Data Integration 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 importPreMappedTransactions in Working with EPM Automate |
Yes |
Transactions are pushed to Data Integration. No need to execute a data load. |
| Transaction Matching BAI (Bank file) or SWIFT MT940 format bank file** (Text File Load) | No | No |
Yes** Integrating BAI, SWIFT MT940, and CAMT.053 Format Bank File Balances and Integrating BAI, SWIFT MT940, and CAMT.053 Format Bank File Transactions |
**Special processor in Data Integration for BAI and SWIFT MT940
formatted files.
The BAI and SWIFT MT940 files are processed entirely through Data Integration. |
| Loading Exported Journal Entries Using Data Management | No | No |
Yes |
To learn how to export adjustments and transactions as journal entries in Account Reconciliation, (prerequisite to using Data Integration) see Exporting Adjustments or Transactions as Journal Entries in Setting Up and Configuring Oracle Account Reconciliation Cloud. |
| Exchange Rates (Text File Load) |
Yes |
Yes importRates in Working with EPM Automate |
No | |
| Profiles (Text File Load) |
Yes |
Yes importProfiles in Working with EPM Automate |
No | |
| ERP Data - GL Balances from Oracle Financials Cloud | No | No |
Yes See Integrating Oracle General Ledger Balances from the Oracle ERP Cloud. |
|
| ERP Data - GL Balances from Oracle NetSuite | No | No |
Yes |