Oracle Fusion HCM Extracts : Chapter 2: HCM Extract Architecture and Components

 

Chapter 2: HCM Extract Architecture and Components

🔷 Overview of HCM Extracts Architecture

Oracle HCM Extracts are built using a framework that allows you to define data models graphically and extract large volumes of HR-related data from Oracle Cloud.

🔷 Key Components of HCM Extracts

1. Extract Definition

   • The master object that holds all configurations of an extract.

   • Contains all the data groups, records, attributes, and delivery options.

2. Data Group

   • Logical grouping of related data (e.g., Employee, Payroll, Compensation).

   • Defines the source of data (database table or view).

3. Record

   • Defines a single row of data within a data group.

   • A data group may contain one or more records.

4. Attribute

   • Field within a record that holds actual data.

   • Can be static or derived using Fast Formula.

5. Delivery Option

   • Specifies the output format and delivery method.

   • Formats: XML, CSV, PDF

   • Methods: Email, SFTP, Oracle UCM

6. Output Types

   • Preview

   • Final

   • Both can be generated depending on the business requirement.

🔄 Flow of Data in HCM Extracts

Source Tables → Data Group → Records → Attributes → Output File → Delivery

📌 Example:

Scenario: Extracting employee contact info for audit.

• Data Group: Employee

• Records: Contact

• Attributes: Name, Phone Number, Relationship

• Output: CSV file sent via Email

🏁 Conclusion

Understanding these components is essential to efficiently building and troubleshooting HCM Extracts. The next chapter will guide you through building your first extract.

🔹 Next Steps

• Previous Chapter:  Chapter 1: Introduction to Oracle Fusion HCM and Extracts

• Next Chapter: Chapter 3: Creating Your First HCM Extract