1. Administering and Working with Oracle Enterprise Data Management Cloud
  2. Administration
  3. Integrating Data
  4. Importing Dimensions
  5. Working with Merge Imports

Working with Merge Imports

Merge imports capture changes in an import request instead of importing the data directly (as with Replace and Reset). This enables you to identify the incremental changes that were made in the import, view the import changes in transaction history, and synchronize import changes across viewpoints by using subscriptions.

When you run a Merge import, the data is imported following this process:

  1. The import source data is compared to existing data to identify differences.
  2. A draft request for the view of the bound viewpoints is created that contains request items and actions from the import differences.

    If there are no differences, the import request is not created and the user is notified.

    Note:

    The request item limit for merge imports is 20,000 items.
  3. Application-specific validations are run on the request:
    • By default, if no validation errors are found, the request is automatically submitted. You can deselect Auto-Submit to prevent the request from being automatically submitted. See Managing Import Options.
    • If validation errors are found, the request remains in Draft status in the Submit stage and is assigned to the user who ran the import. Email notification is sent to the user who is assigned to the request.

    Note:

    For Planning and Financial Consolidation and Close imports, the Cannot add a Predefined Member and Cannot change a Predefined Member property validations are not run.

  4. By default, the Approve and Commit stages are bypassed, request items are committed, and the request is set to Closed. Deselect Bypass Approvals and Commits to prevent the stages from being bypassed. See Managing Import Options.
  5. If the import contains request actions for a source viewpoint of a subscription, subscription requests are generated for the target viewpoints. Subscriptions for the same target view have their request items grouped into the same subscription request. See Subscribing to Viewpoints.

After the import is completed, you can click the import request link to navigate to the import request. If the request is in Submit or Approve stage, it is displayed in the request view. If it is closed, it is displayed in the inspector. You can view the import results in Transaction History.