About Using Data Integration and Data Management

Data Integration can be used to perform all tasks that are performed using Data Management.

Data Import Tasks Performed Using Data Integration or Data Management

Use Data Integration or Data Management to perform the following tasks:

• Load balances

  • Load balances from a fixed-width or delimited file.

    See Integrating Data Using a File in Data Management.

  • Load balances from BAI Format Bank Files

  • Load balances from SWIFT MT940 Format Bank Files

  • Load balances from camt.053 Format Bank Statements

  See Integrating BAI and SWIFT MT940 Format Bank File Transactions and Balances in Administering Data Integration.

• Load Reconciliation Compliance transactions

  See Loading Reconciliation Compliance Transactions in Administering Data Integration

• Load Transaction Matching transactions

  • Export transactions to a Transaction Matching Target Application

    See Adding a Transaction Matching Target Application in Administering Data Integration

    Note:

    You can also aggregate transaction matching data. See Aggregating Transaction Matching Data in Administering Data Integration.

  • Load transactions from Bank (BAI) files to Transaction Matching

  • Load transactions from Bank SWIFT MT940 Bank Files to Transaction Matching

  • Load transactions from camt.053 Format Bank Statements

    See Integrating BAI, SWIFT MT940, and CAMT.053 Format Bank File Transactions in Administering Data Integration.

• Load Exported Journal Entries from Transaction Matching to ERP

  See Loading Exported Journal Entries in Administering Data Integration

Tasks Performed Using Data Integration Only

To use Data Integration (simplified user interface), access the Data Exchange card under Applications.

Use Data Integration to perform the following Account Reconciliation related 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.

  Note:

  You must add a new Merge ID for each new balance to load in Data Integrationin order to ensure correct drill back results from Account Reconciliation to Data Integration.

• Use the EPM Integration Agent available under Data Exchange to extract data from your on-premises data sources and then load the data directly to the Oracle Fusion Cloud Enterprise Performance Management.

  See EPM Integration Agent.

• Create pipelines to run a series of jobs as a single job. See Pipeline Job Types in Administering Data Integration.

  The job types that are specific to Account Reconciliation are as follows:

  • Import Rates (Reconciliation Compliance)
  • Import Pre-Mapped Balances (Reconciliation Compliance)
  • Import Balances (Reconciliation Compliance)
  • Import Pre-Mapped Transactions (Transaction Matching)
  • Run Auto Match (Transaction Matching)
  • Run Auto Alert (Transaction Matching)
  • Create Reconciliations (Reconciliation Compliance)
  • Import Attribute Values
  • Change Period Status (Reconciliation Compliance)
  • Generate Reports

  In addition to the above job types, you can also use job types that are common to Oracle Fusion Cloud EPM business processes (for example, Run Integration job type).

  For scheduling pipelines, connect a Oracle Fusion Cloud EPM business process with EPM Platform Job Scheduler to an Oracle Fusion Cloud EPM Account Reconciliation instance, create pipelines using the remote connection, and schedule pipelines using the EPM Platform Job Scheduler. See Scheduling Jobs in Administering Data Integration.

Watch Load Balances Using Data Integration Video

Click this link to watch a video: