Reports2017-11-18T12:27:27+00:00

FND Profile Options

Description
Categories: Application, Enginatics, Setup
FND profile option definition

select
fpov.profile_option_name profile_name,
fav.application_name application,
fpov.user_profile_option_name user_profile_name,
fpov.description,
xxen_util.meaning(fpov.hierarchy_type,'PROFILE_OPTION_HIERARCHIES',0) hierarchy_type,
xxen_util.meaning(fpov.user_visible_flag,'YES_NO',0) user_access_visible,
xxen_util.meaning(fpov.user_changeable_flag,'YES_NO',0)  user_access_updatable,
xxen_util.meaning(fpov.site_enabled_flag,'YES_NO',0) site_visible,
xxen_util.meaning(fpov.site_update_allowed_flag,'YES_NO',0) site_updatable,
xxen_util.meaning(fpov.app_enabled_flag,'YES_NO',0) application_visible,
xxen_util.meaning(fpov.app_update_allowed_flag,'YES_NO',0) application_updatable,
xxen_util.meaning(fpov.resp_enabled_flag,'YES_NO',0) responsibility_visible,
xxen_util.meaning(fpov.resp_update_allowed_flag,'YES_NO',0) responsibility_updatable,
xxen_util.meaning(fpov.server_enabled_flag,'YES_NO',0) server_visible,
xxen_util.meaning(fpov.server_update_allowed_flag,'YES_NO',0) server_updatable,
xxen_util.meaning(fpov.serverresp_enabled_flag,'YES_NO',0) serverresp_visible,
xxen_util.meaning(fpov.serverresp_update_allowed_flag,'YES_NO',0) serverresp_updatable,
xxen_util.meaning(fpov.org_enabled_flag,'YES_NO',0) organization_visible,
xxen_util.meaning(fpov.org_update_allowed_flag,'YES_NO',0) organization_updatable,
xxen_util.meaning(fpov.user_enabled_flag,'YES_NO',0) user_visible,
xxen_util.meaning(fpov.user_update_allowed_flag,'YES_NO',0) user_updatable,
fpov.sql_validation
from
fnd_profile_options_vl fpov,
fnd_application_vl fav
where
1=1 and
fpov.application_id=fav.application_id
order by
fpov.profile_option_name

Parameter Name SQL text Validation
System Profile Name starts with
fpov.profile_option_name like upper(:profile_option_name)||'%'
LOV
User Profile Name starts with
upper(fpov.user_profile_option_name) like upper(:user_profile_option_name)||'%'
LOV
Show active only
trunc(sysdate) between fpov.start_date_active and nvl(fpov.end_date_active,sysdate)
LOV Oracle

By continuing to use the site, you agree to the use of cookies. Accept