Our Courses

(24A) Oracle Fusion Cloud HCM: Extracting Data

About This Course

This course will provide detailed knowledge of Human Capital Management Data Extract. Through instructor presentations and demonstrations you will understand the architecture used for data extract, features and components of data extract, extract types and delivery options, construction of data extract definitions, data groups and user entities, and using fast formulas in extracts. Through user completed exercises you will experience the construction and definition of extracts.

2 Days

10 Lectures

Copied

Course Content

Extracting Data Overview

  • Common Questions
  • Using HCM Extracts
  • What are HCM Extract features?
  • What are the components of an HCM extract?
  • How are User Entities used with extracts?
  • HCM Extract Definition Example
  • Running Extracts
  • Delivered HCM Extract Definitions
  • What do I need to keep in mind when using delivered extracts?
  • Key Points
  • Demonstration

Creating Extracts

  • Common Questions
  • HCM Extract Tasks
  • Extract Definitions Task
  • Designing Extracts
  • Creating Extracts
  • Extract Definition Properties
  • Data Group Properties
  • Record Properties
  • Attribute Properties
  • Validation
  • Preview Extracts
  • Submit Extract
  • View Extract Results
  • Key Points
  • Practices

Extracts Output and Delivery

  • Common Questions
  • Extracts Output and Delivery Overview
  • BI Publisher
  • Delivery Options
  • Dynamic Content in Output File Name
  • Delivering Encrypted Data
  • Key Points
  • Demonstration
  • Practices

User Entities and Database Items in Detail

  • Common Questions
  • Definitions
  • Database Items
  • Threading Database Items
  • User Entity Details User Interface
  • Reviewing User Entity Details
  • Reviewing Database Items
  • Reviewing Contexts
  • Reviewing Queries
  • Reviewing Extracts Using the User Entity
  • Key Points
  • Practice

Fast Formulas for Extracts

  • Common Questions
  • Extract Criteria Formula Type
  • Extract Rule Formula Type
  • Extract Advanced Condition Formula Type
  • Extract Record Formula Type
  • Flow Schedule Formula Type
  • Key Points
  • Practice

Design Tips

  • Common Questions
  • Extract Design Considerations
  • Using Delivered Extracts
  • Best Practices: Extract Design
  • Extract Design Process with Checkpoints
  • Design Process Checkpoints
  • Use Filter Criteria
  • Minimize the Use of Formulas
  • Key Points

Performance Tips

  • Common Questions
  • Extracts Process Diagnostics Report
  • Running the Extracts Process Diagnostics Report
  • Performance Tips
  • Baseline Only
  • Delete Archives
  • Retention Period for Archive Data
  • Purge Extract Archive Information
  • Compression
  • Changes-Only Extracts
  • Changes-Only Extracts: Best Practices
  • Key Points
  • Demonstration

Troubleshooting Tips

  • Common Questions
  • Troubleshooting by Viewing Extract Results
  • Criteria
  • Instance Details
  • Extract Delivery Options
  • Diagnostics
  • Extracts Process Data Diagnostics Report
  • Key Points
  • Practice

Payroll Interface Extract Overview

  • Common Questions
  • Payroll Interface Overview
  • Payroll Interface Flow
  • Payroll-Specific Aspects
  • Common Implementation Aspects
  • Features by Country or Territory
  • Payroll Process Configuration Groups
  • Payroll Interface Extensible Flexfields and Lookups
  • Global Payroll Interface Extract
  • The Global Payroll Interface Process
  • Global Payroll Interface Template
  • Action Indicators for Payroll Interface
  • Delivered Flow Patterns and Reports
  • Payroll Interface Inbound Records
  • Key Points

Information Resources

  • Information Resources
  • Oracle Help Center
  • My Oracle Support
  • Oracle Cloud Customer Connect
  • Oracle University
  • Oracle Partner Community

Related Courses