Introduction
In Oracle Fusion HCM, controlling the values that users can enter into application fields is essential for maintaining data integrity and standardizing business processes. One of the most powerful tools used for this purpose is Value Sets in Oracle Fusion HCM.
Value sets define a list of valid values that can be used in fields such as Descriptive Flexfields (DFF), Extensible Flexfields (EFF), lookups, and Fast Formulas. They ensure that users enter only predefined or validated data during transactions.
In real Oracle Fusion implementations, consultants frequently use value sets to control values like:
Employee grades
Job categories
Department codes
Allowance types
Custom HR attributes
For example, during an HCM implementation for a multinational company, a consultant may create a value set to restrict employee project codes or custom HR attributes so that HR users select only approved values.
In this article, we will explore Value Sets in Oracle Fusion HCM, including their concept, types, configuration steps, real-world use cases, and best practices used by Oracle consultants.
What are Value Sets in Oracle Fusion HCM?
A Value Set defines a collection of valid values that can be assigned to fields within Oracle Fusion applications.
It acts as a validation mechanism to control the type of data users can enter.
Value sets are widely used with:
| Oracle Feature | Usage |
|---|---|
| Descriptive Flexfields (DFF) | Add custom fields with controlled values |
| Extensible Flexfields (EFF) | Store additional structured information |
| Fast Formulas | Validate values used in calculations |
| Lookups | Maintain predefined values |
| Application fields | Restrict input data |
Instead of allowing free text entry, value sets enforce data consistency across the application.
Example
An HR department may want to define valid Employee Skill Levels:
| Skill Level Code | Description |
|---|---|
| JUN | Junior |
| MID | Mid-Level |
| SEN | Senior |
| EXP | Expert |
By creating a value set, users can only select from these options instead of entering random values.
Key Features of Value Sets
Value sets in Oracle Fusion HCM provide several powerful capabilities used by implementation consultants.
1. Data Validation
Ensures users enter only predefined or validated values.
Example:
Restrict Employee Status to:
Active
On Leave
Terminated
2. Reusability
A value set can be used across multiple fields and flexfields.
Example:
A Department Value Set can be reused in:
Employee DFF
Payroll attributes
Benefits eligibility fields
3. Dynamic Value Sources
Values can come from:
Static lists
Database queries
Independent values
Dependent values
4. Data Type Control
Value sets support multiple data types:
| Data Type | Example |
|---|---|
| Character | Department Code |
| Number | Allowance Amount |
| Date | Joining Date |
| DateTime | Timestamp fields |
5. Security and Data Integrity
Value sets help maintain clean master data across HR modules.
Types of Value Sets in Oracle Fusion
Oracle Fusion supports several types of value sets used in different business scenarios.
| Value Set Type | Description | Example |
|---|---|---|
| Independent | Contains a predefined list of values | Employee Skill Level |
| Dependent | Values depend on another value set | City based on Country |
| Table | Values retrieved from database tables | Department list |
| Translatable Independent | Supports multilingual values | Global organizations |
| Format Only | Validates format without fixed values | Employee ID pattern |
Independent Value Set Example
An independent value set might contain:
| Code | Meaning |
|---|---|
| FT | Full-Time |
| PT | Part-Time |
| CT | Contract |
Dependent Value Set Example
| Country | City |
|---|---|
| USA | New York |
| USA | Chicago |
| India | Hyderabad |
| India | Bangalore |
The City value set depends on Country selection.
Real-World Business Use Cases
Use Case 1 – Employee Certification Tracking
A company wants to track professional certifications of employees.
Possible certifications:
PMP
AWS Architect
Oracle Cloud Professional
CISSP
A value set ensures HR selects only approved certifications.
Use Case 2 – Employee Equipment Allocation
IT departments track equipment issued to employees.
Example values:
Laptop
Monitor
Mobile Phone
VPN Token
This can be controlled using a value set in an employee DFF.
Use Case 3 – Allowance Types in Payroll
Payroll departments define standard allowances:
Housing Allowance
Travel Allowance
Meal Allowance
Using a value set prevents incorrect entries during payroll configuration.
Configuration Overview
Before creating a value set, consultants should consider the following setup decisions.
| Configuration Element | Description |
|---|---|
| Value Set Type | Independent / Dependent / Table |
| Data Type | Character, Number, Date |
| Maximum Length | Field size |
| Validation Type | List or table |
| Security Rules | Access control |
Value sets are created using Setup and Maintenance.
Step-by-Step Configuration in Oracle Fusion
Step 1 – Navigate to Manage Value Sets
Navigation path:
Navigator → Setup and Maintenance
Search for the task:
Manage Value Sets
Step 2 – Create a New Value Set
Click Create.
Enter the following details.
| Field | Example Value |
|---|---|
| Value Set Code | EMP_CERTIFICATIONS |
| Name | Employee Certifications |
| Description | Certifications held by employees |
| Data Type | Character |
| Maximum Length | 30 |
| Validation Type | Independent |
Step 3 – Save the Value Set
Click Save and Close.
The system creates the value set structure.
Step 4 – Define Values
Navigate to:
Manage Values
Add records.
| Value | Meaning |
|---|---|
| PMP | Project Management Professional |
| AWS | AWS Architect |
| OCI | Oracle Cloud Professional |
| CISSP | Certified Information Systems Security Professional |
Save the configuration.
Using Value Sets in Descriptive Flexfields (DFF)
Value sets are commonly used in Descriptive Flexfields.
Example:
Add Certification Type to Employee Assignment.
Navigation
Navigator → Setup and Maintenance → Manage Descriptive Flexfields
Search:
PER_ASG_DF
Add a segment:
| Field | Value |
|---|---|
| Segment Name | Certification |
| Value Set | EMP_CERTIFICATIONS |
| Data Type | Character |
Save and deploy the flexfield.
Testing the Setup
After configuring the value set and attaching it to a flexfield, testing is required.
Example Test Scenario
Add certification to an employee.
Navigation:
Navigator → My Client Groups → Person Management
Search employee.
Edit assignment.
Open Additional Information (DFF).
Select Certification.
Expected values:
PMP
AWS
OCI
CISSP
Users should only see predefined values.
Common Implementation Challenges
1. Incorrect Validation Type
If validation type is wrong, values may not appear.
Example:
Using table validation without correct query.
2. Flexfield Not Deployed
After adding value sets to DFF, deployment is required.
Navigation:
Deploy Flexfield
3. Incorrect Data Type
Mismatch between value set and flexfield segment.
Example:
Number value set used with character field.
4. Security Issues
Users may not see values if data security roles restrict access.
Best Practices for Value Sets
Oracle consultants follow several best practices.
Use Clear Naming Conventions
Example:
VS_DEPARTMENT_CODES
VS_ALLOWANCE_TYPES
Avoid Duplicate Value Sets
Reuse existing value sets instead of creating new ones.
Use Table Value Sets for Dynamic Data
If values frequently change, use table validation.
Example:
Department list from PER_DEPARTMENTS table.
Document Value Sets
Maintain documentation:
| Attribute | Description |
|---|---|
| Value Set Name | Certification List |
| Used In | Employee DFF |
| Owner | HR Department |
Test with Real Transactions
Always test using:
Employee creation
Assignment update
Payroll transactions
Real Consultant Implementation Scenario
During a global HR transformation project, a company wanted to track employee visa types.
Possible values:
H1B
L1
Work Permit
Permanent Resident
A consultant created:
Value set:
Attached it to:
Benefits:
HR users could select only valid visa types
Standardized reporting
Easy compliance audits
Summary
Value Sets in Oracle Fusion HCM play a crucial role in maintaining data consistency, validation, and standardization across HR processes.
They are widely used in:
Descriptive Flexfields
Extensible Flexfields
Payroll configurations
Fast Formulas
Custom attributes
Key takeaways:
Value sets control valid data entries
Multiple validation types are available
They are reusable across Oracle modules
Proper configuration ensures accurate data entry
Consultants frequently use them during implementations
Understanding how to configure and use value sets is essential for Oracle Fusion HCM consultants and administrators who want to build scalable and maintainable HR solutions.
For deeper technical details, refer to the official Oracle documentation:
https://docs.oracle.com/en/cloud/saas/index.html
FAQs
1. What is the purpose of Value Sets in Oracle Fusion HCM?
Value sets define valid values for application fields, ensuring users enter standardized and validated data.
2. What are the types of Value Sets in Oracle Fusion?
Common types include:
Independent
Dependent
Table
Translatable Independent
Format Only
3. Where are Value Sets commonly used?
Value sets are commonly used in:
Descriptive Flexfields
Extensible Flexfields
Fast Formulas
Application validations