7 Common Applications Configuration: Define Batch Data Loads

This chapter contains the following:

The Load Batch Data Process: Explained

Loading Batch Data into Oracle Fusion: Explained

Load Batch Data Parameters

Data-Load Batch-Status Values: Explained

Data-Load Object-Status Values: Explained

FAQs for Define Batch Data Loads

The Load Batch Data Process: Explained

Load batch data is an open-interface process for loading volume data, for a specific subset of objects, into Oracle Fusion Human Capital Management (HCM).

As the data loader uses Oracle Fusion object and service interfaces to load the data, the following occur during the data load:

Data is validated using business logic.
Default values are used where necessary.
Events are generated where applicable.
Other post-processing logic is applied.

The data loader is used:

By HCM coexistence, the packaged solution for integrating applications such as Oracle PeopleSoft HRMS and Oracle E-Business Suite HRMS with Oracle Fusion HCM
By Oracle Fusion configuration tools, such as the Enterprise Structures Configurator
To import users

The data loader is also available for use by other source applications.

The following figure shows an overview of the data-load process.

To use the data loader, you:

Map data between your source application and Oracle Fusion HCM.
Extract data from your source application and place it in the data loader stage tables in the supported Oracle Fusion HCM object data format.
Run the Load Batch Data process to load the data into Oracle Fusion HCM.

Loading Batch Data into Oracle Fusion: Explained

The Load Batch Data process, which you run from the Data Exchange work area, imports data into Oracle Fusion from external sources.

From the Load Batch Data page, you can:

Load data (for example, for HCM coexistence).
Monitor data loads.
Correct data errors.
Rerun data loads.

Loading Data for HCM Coexistence

To load data for HCM coexistence, you run the HCM coexistence process Load HCM Data, which comprises two phases: Import and Load. If you select both phases of that process, then the Load Batch Data process runs automatically to complete the Load phase. If you select the Import phase only, then you must run the Load Batch Data process manually to complete the Load phase. In this case, when running Load Batch Data you select the batch name that you created for the HCM coexistence process Load HCM Data.

Monitoring Data Loads

You can monitor the status of a data load in the Batch Status column of the Search Results section of the Load Batch Data page. Detailed information about any data load that you select in the Search Results section appears in the Details section of the page.

Correcting Data Errors

On the Failed tab in the Details section for a batch data load, you can see the details of any errors.

To resolve the errors and complete the data load, you can:

Change the status of objects with errors to Ignore to prevent them from being processed when you next run the data load.
Select all objects with errors in the Details section and select Create Batch. The selected objects are removed from the original batch and added to a new batch, so that you can fix the problems later.
View the details of objects with errors from the Failed Objects column of the Batch Summary tab in the Details section, and correct the data. These corrections are applied to the data in the stage table. This approach is helpful if you want to be sure that the correction has fixed the original error before applying it to the source data. However, you must still apply any corrections to the source data; otherwise, discrepancies between the source data and the data loaded into Oracle Fusion will cause errors when you next load the data.

Rerunning Data Loads

After correcting any errors, you can select the batch file in the Search Results section and click Run. Any object with the status Error in Row is reset to Ready to Process and included in the load. Objects with the status Successful or Ignore are not processed.

Load Batch Data Parameters

The Load Batch Data process imports batch data into Oracle Fusion from external sources. You run Load Batch Data from the Data Exchange work area.

Load Batch Data Parameters

Batch Name

The name of the batch file to be loaded.

Loader Chunk Size

The number of logical business objects that a single Load Batch Data thread processes in a single action.

Loader Maximum Errors Allowed

The maximum number of errors in a thread before processing terminates. If an error occurs during the processing of a complex logical business object (such as a person record), then all rows for that business object are rolled back and marked as Error in Row.

Loader Number of Processes

The number of Load Batch Data threads to run in parallel. If you are processing large amounts of data (for example, more than 1000 rows) or complex data (such as person and work relationship data) consider running 4 or 8 threads in parallel.

Data-Load Batch-Status Values: Explained

The Data Exchange work area displays batch-status values for the Load Batch Data and Load HCM Data tasks. This topic explains the batch-status values.

Batch Status	Description
New	The batch is new and has not been processed.
Processing	The data-load process for the batch is currently running.
Refresh AM	The data-load process for the batch is performing an internal refresh against the Application Module (clearing the loader cache).
Canceled	The data-load process for the batch has been canceled.
Complete with Errors	Data-load processing for the batch is complete; object instance errors exist.
System Error	The data-load process for the batch was terminated by a system error.
Complete	The data-load process for the batch completed successfully.

Data-Load Object-Status Values: Explained

From the Batch Summary and Failed tabs in the Details section of the Load Batch Data page, you can display information about the load status of individual business objects. This topic explains the object-status values.

Object Status	Description
New	The object is new and has not been processed.
Pending Action	During the import phase, a validation error occurred for the object instance. (Typically, this status is set by Oracle Data Integrator.)
Ready to Process	The object has not been processed but is ready for processing.
Error in Row	The object is in error. Either the object itself is in error or the complex business object to which it belongs is in error.
Ignore	The object is to be ignored during processing.
Successful	The object has been successfully processed.

FAQs for Define Batch Data Loads

What happens if I cancel a Load Batch Data process?

The Load Batch Data process completes the processing of any business objects currently in progress, but does not process further objects.