Oracle Fusion HCM Extracts : Chapter 3: Creating Your First HCM Extract

 

Chapter 3: Creating Your First HCM Extract

🔷 Objective

This chapter walks you through the process of creating a basic HCM Extract. By the end, you'll know how to design, schedule, and view output files.

🔷 Step-by-Step Guide

Step 1: Navigate to Extract Definitions

• Oracle Cloud → Navigator → My Client Groups → Data Exchange → HCM Extract Definitions

Step 2: Create a New Extract

• Click on "Create"

• Enter: Name, Type (Archive), and Effective Date

Step 3: Define Data Group

• Add a primary data group (e.g., Worker)

• Source: Database Item Group

• Set context: e.g., Assignment ID

Step 4: Add Records and Attributes

• Under the data group, create a record (e.g., PersonalDetails)

• Add attributes such as Person Number, Name, Email

Step 5: Configure Delivery Options

• Format: XML or CSV

• Method: Email or UCM

Step 6: Generate and View Output

• Submit the Extract

• Monitor status in the View Results tab

• Download and verify output file

📌 Sample Use Case: Employee Contact Info

• Data Group: Worker

• Record: ContactDetails

• Attributes: Name, Phone, Relationship

• Delivery: CSV via Email

🧠 Tips:

• Use meaningful names for clarity

• Validate output for each attribute

• Schedule runs during low-traffic hours

🏁 Conclusion

Creating your first extract introduces you to the basics of design and output generation. You’ll expand on this foundation in upcoming chapters with logic and performance enhancements.

🔹 Next Steps

• Previous Chapter:  Chapter 2: HCM Extract Architecture and Components

• Next Chapter: Chapter 4: Using Fast Formulas in Extracts