1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integrating Data
  3. Integrating Account Reconciliation Data
  4. Loading Reconciliation Compliance Transactions
  5. Loading Reconcilation Compliance Transactions Process Description

Loading Reconcilation Compliance Transactions Process Description

At a high level, this is how you load Reconciliation Compliance Transactions to Account Reconciliation using Data Management.

Note:

As a best practice recommendation while loading transactions throughData Management, do not replicate your General Ledger or Subledgers in Account Reconciliation. Loading activity from your ERP is not a best practice for period end reconciliations. If you need to load more than a 100 transactions; then as an implementer, you need to ask more questions to better understand the customer's requirements. For a reviewer, a large number of transactions for period-end reconciliation would be difficult to review. Use cases with higher volumes of transactions are candidates for Transaction Matching and not Reconciliation Compliance.

To set up the load for Reconciliation Compliance Transactions in Data Management.

  1. Create a local target application for Reconciliation Compliance Transactions.

    See Adding a Reconciliation Compliance Transactions Application.

  2. Map Reconciliation Compliance Transactions attributes to dimensions.

    See Mapping Reconciliation Compliance Transactions Attributes to Dimensions.

  3. Create the import format for the Reconciliation Compliance Transactions.

    See Creating an Import Format for Reconciliation Compliance Transactions.

  4. Create the location to associate with the import format.

    See Defining the Location.

  5. Define the period for the Reconciliation Compliance Transactions.

    See Defining a Period for Reconciliation Compliance Transactions.

  6. As a requirement in Data Management, create a data load mapping to pair intersections of data from the source to the target during the data load.

    Data load mappings are not used with Reconciliation Compliance Transactions.

    See Creating a Data Load Mapping for Reconciliation Compliance Transactions.

  7. Run the data load rule.

    See Running the Data Load Rule for Reconciliation Compliance Transactions.

  8. In Account Reconciliation, prepare the reconciliation.

    For more information, see Importing Data Using Data Management.