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