How to Create Custom Profile Option in Oracle App

Define custom lookup

Choose "Application Developer" responsibility --> Lookups
Create lookup <Application Object Library Lookups Name

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 = '<LOOKUP NAME>'
ORDER BY LOOKUP_CODE"
COLUMN="Meaning(*)"
HEADING="\"<Any User Heading>\"(*)"