1. HCM Data Loader
  2. How You Test the HCM Data Loader Process Flow and Connections

How You Test the HCM Data Loader Process Flow and Connections

In a new environment, you may want to test HCM Data Loader end-to-end processing without creating unwanted data. Once you're sure that HCM Data Loader processing and connections are working as expected, you can load your own data with confidence.

This topic describes how to test HCM Data Loader end-to-end processing.

Testing End-to-End Processing

HCM Data Loader provides:

  • A process, Test HCM Data Loader Process Flow and Connections

  • An object, Example Object

When you submit the Test HCM Data Loader Process Flow and Connections process, set the Action parameter to Test HCM Data Loader. The process:

  1. Generates a file of MERGE instructions for the Example Object

  2. Adds the ExampleObject.dat file to the ExampleObject||<date and time>||.zip file

  3. Uploads the .zip file to the hcm/dataloader/import directory on the Oracle WebCenter Content server

  4. Initiates HCM Data Loader to import and load the file

  5. Provides a log file

You can review progress and results on the Import and Load Data page.

The Example Object

When you run the Test HCM Data Loader Process Flow and Connections process, the Example Object data is saved to its own tables. No data is saved to the application tables. You can review the structure and attributes of the Example Object on the View Business Objects page in the Data Exchange work area. The example object:

  • Has child and grandchild components and a translation object

  • Supports all key types

  • Supports Create and Delete actions

  • Has attributes of most data types

  • Has lookup-validated attributes

You can generate a template file for the Example Object.

Note: Although an Example Object Translation object exists, no translation data is generated when you run the Test HCM Data Loader Process Flow and Connections process.

Deleting the Test Data

You're recommended to run the Test HCM Data Loader Process Flow and Connections process periodically to delete the test data and associated data sets. When you submit the process, set the Action parameter to Delete test data. In this case, the process generates a file of DELETE instructions, adds it to the DeleteExampleObject||<date and time>||.zip file, and uploads it.