1. Administering Account Reconciliation
  2. Understanding Data Integration for Oracle Account Reconciliation
  3. Understanding Data Integration Overview
  4. Methods of Loading Data Into Account Reconciliation

Methods of Loading Data Into Account Reconciliation

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

Note:

When loading data, you need to ensure that the usage of segment and subsegment values is consistent. For example, in the subsegment Store, the value "Store_1215" is different from "Store_1215 " (note the extra space at the end of the second value). Unexpected results may occur if the same segment value is not used consistently for each load.