HCM Extract Components in Oracle Fusion HCM- How they work explained with example?

HCM Extract Components in Oracle Fusion HCM with example

 What is HCM Extract –

HCM Extract is a tool that generates the reports, exports a large volume of data into output files.Also It retrieves data in bulk from Oracle HCM Cloud. An Extract lets you choose the data and gathers the data from the database then processes and archives. And after this archived data can be converted to your choice of format and deliver it to recipients. Likewise HCM extract also works on predefined User Entity and Database Items.
Oracle HCM Extract Steps

 HCM Extract Components –

The different components of HCM Extracts are: Extract Definition, Data Groups,  Extract Records and Attributes 

1. Extract Definition :  

An extract definition includes complete setup of an extract, which consist of: 

Extract parameters, 

Extract data groups, 



Filter criteria and,

Delivery options.

Extract definition consists of: 

  • One or more data groups based on the number of logical entities you want to extract, 

    Data Group Example of Employee Payroll Balance Report
    Data Group Example of Employee Payroll Balance Report
  • One or more records based on the number of data groups you want to collect 

    HCM Extract Records example
    HCM Extract Record Example
  • Lastly, one or more attributes based on how many individual fields of data you want to collect.

    Attribute fields of record


2. Data Groups:

Extract data group represents a logical group or business area such as Person, Assignment, Employee. Hence the application uses this information to retrieve data from database item groups. Further we define one data group as the root data group and this data group is the starting point of data extract.

Because data group connections capture the association details between the current data group to the root data group. And also we can define set filtering conditions to perform.
for example – Department and Employee data groups have the data group connection link through department_id.

So in this case we can also say that the data group is associated with the User Entity which provides links to database items to retrieve .
some frequently used user entities are:
Person –
 PER_EXT_SEC_PERSON_UE (retrieves all persons across the enterprise and all person related attributes)

Employees –
PER_EXT_PAY_EMPLOYEES_UE (returns employee, assignments and payroll details as on effective date )

 3. Records :

Extract Records represent a grouping of related data or a physical collection of all fields required within the extract. Also for instance  department data group can have Department Details, Department summary. Likewise records can also define a collection of attributes that you can organize in a required sequence.
Therefore, if a data group has 4 records, then you can specify the sequence in which the application processes the records.

Example of HCM Extract Definition - Data groups-Records -Attributes
 Example of HCM Extract Definition – Data groups-Records -Attributes

4. Attributes :

An attribute is the lowest attribute level of an HCM extract which represents a piece of information. Also the Attribute is an individual field inside extract record.
for example – employee first name, employee last name, employee date of birth.

**Click here to know HCM Extract Type in details **

 Output types of HCM Extract :

We generate output in the following format:
    • Text 
    • CSV
    • XML
    • Excel
    • HTML
    • RTF
    • PDF
  • In fact each of these output types requires the BI Publisher Template.

 Delivery Types  :

The type of delivery you select determines the destination of extract. Some delivery types requires additional details. For example if you select delivery type as FTP, then you must provide the server path, username and password.
List of Delivery types

  1) Emails –  Emails the file

  2) FTPSend the file to an external file system

  3) FaxSend the output to a Fax machine

  4) File System –  Also can be used with on-premise versions of Human Capital Management

  5) WebCenter ContentUsed to create extract with encrypted or non-encrypted data and transmit them to Oracle WebCenter content

  6) Inbound Interface Used to associate an eText layout to format the data in HDL file and deliver the output as a file to the Oracle WebCenter content server

  7) Document of Record –  Stores the output in the database so the employee can access it from the document of record pages. for example – Payslip

  8) Printer – Send the data to printer to print

  9) None – This is the default delivery type and in short None delivery type will store a copy of output XML that can be accessed via payroll checklist. Because this type is intended for testing purposes and not intended for production-ready exports.

 This is a brief description of HCM Extract Components in Oracle Fusion HCM and how they work together with example.

In case if you want to learn more about HCM Extract, you can go through – What are the Oracle Fusion HCM Extract Types and its purpose ?




8 Replies to “HCM Extract Components in Oracle Fusion HCM- How they work explained with example?

Leave a Reply

Your email address will not be published. Required fields are marked *