Learn About Loading Data into Oracle Fusion Cloud Human Capital Management
About the Architectural Components
The architecture used to bulk-load data to Oracle Cloud HCM by using the HCM Data Loader includes the following components:
-
Oracle Cloud HCM web UI: A comprehensive user interface that you can use for loading data, monitoring progress, and reviewing errors. It provides real-time information for all stages of processing. The Oracle Cloud HCM user interface shows detailed information about the component hierarchies and attributes of supported business objects.
-
HCM Data Loader: A convenient and powerful tool that you can use for data migration, data maintenance, and coexistence scenarios where human resources data is uploaded regularly to Oracle Cloud HCM. HCM Data Loader provides a SOAP API to automate the process of bulk-loading of data.
-
Oracle WebCenter Content: The infrastructure used to stage data files for processing by HCM Data Loader using WebCenter Content SOAP APIs and Java APIs to automate the process.
Before You Begin
Before you begin, review the following resources:
- HCM Integrations
- Using the Oracle HCM Cloud Adapter with Oracle Integration 3
- HCM Data Loader
- HCM Data Loading Business Objects
You must install the WebCenter Content Transfer Utility. The WebCenter Content Transfer Utility interface is part of WebCenter Content. The Utility has the following two options:
-
The preferred generic SOAP-based transfer utility (
oracle.ucm.fa_genericclient.jar
) which requires the Oracle JRF Web Service supporting libraries and uses JAX/WS over HTTPS to communicate with the WebCenter Content server. -
The original RIDC-based transfer utility (
oracle.ucm.fa_client.jar
), which is a feature-set Java library that encapsulates WebCenter Content RIDC and uses standard HTTPS to communicate with the WebCenter Content server. This tool won't work in the Oracle Fusion Cloud Applications environment because of authentication limitations that currently cannot be handled universally and programmatically.
In this solution, you must download the preferred generic SOAP-based transfer utility (oracle.ucm.fa_genericclient.jar
).
Follow these steps to download and install the WebCenter Content Transfer Utility:
- Go to Oracle WebCenter Content Downloads page in your browser.
- From the Optional Software Downloads section, download WebCenter Content Transfer Utility after you review and accept the Oracle License Agreement.
- Extract the ZIP file.
- Review the
WebCenter Content Document Transfer Utility Readme.html
to learn about the requirements and dependencies. - Install the preferred generic SOAP-based transfer utility (
oracle.ucm.fa_genericclient.jar
).
Upload ZIP Files to Oracle Cloud HCM Using HCM Data Loader
Perform these tasks to upload ZIP files to Oracle Cloud HCM using HCM Data Loader:
- Upload a ZIP file containing your DAT files on the WebCenter Content server.
- Submit a request to HCM Data Loader to import and load the ZIP file. For this step, you can use either the HCM Data Loader interface or the
HcmCommonDataLoader
web service. If you want, you can encrypt the data using PGP (Pretty Good Privacy) encryption. - If you use the
HCMCommonDataLoader
web service, execute theimportaAndLoadData
function from the web service. - HCM Data Loader decompresses the ZIP file and imports individual data lines to its stage tables. The stage tables group related data lines to form business objects. The the HCM Data Loader interface displays the errors during the import phase.
- HCM Data Loader calls the relevant logical object interface method (delivered in product services) to load valid objects to the application tables. Any errors that occur during the load phase are reported in the HCM Data Loader interface.
- Review any errors from the import and load phases. You use either the HCM Data Loader interface or the
getDataSetStatus
method from the HCM Data Loader web service. - Correct errors from the import phase and the load phase in your source data.
- Place a new ZIP file containing the corrected data on the WebCenter Content server.
About Tools for Staging Files on the Oracle WebCenter Content Server
You can stage a ZIP file on the Oracle WebCenter Content server by using one of these tools:
-
The Oracle Fusion Cloud Applications File Import and Export interface
-
The WebCenter Content Document Transfer Utility
-
The WebCenter Content Generic SOAP Web Service
About Required Services and Roles
You will need access to the following services:
-
Oracle Fusion Cloud Human Capital Management
-
Oracle WebCenter Content
These are the roles needed for each service.
Service Name: Role | Required to... |
---|---|
Oracle Cloud HCM: HCM Data Loader | Configure HCM Data Loader and HCM Spreadsheet Data Loader for bulk data loading. Import and load data using HCM Data Loader. Manage access to spreadsheet templates, and configure spreadsheets to suit business needs. |
Oracle Cloud HCM: HCM Integration Specialist | Access to view recent file loads, view business objects, import and load data, delete stage table data tasks in the Data Exchange work area in Oracle Cloud HCM. |
Oracle WebCenter Content: File Import and Export Management Duty (FND_FILE_IMPORT_AND_EXPORT_MANAGEMENT_DUTY) | Upload files to the Oracle WebCenter Content server. |
See Learn how to get Oracle Cloud services for Oracle Solutions to get the cloud services you need.