Setting up a Value Set through Lookups Form

Create your user lookup data

  1. Create a lookup Type and data on the Applications Utilities Lookups form.
  2. Enter codes and meanings.
  3. 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

  1. Set up your value set.
  2. 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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s