1. Administrator's Guide
  2. Integrating Data
  3. Loading Data
  4. Integrating Data Relationship Management with FDMEE
  5. Importing Data Load Mappings from Data Relationship Management

Importing Data Load Mappings from Data Relationship Management

You can import member mappings from Oracle Data Relationship Management. Import member mappings from Data Relationship Management support merge or replace modes, along with validate or no validate options for target members.

Once the mappings have been validated and imported, the imported maps are displayed on the Data Load Mapping screen.

To import member mappings from Data Relationship Management:

  1. On the Workflow tab, under Data Load, select Data Load Mapping.
  2. From Import options, select Import from DRM.
  3. From Import Mode, select the import mode:

    • Merge—Overwrites the data in the application with the data in the data load file.

    • Replace—Clears values from dimensions in the data load file and replaces it with values in the existing file.


    Image shows the Select Import Mode and Validation screen.
  4. From Validation, select to validate the member mappings.

    Validation ensures that all data in the imported GL has a corresponding mapping.

  5. In Execution Mode, select the mode for executing the import:

    • Online—Process the import immediately.

    • Offline—Runs the import in the background.

  6. Click OK.

    The following message is displayed: "Import Map from DRM has been submitted successfully."

    After the successful completion of the Import Process from DRM, data load mappings are available for edits and updates.

    You can check the status of the import using Process Details.