Tuesday, June 8, 2010

Types of Value Sets

None (not validated at all)
Special (advanced)
Pair (advanced)

Attention: The Accounting Flexfield only supports Independent, Dependent, and Table validation. Also, You cannot change the validation type of an existing value set, since your changes affect all flexfields and report parameters that use the same value set.

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. Because a None value set is not validated, a parameter that uses this value set does not provide a list of values for your users.

An Independent value set provides a predefined list of values for a segment. These values can have an associated description. For example, the value 01 could have a description of "Company 01". The meaning of a value in this value set does not depend on the value of any other segment. Independent values are stored in an Oracle Application Object Library table. You define independent values using an Oracle Applications window, Segment Values.

A table-validated value set provides a predefined list of values like an independent set, but its values are stored in an application table. You define which table you want to use, along with a WHERE cause to limit the values you want to use for your set. Typically, you use a table-validated set when you have a table whose values are already maintained in an application table (for example, a table of vendor names maintained by a Define Vendors form). Table validation also provides some advanced advanced features such as allowing a segment to depend upon multiple prior segments in the same structure.

A dependent value set is similar to an independent value set, except that the available values in the list and the meaning of a given value depend on which independent value was selected in a prior segment of the flexfield structure. You can think of a dependent value set as a collection of little value sets, with one little set for each independent value in the corresponding independent value set. You must define your independent value set before you define the dependent value set that depends on it. You define dependent values in the Segment Values windows, and your values are stored in an Oracle Application Object Library table.

Special and Pair
Special and pair value sets provide a mechanism to allow a "flexfield-within-a- flexfield". These value sets are primarily used for Standard Report Submission parameters. You do not generally use these value sets for normal flexfield segments.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.