FND Profile Options

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
FND profile option definition
Run FND Profile Options and other Oracle EBS reports with Blitz Report™ on our demo environment
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,
fpov.start_date_active,
fpov.end_date_active,
xxen_util.user_name(fpov.created_by) created_by,
xxen_util.client_time(fpov.creation_date) creation_date,
xxen_util.user_name(fpov.last_updated_by) last_updated_by,
xxen_util.client_time(fpov.last_update_date) last_update_date
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
User Profile Name starts with 
upper(fpov.user_profile_option_name) like upper(:user_profile_option_name)||'%'
 LOV
System Profile Name starts with 
fpov.profile_option_name like upper(:profile_option_name)||'%'
 LOV
Show active only 
trunc(sysdate) between fpov.start_date_active and nvl(fpov.end_date_active,sysdate)
 LOV Oracle
Download
 
Related Blitz Reports
Profile Setup Track and Change AR Profile Option Migration FND Profile Option Values FND Responsibility Access FND FNDLOAD Object Transfer FND Concurrent Requests ASO Quote Data Template ONT Defaulting Rules Listing ZX Tax Regimes
Blitz Report™

Blitz Report™ provides multiple benefits: