1. HCM Data Loader
  2. Overview of Automating Data Loading

Overview of Automating Data Loading

You can automate HCM Data Loader processes to load data to Oracle HCM Cloud and extract both status and error information. This topic provides an introduction to the automation processes.

The processes that you can automate are:

  • Delivery of .zip files to the Oracle WebCenter Content server

  • Initiation of HCM Data Loader to process files on the WebCenter Content server

  • Initiation of the HCM Data Loader Data Set Summary extract and retrieval of its output

Complete instructions are provided in Automating HCM Data Loader on My Oracle Support.

DOC ID 1664133.1

Delivering Files to Oracle WebCenter Content Automatically

To automate the delivery of .zip files to the WebCenter Content server, you can use:

  • The WebCenter Content Document Transfer Utility, a feature-rich Java library that provides content import and export capabilities

  • WebCenter Content Generic SOAP Web Service, which exposes a SOAP web service interface (GenericSoapPort) that supports various operations, including file upload

Initiating HCM Data Loader Automatically

You can initiate HCM Data Loader automatically to process multiple files on the Oracle WebCenter Content server using the HCM Data Loader Integration Service. This web service provides the two methods shown in this table.

Method

Description

importAndLoadData

Initiates the processing of a data file

getDataSetStatus

Returns the current status of a data file

Several ways exist of running the web service. For example, you can use generated proxy classes.

For more information on using the HCM Data Loader Integration Web Service, see: HCM Data Loader Integration Web Service

Initiating the HCM Data Loader Data Set Summary Extract Automatically

HCM Extracts is a tool for reporting and outbound integrations. When you use HCM Extracts as part of an integrated process, you can initiate it automatically from an automated flow. The Payroll Flow Engine is the generic processing engine that you use for this purpose.

When you save a copy of the predefined HCM Data Loader Data Set Summary extract, you also create a payroll flow of type Extract. You can initiate this payroll flow using the FlowActionsService, which you use to automate and monitor the extract. You use the payrollProcessingActionService.fetchExtractOutput method to download the extract output. When the extract is associated with a BI template, the payroll flow ensures that the BI report is generated and written to the BI server.

Related Topics