Wikia

How To Wiki

Oracle Applications HOWTO: create profile with list of values

1,795pages on
this wiki
Talk0

Go to Michael Dvorkin's user page

Prerequisites Edit

E-Business Suite 11.5.9, 11.5.10


Steps to create profile with LOV Edit

1. 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>\"(*)"

Known Issues Edit

Go to Michael Dvorkin's user page

Around Wikia's network

Random Wiki