Profile options known about in Oracle
| Option Name | Values | Notes |
|---|---|---|
| HR:Self Service Save For Later | (Yes or No) | |
| ICX:Session Timeout | Num Minutes or NULL | Number of minutes to time out forms or NULL for no time out |
| Personalize Self-Service Defn | (Yes or No) | Turn on the persionalition hyper links |
| Java Color Scheme | SELECT MEANING, LOOKUP_CODE FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'COLOR_SCHEME' ORDER BY LOOKUP_CODE - (BLUE,TITANIUM,etc) |
Java Forms Colour Scheme |
| Site Name | Text | Jave Forms window title bar text |
| FND: Diagnostics | (Yes or No) | |
| Hide Diagnostics menu entry | (Yes or No) | Hides or shows the Help->Diagonstics menu entry in forms |
| Utilities:Diagnostics | (Yes or No) | Allow diagnostics functions (Maybe R12 only) |
| concurrent:Report access level | (User, Responsibility) | Should users with the same responsibility be able to view the output of CR's http://www.orafaq.com/forum/t/160572/0/ |
| Concurrent:Hold Requests | (Yes or No) | Hold requests as they are run |
| Forms Runtime Parameters | record = forms tracegroup = 0-97 | See Doc 373548.1 |
A query to access these:
-
SELECT
-
fpo.profile_option_id,
-
fpo.profile_option_name,
-
fpot.user_profile_option_name,
-
fpot.description,
-
fpov.level_id,
-
fpov.level_value,
-
case when fpov.level_id=10004 then
-
usr.user_name
-
else
-
'NOT USER LEVEL'
-
end as user_name,
-
fpov.profile_option_value
-
FROM apps.fnd_profile_options fpo
-
left join (
-
SELECT *
-
FROM apps.fnd_profile_options_tl
-
) fpot ON fpot.profile_option_name=fpo.profile_option_name
-
left join (
-
SELECT *
-
FROM fnd_profile_option_values
-
) fpov ON fpov.profile_option_id=fpo.profile_option_id
-
left join (
-
select *
-
from fnd_user
-
) usr on usr.user_id=fpov.level_value
-
--where fpo.profile_option_name like 'HR_SELF_SERV_SAVEFORLATER'
-
where user_profile_option_name = 'ICX: Forms Launcher'
Other Articles
See also Create Custom Profile Options
RJM Article Type
Quick Reference