Oracle Fusion HCM Data Validator

In order to validate the data before loading them to an Instance Oracle has provided a tool to validate the DAT file. More detailed information is available under the following metalink note

Data File Validator Tool for HCM Data Loader (Doc ID 2022617.1)

To validate the DAT files, provide the following and click Validate:

• Configuration file –> Click Browse … and select the configuration file that contains the structure and validation definitions. You can use the configuration file delivered in the HDLDataFileValidationTool.zip. Alternatively, you can alter this configuration file to add your own validation.
• Data file / Archive file –> Click Browse … and select the .dat file or compressed zip file you want to validate. You can choose to provide a single .dat file or a zip file containing one or more .dat files.

Once you click Validate, the status information appears directly within the utility. The tool also generates an HTML report once the validation is complete. The HTML report provides a summary of the results