How To Create Value Set In Oracle Apps R12

Value Set is a collection of values. It validates the values entered by the user for a flex-field, report parameters or a concurrent.

The navigation path: System Administrator à Application à Validation à Sets

Why do we need value sets?

You practise not ever want a user to enter junk free text into all the fields.

Hence, Oracle Apps uses value prepare to validate that correct data is beingness entered in

the fields in screen.

When to defining Values for Value Sets

• Later y'all register your Flexfields & report parameters, if you are using

independent or dependent value sets, yous can enter values into each

corresponding value set using the Segment Values form.

• Values for the Value Sets, we are defining volition be kept in the Oracle

Application Object Library tables.

How many Format Types the value gear up have

• Character
• Number
• Time
• Standard Date, Standard Date Time
• Date, Date Time

Is value set attached to all the fields that crave validations?

Answer: "NO"

And then where lies the usage of value sets?

Respond: Broadly speaking, value sets are attached to segments in Flexfields.

You can fence that value sets are likewise attached to parameters of concurrent

program(only in reality oracle treats parameters equally Descriptive Flexfields)

Specify the Listing Type for your value set up.

• Poplist - fewer than 10 values expected
• Listing of Values - between 10 and 200 values expected
• Long List of Values - more 200 values expected

What is Security type in value gear up?

• No Security - All security is disabled for this value prepare

• Hierarchical Security :- any security rule that applies to a parent value also

applies to its child values.

• Not-Hierarchical Security :-  a security dominion that applies to a parent value

does not "pour down" to its child values.

Value Set is associated with the following validations, which holds the primal to the value sets.

Types of Validations :

1. None : - Validation is minimal.

2. Contained: - The data input is based on previously defined list of values.

3. Dependent : - The data input is checked against a defined set of values.

4. Table : - The data input is checked against values in a table.

5. Special : - The data input is checked confronting a flex-field.

6. Pair : - The data input is checked confronting two flex-field specified range of values.

7. Translatable Independent : - The data input is checked against previously defined

list of values.

8. Translatable Dependent: - The data input is checked against divers set of values.

How many Character Formatting Options have for value set?

Numbers Merely (0-nine)

• Nosotros cannot forestall users from entering a value that contains the radix character.
• Cannot be used in Translatable Contained and Translatable Dependent value sets.

Capital Only (A-Z)

• Here also we cannot use in Translatable Contained and Translatable Dependent value sets.

Right-justify and Zer0-make full Numbers (0001)

• If you have selected Numbers Only (0â€"9) flag, then it wont permit you to affect this flag.
• Nosotros are recommended to use this in Bookkeeping Flex fields.

Minimum and Maximum Value Range

Your Minimum/maximum value may not be longer than the maximum size you specify for this value set. Once you specify a range of values, yous cannot define a new valid value that falls exterior this range.

The Minimum Value and Maximum Value fields tin therefore allow you to create a value gear up with a validation type of None.

What are Look Ups

A LOOKUP is a specific list of values which can exist set by a user. LOOKUPS take a 'type' and are either:

Admission levels of Lookups and differences

• USER (where the user can add/meliorate/delete items)
• EXTENSIBLE (where the user tin can add or amend his own items, but cannot change whatsoever of the 'seeded' values)
• SYSTEM (where the user cannot do anything to the 'seeded' values)

LOOKUPs are used straight by forms in the organization.

Global HRMS Director > Other Definitions > Application Utilities Lookups.

Difference between Lookups and Value Sets

S.no	Value Set	Await Ups
1	Value sets can be attached to parameters of a concurrent program	Lookups can't
2	Value Sets are almost never maintained past end users, with the exception of GL Flexfield codes. Value sets are usually maintained past System Administrators.	Sure types of Lookups are maintainable past the users too
iii	Value sets can incorporate values that are a result of an SQL Argument. Hence information technology is possible to make Value Set list of values dynamic	On the contrary, Lookup Codes are Static list of values
four	Nosotros tin practise the Validation check in values set and value fix has format type Char/varchar2/Number etc	No Validation Bank check in Await ups
5	In Value ready we tin can insert indistinguishable values	Lookup has Lookup code and pregnant and so values are unique

Significance of $FLEX$

$FLEX$: enables to match the prior segment with either value ready proper name or segment name.

Let v2 be the value set definition of 2d parameter and v1 be the value gear up definition for the outset parameter so

In the value set definition of v2 = value $FLEX$.v1

Note:

Changes You Should Never Brand

You should never make these types of changes (sometime value gear up to new value fix) because you will decadent your existing cardinal flex-field combinations data:

. Independent to Dependent

. Dependent to Independent

. None to Dependent

. Dependent to Table

. Table to Dependent

. Translatable Contained to Translatable Dependent

. Translatable Dependent to Translatable Independent

. None to Translatable Dependent

. Translatable Dependent to Table

. Tabular array to Translatable Dependent

How To Create Value Set In Oracle Apps R12,

Source: http://oracleapps88.blogspot.com/2014/10/oracle-value-sets.html

Posted by: choyasted1975.blogspot.com

Share this post