Oracle HCM Cloud: Importing Data (D99371) – Outline

Detailed Course Outline

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