HCM Extract Components in Oracle Fusion Cloud provide a powerful and flexible way to generate data files and reports. This section outlines how you can use extract components to specify the information the application should retrieve and report, as well as how the system processes, structures, and delivers that data.

The main building blocks of an HCM Extract are

• Extract Definitions 
• Data Groups 
• Extract Records 
• Attributes 

Extract Definition 

An extract definition represents the complete configuration of an extract. It includes data groups, records, attributes, criteria, advanced conditions, and output delivery options. 

An extract definition may include

• One or more data groups, depending on the logical entities to be extracted. 
• One or more records, based on the sets of information that need to be gathered. 
• One or more attributes, representing the specific data fields to be collected. 

Available Output Types in HCM Extracts 

HCM Extracts enable you to pull, process, store, report on, and distribute large sets of HCM data from the Oracle Fusion HCM system. 

The extract output can be generated in multiple formats, including

• CSV
• Delimited Data 
• EFT (Electronic File Transfer) 
• Excel (XLS/XLSX) 
• FO (Formatting Objects) 
• HTML / MHTML 
• PDF, PDF/A, PDF/X, PDF/Z 
• RTF 
• Text 
• XML 

Delivery Types in HCM Extracts 

Extracted data can be distributed using various delivery methods tailored to business needs. For example, payslips can be delivered to employees via email, payroll or benefits data can be transferred to third-party providers, and HR/talent information can be exchanged between Fusion HCM and legacy applications in coexistence scenarios. 

Pre-registrations are now open for our upcoming live online training batches in Oracle Fusion Payroll

The commonly used delivery types in HCM Extracts include

• Documents of Record 
• Email 
• FTP / Secure FTP 
• File System 
• HCM Connect 
• HTTP / HTTPS 
• None 
• Printer 
• WebDAV 

Data Groups for HCM Extract Components in Oracle Fusion Cloud

Extract Data Groups define a logical business area, for example, an employee, an assignment, or a benefit. These groups are used by the application to fetch the relevant database item groups. A single data group is marked as the root or primary group, serving as the initial point from which the extraction begins. 

Data Group Connections define the relationship between a child data group and its parent, creating a hierarchical structure that determines how data is linked and retrieved. 

To further refine the output, filtering rules can be applied to a data group using Extract Data Group Criteria. These criteria can be specified through conditions, expressions, or even fast formulas. 

Example: If Work Structures is set as the root data group, then the related entities, such as positions, departments, and jobs, are considered child data groups connected to it. 

Extract Records for HCM Extract Components in Oracle Fusion Cloud

Extract Records represent a structured set of related data within an extract. They define how the required fields are grouped and processed. For example, within the Employee data group, records might include Basic Details, Pay Details, Location Details, and Primary Contact. 

Each record is essentially a collection of attributes (fields) that can be organised in a specific sequence. If a data group contains multiple records, you can determine the order in which the application processes them. Additionally, you can specify the next data group to be processed, establishing the logical flow of extraction across related data groups. 

Attributes 

Attributes are the individual data fields within an extract record. They represent the most granular level of information in an HCM Extract. For example, attributes could include First Name, Last Name, or Date of Birth of a person. 

To illustrate: Consider a Worker Extract that includes a Worker Data Group. This data group can include two records, such as Basic Details and Assignment Details. 

• The Basic Details record might hold attributes such as Person Number and Person Name. 
• The Assignment Details record could include attributes such as Assignment Name and Assignment Number. 

Together, these attributes form the building blocks of the extract definition. 

Conclusion

HCM Extract Components in Oracle Fusion Cloud provide a structured way to organise, manage, and distribute critical HR data effectively. By understanding how components such as extract definitions, data groups, records, and attributes function together, organisations can simplify reporting, improve data accuracy, and enable smooth integrations with downstream systems. Choosing the right output formats and delivery methods adds further flexibility, making HCM Extracts a vital capability for modern HR operations.