How to create a custom profile with list of values
1. Define Custom Lookup with LOV
Application Developer Responsibility
|
|
Lookups
|
|
Create Custom Lookup <Name>
2. Define Custom Profile
Application Developer Responsibility
|
|
Profiles
|
|
In the Sql Validation 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 ="\"<FREE TEXT>\"(*)"
After creating the Custom profiles, you have to go to System administrator and can assign the profiles based on the Site level, Responsibility Level, user level etc. and give profile values based on the requirement.
No comments:
Post a Comment