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
Setting the HCM Data Loader Configuration Parameters
Initiating Data Load
Monitoring the Progress of the Loaded Data
Managing Errors
HCM Data Loader
Automation Process
Loading Workers
Creating User Accounts
Loading Worker Records
Supplying Mandatory Components Required to Load a New
Worker
Loading Supervisors and Updating Existing Workers
Canceling or Terminating a Work Relationship
Correcting or Reversing a Termination
Running the Post-Load Processes
Loading User Updates
Description:
This Oracle HCM Cloud: Importing Data training helps you
develop an understanding of the HCM Data Loader
functionality and the business objects and file formats
it uses. Explore various kinds of data you can load using HCM
Data Loader, while learning the import and load data
process; review and edit errors through a combination of
interactive lessons and hands-on activities.
Learn To:
Describe the key features and benefits of HCM Data
Loader.
load supervisors and update existing workers.
Cancel or terminate a work relationship.
Run the post-load processes.
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.
Benefits to You
By taking this course, you will develop a better
understanding of the key concepts of HCM Data Loader. You can
efficiently load various kinds of data in bulk. You'll
also walk away with the knowledge and skills to load worker records
and identify the mandatory components you need to supply
to load new workers.
Please Note
This course is relevant for customers using Fusion
Applications through Release 11.1.11. It's beneficial for both Oracle
Cloud and on-premises deployments.
