1. HCM Data Loader
  2. How You Validate Loaded Data

How You Validate Loaded Data

Once HCM Data Loader loads your data successfully, you're recommended to validate that the loaded objects appear as expected. This topic identifies some of the ways in which you can validate loaded data. These include use of:

  • Manual testing

  • Oracle Transactional Business Intelligence (OTBI) reports

  • HCM Extracts

Using Manual Testing

You can:

  • Validate data interactively by searching for a representative sample. For example, you can search for workers in the Directory or Manage Person work area. If a worker is also a manager, then you can explore the manager hierarchy.

  • Validate work structures by searching for them. For example, you can search for jobs on the Manage Job page and locations on the Manage Locations page. Alternatively, you can test that they're available for selection. For example, you can update a worker's assignment to select a different job or location.

Using Oracle Transactional Business Intelligence Reports

You can use predefined OTBI reports to validate some uploaded data. To run these reports:

  1. Open the Reports and Analytics work area.

  2. In the Contents pane of the work area, open the folder Shared Folders > Human Capital Management. Many subfolders of the Human Capital Management folder contain a Transactional Analysis Samples folder, which contains the predefined reports.

To list the predefined reports for an area, select the relevant Transactional Analysis Samples folder in the Contents pane and click the Browse Catalog icon. A list of predefined reports for the selected area, such as Workforce Management, appears in the work area. For example, you can run the Job Details report to list active jobs and the Location Details report to list active locations.

You can also design your own reports using Oracle BI Publisher. To open Oracle BI Publisher, select Create > Report in the Contents pane of the Reports and Analytics work area.

Using HCM Extracts

You can use HCM Extracts to extract data from Oracle HCM Cloud and deliver it in various formats. These formats include CSV, XML, Microsoft Excel, HTML, RTF, and PDF.