Fandom

How To Wiki

Oracle Applications HOWTO: create profile with list of values

1,795pages on
this wiki
Add New Page
Talk0 Share

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.

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

Also on Fandom

Random Wiki