Creating a Custom Independent Value Set in Oracle Fusion HCM Cloud Application

Fusion PayRoll

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

Search Courses

Details: Category: Fusion Applications; Published: 05 May 2017

Introduction

Before we start to demonstrate how to create a Custom Independent Value Set lets try to understand what is meant by a Value Set.

In Context of Oracle HCM Cloud Application (applicable for Oracle E-Business Suite too) a value set is a group of valid values that you assign to a flex-field segment ( to control the values that are stored for business object attributes.

An end 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 you configured as a value set and assigned to the segment.

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

In this article, we will create a very simple Independent Value Set (RECORDS_TO_SHOW which holds numeric values like 1,2,3,4,5 )

Navigation

In order to create a new value set we would need to login to application with a user having appropriate login credentials (Application Implementation Administrator works for me) and choose ‘Manage Value Sets’ Task under ‘Setup and Maintenance’

Navigator->Setup and Maintenance->Manage Value Sets

Creating a Custom Independent Value Set

Once we click on ‘Manage Value Sets’ a new page would open which would allow us to search for existing value sets as well as allow creation of new ones

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

Also once you select the Module (Global Human Resources for this example) , Validation Type (Independent in this case) and Valid Data Type (Number for this case) new field would appear as shown

Note: Attributes prefixed by asterisk denote mandatory fields.

We would populate the following details to create the Value Set

Attribute Name	Attribute Value
*Value Set Code	RECORDS_TO_SHOW
Description	Custom Independent Value Set of Number Type used to display the number of records to be shown
*Module	Global Human Resources
*Validation Type	Independent
*Value Data Type	Number
Security Enabled
Data Security Resource Name
Precision
Scale
Minimum Value	1
Maximum Value	9999

Once populated the UI would appear:

Next, we need to Click on ‘Save’ Option and the Value Set will be saved.

Creating Values for the Value Set

We need to click on the ‘Manage Values’ button to create new values

Once we click on ‘Manage Values’ it would bring up the below screen

We can now click on (+) icon to create new values

We would populate just few entries based on below info

*Value	Description	Enabled	Start Date	End Date	Sort Order
1	Numeral 1	Yes	01/01/1951
2	Numeral 2	Yes	01/01/1951
3	Numeral 3	Yes	01/01/1951
4	Numeral 4	Yes	01/01/1951
5	Numeral 5	Yes	01/01/1951

Once the above details are populated and saved in the application the screen would appear as shown below:

Now the Value Set Creation is complete

Verification

We would now try to validate whether the Value Set has been created. For this we would try to perform a search on the ‘Manage Value Sets’ screen using Value Set Name as RECORDS_TO_SHOW

Fetching Value Set Values Using Query

Now since we have a Value Set already created, some of us (techies specially) might even be interested to know whether we can fetch the Value Set values using a query.

So let-us see how to do that

We need to make use of two tables namely FND_FLEX_VALUE_SETS (holds value set property related details) and FND_FLEX_VALUES (holds actual values)

The SQL Query to be used is:

SQL Query

select ffv.flex_value

from fnd_flex_value_sets ffvs,

fnd_flex_values ffv

where ffv.flex_value_set_id = ffvs.flex_value_set_id

and ffvs.flex_value_set_name = 'RECORDS_TO_SHOW'

and ffv.enabled_flag = 'Y'

and TRUNC(SYSDATE) BETWEEN NVL(ffv.start_date_active,SYSDATE) and NVL(ffv.end_date_active,SYSDATE+1)

And once we use this in a Data Model we would get the data values as output

And with this we have come to the end of the article. Hope you guys had a good time reading this article.

Ashish Harbhajanka

Comments

+2 #1 bandarqq 228 2021-07-26 19:42

Heya i'm for the primary time here. I found
this board and I in finding It really useful
& it helped me out much. I hope to provide something back and aid others like you aided me.

<< Apr 2024 >>
Mon	Tue	Wed	Thu	Fri	Sat	Sun
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Search Courses