1.Overview
|
Value-set
is a group of values. It can also be thought of as a container of
values. The values could be of any data type (Char, Number etc.) A value
set is used in Oracle Applications
to restrict the values entered by a user. For example, when submitting a
concurrent program, we would like user to enter only valid values in
the parameter. This is achieved by associating a value set to a
concurrent program parameter.
A Value Set is characterized by value set name and validation. There are two kinds of validations, format validation and Value validation.
In the format validation, we decide the data type, length and range of
the values. In the value validation, we define the valid values.
The
valid values could be defined explicitly, or could come implicitly from
different source (like table, another value-set etc.)
2. Uses
Value-set is an important component of Oracle Applications used in defining Concurrent program parameters, Key Flex field and descriptive flex field set of values.
Some of the scenarios where value-set is used are given below:
- In a concurrent program, we may want users to enter only number between 1 and 100 for a particular parameter.
- In a concurrent program, we may want users to enter only Yes or No for a particular parameter.
- Suppose a concurrent program has two parameters. First parameter is department and second parameter is employee name. On selecting a particular department, we want to show only those employee names which belongs to the selected department.
- In a descriptive flex field enabled on a particular screen, we want to show only a designated list of values for selection by a user.
- In case of accounting reports, we may want users to enter a range of key flex field values (concatenated segments).
3. Steps To Create Value Set:
Navigation:
Value Set Form:
The various fields are explained below:
Value Set Name : Any user defined unique name
Description : Description of the value set
List type : Three choices are available for this field:
· List of Values
· Long List of Values
· Pop-List
Security type : Three choices are available for this field:
- No Security
- Hierarchical Security
- Non-Hierarchical Security
Format Validation
Format Type
Possible values for this field are:
Char
Date
Date Time
Number
Standard Date
Standard Date Time
Time
Maximum Size : Maximum size of the value
Precision : Applicable when format type is number
Numbers Only : When this is checked, only numbers are allowed
Upper Case Only : This is applicable when Format type is Char
Right Justify and Zero-Fill Numbers: Applicable only for Numbers
Min Value : Min Value allowed
Max Value : Max Value Allowed
Value Validation
Possible values of the value validations are as follows:
None You
use a None type value set when you want to allow users to enter any
value so long as that value meets the value set 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.
Independent:
When this is chosen, the individual values are defined using the navigation shown below
Values Screen Navigation:
Values Find Screen:
Dependent:
Same
like Independent Value Set, except the List of Values shown to you will
depend on which the Independent value you have selected in the Prior
Segment. Must define your independent value set before you define the
dependent value set that depends on it. Must create at least one
dependent value for each independent value
In the above Value set screen, if you choose type as “DEPENDENT” and clicked the “Edit Information” Button, we get the below screen
Table:
Ø The list of value is created based on database tables.
Ø Allows to write simple queries, joins, order by etc
Ø The
value, meaning and ID can be used to display a value, description to
the value but return ID to the calling program or screen.
Ø Additional columns can also be displayed.
Ø Can also create dependent values to filter LOV data based on parameter value selected earlier. This can be done using :$FLEX:.value_set_name in the where clause.
In the above Value set screen, if you choose type as “TABLE” and clicked the “Edit Information” Button, we get the below screen
Special & Pair Value Sets:
Pair validation value set allows to select a range of concatenated Flex field segments as parameters
to the report. The special value set is used to perform special
validation. This is used to enter the entire key flex field segment in
the single parameter of the report/calling entity.
Special and pair value sets provide a mechanism to allow a "flexfield-within-a-flexfield". These value sets are primarily used for Standard Request Submission parameters. You do not generally use these value sets for normal flex field segments.
Special
and Pair value sets use special validation routines you define. For
example, you can define validation routines to provide another flexfield
as a value set for a single segment or to provide a range flex field as
a value set for a pair of segments.
In the above Value set screen, if you choose type as “SPECIAL” and clicked the “Edit Information” Button, we get the below screen
4. FNDLOAD & Value SETS:
FNDLOAD can be used to migrate the value set information from one instance to another and below is the code sample
<-- Command to be executed -->
FNDLOAD $usrname/$Passwd
O Y
DOWNLOAD
$FND_TOP/patch/115/import/afffload.lct
file_name.ldt
VALUE_SET FLEX_VALUE_SET_NAME=LEARN_VALUESET
No comments:
Post a Comment