Create and Edit Table-Validated Value Sets Based on Lookups
While creating and editing value sets, use a predefined list of values that are stored in an application table.
You can specify which table you want to use, along with a WHERE clause to limit the values you want to use for your set. For example, let's use the FND_LOOKUPS view as the basis for a table-validated value set. The lookup meaning corresponds to the Value Column Name field and the lookup description corresponds to the Description Column Name field.
Create a Value Set Based on a Lookup
-
In the Setup and Maintenance work area, go to the Manage Value Sets task.
-
On the Manage Value Sets page, click the Create icon.
-
On the Create Value Set page, enter these values:
Field
Value
Value Set Code
SAMPLE_VALUE_SET_CODE
Description
Sample lookup-based table validated value set
Module
Oracle Middleware Extensions for Applications
Validation Type
Table
Value Data Type
Character
-
In the Definition section, enter these values:
Field
Value
FROM Clause
FND_LOOKUPS
Value Column Name
Meaning
Description Column Name
Description
Start Date Column Name
start_date_active
End Date Column Name
end_date_active
Enabled Flag Column Name
'Y'
ID Column Name
lookup_code
WHERE Clause
lookup_type = 'SAMPLE_LOOKUP_TYPE'
ORDER BY Clause
display_sequence, meaning
-
Click Save and Close.
Edit a Value Set Based on a Lookup
-
In the Setup and Maintenance work area, go to the Manage Value Sets task.
-
On the Manage Value Sets page, use the Search text field to search for a value set.
-
Select a value set and click the Edit icon.
-
On the Edit Value Set page, modify the existing values.
-
Click Save and Close.