Oracle HCM Cloud: Importing Data

Überblick

his 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.

 

Individueller Schulungseinstieg mit Oracle Training On Demand

Online-Training über das Internet, verfügbar rund um die Uhr, an sieben Tagen die Woche. Sie greifen auf gestreamte Vorträge zu, Whiteboards und Lab-Aktivitäten, können im Video suchen, es unterbrechen oder zurückspulen. Es handelt sich hierbei um aufgezeichnete Kurse. Der Zugang wird nur registrierten Benutzern gewährt (Named-User-Basis). Sie haben ab Wirksamkeitsdatum der Buchung 90 Tage Zugriff auf die Kurse.

Zielgruppe

  • Functional Implementer
  • Implementation Consultant

Kursziele

  • Load worker records
  • 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

Produktbeschreibung

  • Import and Export Data Overview
  • HCM Data Loader Overview
  • HCM Data Loader Business Objects and File Formats
  • HCM Data Loader: Data Considerations
  • Loading and Monitoring Data Using HCM Data Loader
  • Loading Data Using HCM Spreadsheet Data Loader
  • Loading Workers

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
E-Learning Oracle Training on Demand
Preis (exkl. MwSt.)
  • CHF 2'592.–

Nutzungsdauer: 3 Tage