In this post, we will talk about value sets. We all know that in an Oracle Application, value set is used to include a list of value choices in reports and DFFs for collecting and choosing user input. To build a value set in Oracle Fusion, I will describe the complete steps
Purpose of Creating Value Set in Oracle Fusion Cloud Application
A value set is a group of valid values that are delegated to the flex-field section to control the values allocated for the attributes of business objects. A value for an element of a business object is entered by an end user when using the program.
The flex-field validates the value against the set of values that you configured and allocated to the segments as the value set.
To create a new value set we have to login to apply with the user with appropriate login credentials
Step1: Navigator >Setup and Maintenance > Manage Value Sets
Step2: Click on ‘+’ sign to Create Value Set
Important Value Set table in Oracle Fusion Cloud Application
fnd_flex_value_sets: This table stores value sets used by key and descriptive flexfields
fnd_flex_values: This table stores valid values for flexfield segments.
Query to get Value Set Details in Oracle Fusion Cloud Application
select ffv.*
from fnd_flex_value_sets ffvs,
fnd_flex_values ffv
where ffv.flex_value_set_id = ffvs.flex_value_set_id
and ffv.enabled_flag = 'Y'
and ffvs.flex_value_set_name = 'XXValueSet_Name'