Oracle Applications HOWTO: create profile with list of values

Go to Michael Dvorkin's user page

Prerequisites
E-Business Suite 11.5.9, 11.5.10

Steps to create profile with LOV
1. Define custom lookup

Choose "Application Developer" responsibility --> Lookups Create lookup 

2. Define custom profile

Choose "Application Developer" responsibility --> Profiles

In "SQL validation" field enter the following text:

SQL="SELECT MEANING, LOOKUP_CODE         INTO :VISIBLE_OPTION_VALUE, :PROFILE_OPTION_VALUE          FROM FND_LOOKUPS         WHERE LOOKUP_TYPE = ''         ORDER BY LOOKUP_CODE" COLUMN="Meaning(*)" HEADING="\"\"(*)"

Known Issues
Go to Michael Dvorkin's user page