Step 2: Validating Source Data

FDMEE Validation of the source data confirms that all members are mapped to a valid target system account. If there are any unmapped dimension maps within the source file, a validation error occurs. Validation compares the dimension mapping to the source file and identifies unmapped dimensions. The process flow cannot continue until all dimensions are properly mapped.

  To run the validation process:

  1. On the Workflow tab, under Data Load, select Data Load Workbench.

  2. Select Validate.

Validation with No Mapping Errors

When validation is successful, the orange Validate fish is displayed in the header of the FDMEE screen.

Validation with Mapping Errors

Because newly added dimension members may be unmapped, the addition of dimension members to source systems can produce validation errors. If a dimension member is unmapped, the Validate fish is grey and a Validation Error screen is launched in the Workbench, which shows the number of dimension members that are not mapped (that are, therefore, undefined). You must correct any unmapped dimension members before running the validation again.

Image shows Validation Errors screen

  To correct conversion-table errors:

  1. In the top region of the Validation screen, highlight a row that requires correction.

  2. Correct any unmapped accounts.

    In the top region of the Validation Error screen, the unmapped item is inserted into the Source value, and the bottom region shows all row with that source value. For example if the top region displays a value of Entity dimension with Source Value 01, then bottom region should show all rows where ENTITY = ‘01’.

    See Defining the Import Format Mappings.

  3. Click Validate to refresh the validation form.

    Source data that passes the validation process can be loaded to the target system.

Fixing the Mapping Errors

In the Data Load Workbench, you can view mapping errors and fix them instantly when mapping errors have occurred.

  To fix mapping errors:

  1. From Data Load Workbench, select the Validation Errors tab.

    Image shows Validation Errors tab.

  2. Select Fix Maps to access the mappings.

  3. From the Data Load Mappings screen, fix any errors.

    Image shows Data Load Mapping screen.

  4. Click Validate, and then click Save.

Validating Financial Management Data Intersections

When running the validation step, Financial Management you can run the Intersection Check Report to check the data. such as the data intersections (cell status of account, entity, and so on) from the Financial Management target application.

Intersection check reports are generated as part of the data validation step in the data load workflow.

This feature is enabled in the Check Intersection option in Application Options. See Defining Application Options for Financial Management.

  To run an intersection check:

  1. In the top region of the Validation screen, click Generate Intersection Check Report.

  2. When prompted, save or open the Intersection Check Report.

  3. Correct validation errors and rerun the validation step.