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