How to Find the HCM Group of an Employee in Oracle Fusion HCM

HCM Groups in Oracle Fusion HCM are configurable groups used to identify a defined population of workers, people, or assignments for a specific business purpose. They help functional and technical teams apply logic consistently across Oracle Fusion HCM processes without repeatedly rebuilding the same population criteria.

For Oracle Fusion HCM teams, HCM Groups matter because they reduce manual effort, improve consistency, and make employee population logic easier to manage. They’re especially useful when the same group of employees needs to be referenced across configuration, reporting, integrations, or operational processes.

This comprehensive guide walks you through understanding, configuring, and querying HCM Groups in Oracle Fusion HCM.

What Are HCM Groups in Oracle Fusion HCM?

An HCM Group is a named group that represents a set of people or workers in Oracle Fusion HCM. The group can be created for a business process, reporting requirement, eligibility scenario, integration filter, or administrative purpose.

Quick definition:
An HCM Group in Oracle Fusion is a reusable grouping of people or workers, typically created through configuration rules or manual membership, and used to support HCM processing, reporting, eligibility, or downstream business logic.

Membership Options

Depending on how the group is configured and used in your environment, membership may be based on:

• Manual inclusion - Specific people manually selected
• Criteria-based inclusion - Using worker or assignment attributes
• Exclusions - Specific employees removed from the base criteria
• Effective-dated conditions - Time-based membership rules
• Hybrid approach - Combination of manual and rule-based logic

Common Attributes Used to Define HCM Groups

HCM Groups typically use standard employee or assignment attributes for membership criteria:

Attribute Type	Example Grouping Logic
Legal Employer	Employees in “Vision Operations”
Business Unit	Workers assigned to a specific business unit
Department	Employees in Finance, HR, or Technology
Location	Workers based in London, Dubai, New York, or Singapore
Job	Employees assigned to a particular job
Grade	Employees in selected grades
Assignment Status	Active employees only
Worker Type	Employees, contingent workers, or both
Person or Assignment	Specific people or assignments selected manually

The exact configuration options available depend on your Oracle Fusion HCM modules, security roles, and environment’s quarterly update level.

Where Are HCM Groups Used in Oracle Fusion HCM?

HCM Groups appear throughout Oracle Fusion HCM wherever a reusable population of workers or people is needed:

1. Eligibility and Workforce Population Logic

HCM Groups may support population selection for processes that need to include or exclude specific workers:

• Include only employees in a particular legal employer
• Exclude employees from a pilot group
• Target employees in selected departments or locations
• Define a population for a specific HR process

2. Reporting and Analytics

Reporting teams use HCM Groups to filter data for dashboards, BI Publisher reports, OTBI analyses, and reconciliation reports:

• Headcount report for a specific operating group
• Audit report for employees in a configured population
• Exception report for employees missing data within a target group

3. HCM Extracts and Integrations

Technical teams use HCM Group membership logic to control which employees flow to downstream systems:

• Include employees in a pilot deployment for third-party benefits platforms
• Filter outbound employee data by business unit or legal employer
• Send only employees in selected countries to local payroll providers

4. Fast Formulas and Derived Logic

Where supported by the relevant process, HCM Group membership can be referenced in logic through database items, value sets, user-defined tables, or extracted membership data.

Note: Formula capabilities vary by formula type and module. Always validate whether direct HCM Group access is supported for your specific formula context.

5. Security and Administrative Processes

HCM Groups sometimes support administrative processes, but they are NOT the same as role-based security.

Important distinction:

• Use HCM Groups for population logic
• Use security profiles, data roles, and roles for access control and responsibility assignment

HCM Groups Configuration in Oracle Fusion

Navigation Path

The navigation path can vary based on role, module, and environment. A common starting point is:

Setup and Maintenance → Search for “Manage HCM Groups”

In some environments, the task may be available under HCM setup areas such as:

Setup and Maintenance → Workforce Structures → Manage HCM Groups

If You Cannot Find the Task

• Confirm that your role includes the required HCM setup access
• Search directly for Manage HCM Groups in Setup and Maintenance
• Check whether the feature is enabled in your implementation
• Ask your security administrator to confirm access to the relevant setup task

How to Configure HCM Groups in Oracle Fusion (Step-by-Step)

The exact page layout may vary by release and enabled modules, but the configuration process generally follows this pattern.

Step 1: Create the HCM Group

Open Manage HCM Groups and create a new group.

Typical fields to populate:

Field	Purpose	Example
Name	Business-friendly group name	”UK Active Employees”
Code	Unique identifier for references	HCM_GRP_UK_ACTIVE_EMP
Description	Explains purpose and intended use	”All active employees in UK locations”
Start Date	Date from which the group is valid	01-JAN-2026
End Date	Optional end date for temporary groups	NULL (for ongoing groups)
Status	Indicates if group is active or inactive	Active

Step 2: Define Inclusion Criteria

Inclusion criteria determine who belongs to the group.

Real examples:

Business Requirement	Possible Inclusion Criteria
Active employees in the UK	Worker type = Employee, Assignment status = Active, Country = UK
Finance employees in London	Department = Finance, Location = London
Employees in a legal employer	Legal employer = selected legal entity
Workers in selected grades	Grade in selected grade list
Pilot population	Specific people manually added

Step 3: Define Exclusion Criteria (If Needed)

Exclusions are useful when main criteria are broad but some people shouldn’t be included:

• Exclude terminated workers
• Exclude contingent workers
• Exclude specific departments
• Exclude named individuals from pilot groups
• Exclude workers in specific locations

Best practice: Keep exclusions as simple as possible. Complex inclusion and exclusion logic makes troubleshooting harder.

Step 4: Add Manual Members (If Supported)

Some HCM Group configurations allow manual member selection. This is useful for:

• Pilot groups
• Temporary project groups
• Exception populations
• Small controlled groups

Warning: Manual membership requires governance because it can become outdated if employees transfer, terminate, or change assignments.

Step 5: Evaluate or Refresh Group Membership

Depending on configuration and process, HCM Group membership may need to be evaluated or refreshed by a scheduled process.

If an employee should be included but isn’t, check:

• Has the group membership evaluation process run?
• Is the employee’s assignment effective as of the evaluation date?
• Are criteria based on person-level or assignment-level attributes?
• Does the employee have multiple assignments?
• Are exclusion criteria removing the employee?
• Is the group active as of the relevant date?

Step 6: Validate Membership

Before using an HCM Group in a process or extract, validate a sample of employees.

Recommended validation checks:

• ✅ Employees who should be included are present
• ✅ Employees who should be excluded are not present
• ✅ Future-dated hires are handled correctly
• ✅ Terminated employees are handled correctly
• ✅ Employees with multiple assignments are handled correctly
• ✅ The group returns the expected population as of the correct effective date

Sample SQL Queries to Find the HCM Group of an Employee

Query 1: Find All HCM Groups for an Employee by Person Number

SELECT PAPF.PERSON_NUMBER AS EMPLOYEE_NUMBER
    ,PPNF.LAST_NAME
    ,PPNF.FIRST_NAME
    ,GRP.GROUP_NAME AS HCM_GROUP_NAME
    ,MEM.EFFECTIVE_START_DATE AS MEMBERSHIP_START_DATE
    ,MEM.EFFECTIVE_END_DATE AS MEMBERSHIP_END_DATE

FROM HWM_GRP_MEMBERS_F MEM
    ,HWM_GRPS_TL GRP
    ,PER_ALL_PEOPLE_F PAPF
    ,PER_PERSON_NAMES_F PPNF

WHERE 1=1
    AND GRP.GRP_ID = MEM.GRP_ID
    AND GRP.LANGUAGE = USERENV('LANG')
    AND PAPF.PERSON_ID = MEM.MEMBER_ID
    AND PAPF.PERSON_ID = PPNF.PERSON_ID
    AND PPNF.NAME_TYPE = 'GLOBAL'
    AND SYSDATE BETWEEN MEM.EFFECTIVE_START_DATE AND MEM.EFFECTIVE_END_DATE
    AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
    AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
    AND PAPF.PERSON_NUMBER = '1234' /* Replace with your person number */

ORDER BY PAPF.PERSON_NUMBER;

What this query does:

• Returns all HCM Groups a specific employee belongs to
• Uses effective date filtering to show current memberships only
• Joins person, name, group, and membership tables
• Replace ‘1234’ with the actual person number to query

Query 2: Find Employees in a Specific HCM Group

SELECT PAPF.PERSON_NUMBER AS EMPLOYEE_NUMBER
    ,PPNF.LAST_NAME
    ,PPNF.FIRST_NAME
    ,GRP.GROUP_NAME AS HCM_GROUP_NAME
    ,MEM.EFFECTIVE_START_DATE AS MEMBERSHIP_START_DATE
    ,MEM.EFFECTIVE_END_DATE AS MEMBERSHIP_END_DATE

FROM HWM_GRP_MEMBERS_F MEM
    ,HWM_GRPS_TL GRP
    ,PER_ALL_PEOPLE_F PAPF
    ,PER_PERSON_NAMES_F PPNF

WHERE 1=1
    AND GRP.GRP_ID = MEM.GRP_ID
    AND GRP.LANGUAGE = USERENV('LANG')
    AND PAPF.PERSON_ID = MEM.MEMBER_ID
    AND PAPF.PERSON_ID = PPNF.PERSON_ID
    AND PPNF.NAME_TYPE = 'GLOBAL'
    AND SYSDATE BETWEEN MEM.EFFECTIVE_START_DATE AND MEM.EFFECTIVE_END_DATE
    AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
    AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
    AND GRP.GROUP_NAME = 'HCM_GRP_GCS_CORPORATION' /* Replace with your HCM Group name */

ORDER BY GRP.GROUP_NAME, PAPF.PERSON_NUMBER;

What this query does:

• Returns all employees in a specific HCM Group
• Uses effective date filtering to show current members only
• Joins person, name, group, and membership tables
• Replace ‘HCM_GRP_GCS_CORPORATION’ with the actual group name

Query 3: All Employees Along with Assigned HCM Groups

SELECT PAPF.PERSON_NUMBER AS EMPLOYEE_NUMBER
    ,PPNF.LAST_NAME
    ,PPNF.FIRST_NAME
    ,GRP.GROUP_NAME AS HCM_GROUP_NAME
    ,MEM.EFFECTIVE_START_DATE AS MEMBERSHIP_START_DATE
    ,MEM.EFFECTIVE_END_DATE AS MEMBERSHIP_END_DATE

FROM HWM_GRP_MEMBERS_F MEM
    ,HWM_GRPS_TL GRP
    ,PER_ALL_PEOPLE_F PAPF
    ,PER_PERSON_NAMES_F PPNF

WHERE 1=1
    AND GRP.GRP_ID = MEM.GRP_ID
    AND GRP.LANGUAGE = USERENV('LANG')
    AND PAPF.PERSON_ID = MEM.MEMBER_ID
    AND PAPF.PERSON_ID = PPNF.PERSON_ID
    AND PPNF.NAME_TYPE = 'GLOBAL'
    AND SYSDATE BETWEEN MEM.EFFECTIVE_START_DATE AND MEM.EFFECTIVE_END_DATE
    AND SYSDATE BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
    AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE

ORDER BY GRP.GROUP_NAME, PAPF.PERSON_NUMBER;

What this query does:

• Returns a comprehensive report of all employees and their HCM Group memberships
• Shows all active memberships as of today
• Useful for audits, reporting, and validation
• No parameters needed—runs for all employees and groups

FAQ: HCM Groups in Oracle Fusion HCM

What is an HCM Group in Oracle Fusion HCM?

An HCM Group is a reusable group of people, workers, or assignments used to define an employee population for configuration, reporting, extracts, eligibility, or downstream processing.

Where do I configure HCM Groups in Oracle Fusion?

A common navigation path is Setup and Maintenance → Search for “Manage HCM Groups.” In some environments, the task may be available under Workforce Structures or another HCM setup area. Access depends on your security roles and enabled features.

How do I find the HCM Group of an employee?

You can find an employee’s HCM Group by:

• Reviewing group membership in the Manage HCM Groups page
• Using approved reporting tools and dashboards
• Running a SQL query against the relevant person, assignment, group, and membership tables

Can I use SQL to find an employee’s HCM Group?

Yes, if your role and reporting access permit it. A typical HCM Group query joins person data, person names, group membership, and group header tables. Validate exact table/view names in your Oracle Fusion environment before using any query.

Why is an employee missing from an HCM Group?

Common reasons include:

• Incorrect effective date
• Assignment mismatch
• Inactive assignment
• Exclusion criteria removing the employee
• Manual membership not maintained
• Group membership not refreshed
• Multiple assignments not handled correctly

Are HCM Groups the same as security roles?

No. HCM Groups define employee populations for business logic. Security roles, data roles, and security profiles control access permissions. An HCM Group should never be used as a security control mechanism.

Are HCM Groups the same as eligibility profiles?

No. Eligibility profiles define eligibility rules for specific HCM processes (benefits, compensation, etc.). HCM Groups define reusable worker populations. Both may be used together in some designs, but they serve different purposes.

Should I use manual or criteria-based HCM Groups?

• Use criteria-based groups for large or frequently changing populations
• Use manual groups for small, temporary, or exception-based populations
• Govern manual groups carefully because they can become outdated if employees transfer, terminate, or change assignments

Why does my HCM Group query return duplicate employees?

Duplicates usually come from:

• Multiple assignments per employee
• Multiple effective-dated rows
• Multiple name records
• Missing effective-date filters in the query

Solution: Add effective-date conditions and confirm whether the group is person-level or assignment-level.

Can HCM Groups be used in HCM Extracts?

They can be used in some extract designs to define or filter the employee population, depending on how the extract is configured. Validate the extract type, record criteria, and available database items or parameters in your environment.

Key Takeaways

• ✅ Oracle Fusion HCM Groups define reusable employee populations for configuration, reporting, extracts, eligibility, and downstream processes
• ✅ Configuration usually starts from Manage HCM Groups in Setup and Maintenance, subject to role access and enabled features
• ✅ Effective dates matter. Always validate membership as of a specific date
• ✅ Person-level and assignment-level logic are different. Multiple assignments can change membership results
• ✅ SQL queries are environment-specific patterns. Always validate table and view names in your environment
• ✅ HCM Groups are not security roles. Use security profiles, data roles, and roles for access control
• ✅ Governance is important. Document ownership, purpose, usage, and review frequency for each group

💡 Master HCM Groups in Oracle Fusion

Learning to effectively configure and use HCM Groups enables you to:

• Build reusable employee population logic
• Simplify configuration and reporting
• Improve consistency across processes
• Support integrations and extracts
• Reduce manual effort and governance overhead

🚀 Continue Your Learning Journey

• Subscribe to GrowCloudSkills for more Oracle Fusion configuration guides and SQL queries
• Follow us on LinkedIn for daily Oracle Fusion tips, implementation insights, and expert advice
• Watch our video tutorials on YouTube for visual step-by-step walkthroughs

About GrowCloudSkills

GrowCloudSkills is your trusted source for mastering Oracle Fusion Cloud Applications through:

• ✅ Practical configuration guides for everyday scenarios
• ✅ Real-world implementation examples from actual projects
• ✅ Complete step-by-step instructions for complex topics
• ✅ Production-ready SQL queries you can use immediately
• ✅ Industry best practices based on years of consulting experience
• ✅ Supportive community of Oracle Fusion professionals

Whether you’re a functional consultant implementing HCM Groups, a technical developer querying membership data, or an administrator managing employee populations, we’re here to help you succeed.

Connect With Us

• 📧 Email
• 🔗 LinkedIn
• 📺 YouTube
• 🐦 Twitter
• 💻 Topmate

Have questions about HCM Groups or other Oracle Fusion topics? Drop a comment below or reach out on LinkedIn. We’d love to help you succeed in your Oracle Fusion journey!

Happy configuring and master HCM Groups in Oracle Fusion! 🚀