Oracle HCM Cloud: Importing Data

Duration: 3 Days

What you will learn

This Oracle HCM Cloud: Importing Data training helps you develop an understanding of the HCM Data Loader and HCM
Spreadsheet Data Loader functionalities and the business objects and file formats it uses. Explore the various kinds of
data you can load, while learning the import and load data process; review and edit errors through a combination of
interactive lessons and hands-on activities.
This course is relevant for customers using Fusion Applications through Release 11.1.12. It’s beneficial for both Oracle
Cloud and on-premises deployments.

Learn To:

Describe the key features and benefits of HCM Data Loader.
Describe the Oracle HCM Cloud business object shape and business object hierarchy.
Describe the HCM Data Loader .dat file format.
Generate HCM Data Loader template file.
Use source keys, user keys, surrogate IDs, and GUIDs.
Load attachments and images, translated data, and flexfield data.
Describe the basic features of HCM Spreadsheet Data Loader.
Create new spreadsheet templates and generate a spreadsheet.
Import data to a spreadsheet and upload spreadsheet data.
Load worker records.

Benefits to You

By taking this course, you will develop a better understanding of the key concepts of HCM Data Loader and HCM
Spreadsheet Data Loader. You can efficiently load various kinds of data in bulk.

Audience

Functional Implementer
Implementation Consultant

Course Objectives

Load supervisors and update existing workers
Load user updates
Cancel or terminate a work relationship
Understand teh key concepts of HCM Data Loader
Understand the HCM Data Loader .dat file format
Create a basic .dat file
Load numeric values, dates, and times
Load lookup-validated attributes
Supply date-effective history
Describe the HCM Data Loader automation process
Understand the key concepts of HCM Spreadsheet Data Loader
Create new spreadsheet templates
Generate a spreadsheet from a spreadsheet template
Import data to a spreadsheet and upload spreadsheet data
Load worker records

Course Topics

Import and Export Data Overview

Ways in which Oracle HCM Cloud Supports Data Import
Basic Features of HCM Data Loader
HCM Data Loader Restrictions
Basic Features of HCM Spreadsheet Data Loader
Import Data Using Specialized Data Loaders
Selecting the Appropriate Data-import Mechanism

HCM Data Loader Overview

Key Features of HCM Data Loader
Importing and Loading Data Using HCM Data Loader
Identifying and Correcting Errors by Using HCM Data Loader
Data Set Summary and Data Set Status
Benefits of Using HCM Data Loader

HCM Data Loader Business Objects and File Formats

Oracle HCM Cloud Business Object Shape
Business Object Hierarchy
HCM Data Loader Dat File Format
Creating a Basic Dat File
Generating HCM Data Loader Template Files

HCM Data Loader: Data Considerations

Loading Numeric Values, Dates, and Times
Loading Lookup-Validated Attributes
Supplying Source Keys, User Keys, Surrogate IDs, and GUIDs
Supplying Date-Effective History
Setting Not Null Values to Null
Loading Attachments and Images
Loading Translated Data
Loading Flexfield Data

Loading and Monitoring Data Using HCM Data Loader

HCM Data Loader Configuration Parameters
Initiating Data Load
Monitoring the Progress of the Loaded Data
Managing Errors
HCM Data Loader Automation Process

Loading Data Using HCM Spreadsheet Data Loader

HCM Spreadsheet Data Loader Overview
Prerequisites to Use HCM Spreadsheet Data Loader
Spreadsheet Restrictions
HCM Spreadsheet Data Loader Process Summary
Creating and Editing Spreadsheet Templates
Reviewing the Spreadsheet Template
Generating SPreadsheets
Importing and Loading Spreadsheet Data

Loading Workers

Creating User Accounts
Loading Worker Records
Loading Supervisors and Updating Existing Workers
Canceling or Terminating a Work Relationship
Correcting or Reversing a Termination
Loading User Updates