How to create value set in oracle fusion

How do you create a dependent value set in fusion?

Here we use some different syntax to create Dependent table value set. If you need to validate the input against a list of values from an application table, then create a value set with the Table validation type. You define which table you want to use and you specify the column that contains the valid value.

What is value set in Oracle Fusion Financials?

Valuesets are nothing but a set of values. Valuesets when attached to a segment in DFF ,controls and validates the data that can be entered into that segment. Valueset types available in Fusion : Table : The valid values exist in a table column, use a table value set to specify the list of values.

How do you create an independent value set?

  1. Step 1: Create Independent Value Set. Create a value set XX_CAR_MAKES as shown in the below screen shot.
  2. Step 2: Create Dependent Value Set. Create a value set XX_CAR_MODEL as shown in the below screen shot.
  3. Step 3: Add Values for Independent Value set.
  4. Step 5: Add values for Dependent Value Set.

How do you use flex in value sets?

$FLEX$ is used in value sets to get the selected value of some other value set on a field on the form. So you could compare that value with a column in second value set and get the filtered result.

What is :$ flex and :$ Profile $?

$FLEX$ and $PROFILES$ are Special Variables in oracle Apps environment and are used to hold values at runtime. $FLEX$: Used for basing the value of a parameter on another parameter. $PROFILES$: used for fetching the data stored in the specified profile option value which is currently active.

What is the value set in Oracle Apps?

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

What is special value set in Oracle Apps?

Special validation value sets allow you to call key flexfield user exits to validate a flexfield segment or report parameter using a flexfield-within-a-flexfield mechanism. You can call flexfield routines and use a complete flexfield as the value passed by this value set.