1. Administering Account Reconciliation
  2. Understanding Data Integration for Oracle Account Reconciliation
  3. Importing Data Using Data Management or Data Integration
  4. Defining and Saving a Data Load Definition
  5. Steps to Create and Save a Data Load Definition

Steps to Create and Save a Data Load Definition

Use the New Data Load dialog to create and save a data load definition.

To create a new data load definition:

  1. From Home in Account Reconciliation, select Application, then Configuration, then Data Loads.
  2. On Manage Data Loads, select + (New).
    Data load definition dialog
  3. Optionally, you can use a saved data load.
  4. For a new data load, enter a Name for the data load.

  5. Optionally, enter a Description

  6. Select the Mode used to import balances. See About Modes of Importing Data for a description of the import modes.

  7. Decide whether to select the Allow Blank Segment Values check box.

    Note:

    When mapping to a Reconciliation Account ID within Account Reconciliation, there are considerations for blank target segments. If there are blank segments in between two populated segments in the target reconciliation, Account Reconciliation treats each blank/null segment values in the middle of a Reconciliation Account ID as three blank spaces. Account Reconciliation also trims off the trailing NULL segments after the last populated segment.

    For example, a Group Reconciliation with the following Reconciliation ID: "001-null-null-1925 XXX" (the "null" in Account Reconciliation would be non-existent (void of characters) when viewing the Reconciliation/Profile.) The design of Account Reconciliation replaces the "null" at the database tier with three spaces for each blank/null segment in between the populated segments. The Target Mapped Profile in Data Management needs the following: "ACCOUNT ID 001- - -1925 XXX" to align with Account Reconciliation.

  8. Decide whether to select the Execute data load rules in parallel check box to run all data load rules in parallel instead of the default which is to run one at a time.

  9. To translate source system balances to any configured higher currency buckets, select Translate balances to higher currency buckets. From the list adjacent to this option, select the Rate Type.

    This option is not displayed if there is only one currency bucket configured in System Settings.

  10. Select the Location which is the Data Management or Data Integration location to import.