1. Value sets represents set of values. Through value sets, oracle apps validates that correct data is being entered in the fields in screen. Value sets are mainly used when specifying the list of data which can be entered as parameters when running a concurrent program.
2.Value sets are attached to segments in flex fields. Though value sets are attached to the parameter of concurrent program, but in reality oracle treats parameter as descriptive flex fields.
3. Types of value sets:;
2.Value sets are attached to segments in flex fields. Though value sets are attached to the parameter of concurrent program, but in reality oracle treats parameter as descriptive flex fields.
3. Types of value sets:;
- Independent: The value entered is validated against a predefined set of values.
- Dependent: The value is validated against a set of values which depends on an independent value sets.
- Table: The value entered is validated against a list of values which are dependent of tables.
- None: The values are only validated against the format type specified. For example, DATE is validated only when it is entered as MM/DD/YYYY, DD/MM/YY, etc. whatever format is specified. The values are not specified any predefined set of values.
- Special and pair: The value is validated against a set of values in another flex field.
4. The base table where name of the value sets is stored, then it is :
fnd_flex_value_sets.
The name of the table where values stored:
fnd_flex_values,
fnd_flex_values_tl
No comments:
Post a Comment