Create your user lookup data
- Create a lookup Type and data on the Applications Utilities Lookups form.
- Enter codes and meanings.
- Note the value you entered for field Type, you will need this information when setting up the Where/Order By block in the value set.
Change responsibility to System Administrator
Navigate to: Application > Validation> Set
- Set up your value set.
- Value Validation Type should = Table.
Click the Edit Information Button. This will take you to the Validation table Information form.Setup:
Table Application = Application Object Library
Table Name = FND_LOOKUP_VALUES
Value = LOOKUP_CODE
Meaning = MEANING
Where/Order By: where LOOKUP_TYPE = ‘xxxxx’
(xxxxx = your Type from step 1)
You can now attach this value set to a flexfield segment and use the Applications Utilities Lookups values in a flexfield.