Understanding Value sets in Oracle Cloud HCM

In Oracle HCM Cloud Application, a value set is used to include a list of values choices in reports and flex fields for collecting and choosing user input.

Purpose of creating value set in oracle fusion cloud application

A value set is a list of values with validation that will be used to restrict the user without entering the invalid data in the parameter and it can be used to assign valid values to a flex field segment to control the values that are used for business object attributes.

When we first define flex fields, we choose how many segments we want to use and in what order we want them to appear. We also choose how we want to validate each of our segments. The decisions we make affect how we define value sets and values.

A user enters a value for an attribute of a business object while using the application. The flex field validates the value against the set of valid values that we configured as a value set and assigned to the segment.

For example, we can define a required format, such as a five-digit number, or a list of valid values, such as green, red, and blue.

Value sets are used in two scenarios.

1. Concurrent Program parameters.

2. While defining Flex fields.

Types of value sets:

There are five types of values and they are listed below:

1. Format only

2. Independent

3. Dependent

4. Subset

5. Table

In order to create a new value set we have to login to application with the user with appropriate login credentials and choose ‘Manage value sets’ task under ‘Setup and maintenance’. Navigator > Setup and Maintenance > Manage value sets Creating a custom Value set, once we click on ‘Manage value sets’ a new page would allow us to search for existing value sets as well as allow creation of new ones.

Now we click on the (+) icon under the Search Results Section it would open up a new window.

  1. Independent Value set: –  Independent value set is used to validate input against a list that isn’t stored in an application table and is not dependent on a subset of another independent value set. Example: Independent Value set and Value Details:



2. Dependent Value Set: –                                                                                          A dependent value set is similar to an independent value set, except that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the FLEXFIELD structure. We can think of a dependent value set as a collection of little value sets, with one little set for each independent value in the corresponding independent value set. We must define our independent value set before we define the dependent value set that depends on it. For example, valid holidays depend on which country you are in. Example: Dependent Value Set and Values details.



3. Format-Only Value Set: –                                                                              Format only validation type enables end users to enter any values, as long as it meets your specified formatting rules. That is, the value must not exceed the maximum length you define for your value set, and it must meet any format requirements for that value set. Example: Format only Value set and Values details.


4. Subset Value set: –Subset Value set is used to limit the list of values based on a value set. However, instead of creating a new value set, we can re-use the existing independent value sets for values and choose the values that we want to create for the subset value set. Example: – Subset Value set and Value details



5. Table Value Set: –   

Table Value Set is used when the values you want to use are already maintained in an application table, such as table of vendor names. Specify the table column name that contains the valid value. We can optionally specify the description and ID columns, a WHERE clause to limit the values to use for your set, and an ORDER BY clause. Example: – Table Value Set


Use Cases of Value sets:

  • All types of Value sets can be used to validate the data for the flex field segments (DFF, EFF, KFF)
  • Only Table type Value sets can be used to get data from the application tables and then they can be used in fast formula when there are NO database items defined.
  • Only table type value sets are used to get data in HCM extracts when database items are not defined.

To get all details of lookups in the application, simply use the below query:

So, this is how Value sets in Oracle HCM will be used widely across HR and Payroll Modules. They are used in Flexfields, Payroll Flows, Fast formulas, HCM Exracts etc.

Leave a Reply

SOAIS - Worksoft Newsletter

To view on your browser, click here
Facebook Twitter LinkedIn
Dear Default Value,

Welcome to SOAIS Newsletter of September 2021!

Continuous Testing with Remote Execution
The speed of innovation continues to increase, driving rapid and relentless change for today’s ever-evolving IT landscapes, creating greater risk as IT and business teams scramble to ensure timely delivery. How can your organization keep pace? Test more, worry less. With Worksoft’s Connective Automation Platform, you can easily build and maintain automated tests, accelerating testing time without losing scope or volume. You can schedule and execute remote, continuous tests to intercept defects sooner and prioritize remediation - without sacrificing your nights and weekends. Explore how continuous test automation and remote execution can empower your organization.

Click here to connect with us to get more information on our services.

Skip Costly Rework with Dynamic Change Resiliency​

Change resiliency is imperative in ever-evolving IT environments. Our patented object action framework streamlines change management by assigning object definitions to your shared assets. The same object may be used in a thousand automation steps, but it can be easily updated by making one simple change to the model definition. The change automatically propagates to every single instance where that object may have been used without a single line of code or manual human involvement. For more change readiness you can also engage our Impact Analysis for SAP to predict how changes in SAP transports will affect your business processes. 

Please click here to watch the video to get a gist.

SOAIS Blog – Nuts and bolts of Certify Database Maintenance​

One of the key thing, which is often missed by the organizations, who have invested in using Worksoft Certify for automating their Business Process Validation initiatives, is implementing a Database Maintenance Plan. While the business and the test automation consultants get excited about the shiny new thing that they have got and start building the regression suite; planning and executing a database maintenance plan for most of the customers gets pushed down the priority list. However, since all the test assets in Certify are stored in a Database, a robust database maintenance plan is very important to maintain smooth operation of Certify with acceptable performance criteria. The customers usually start facing issues once they have built significant number of Certify processes which they have started executing on regular basis. Such executions add a lot of data to the tables storing results data and increase the overall size of the Certify database.

Please click here to read the complete blog.

Worksoft Blog – Process Intelligence: A Multi-Dimensional Approach

The ability to extract process knowledge has become easier through the years. Technology has evolved to the point where we can deploy capabilities that connect at multiple levels to extract different types of process insight. In the past, organizations were forced to spend enormous energy extracting data manually from different applications and databases. Then, they would have to use things like spreadsheets to transform the data and convert it into meaningful information. 

Please click here and read the complete blog.
Unit 9, Level 5, Navigator, ITPL,
Bangalore - 560 066.
Phone: +91 80 40071234
Suite 101, 1979, N Mill St,
Naperville, IL 60563
Phone 1-800-262-2427
Please click here to Unsubscribe / Unsubscribe Preferences

Leave us your info