ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9879D2E0530100007F1FF2 FND Application Name Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US 8E2FF36EDEBE79D2E0530100007F1FF2 FND Application Short Name Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name US 8E2FF36EDEF579D2E0530100007F1FF2 FND System Profile Name select fpov.profile_option_name value, fpov.user_profile_option_name description from fnd_profile_options_vl fpov order by fpov.profile_option_name US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDEF679D2E0530100007F1FF2 FND User Profile Name select fpov.user_profile_option_name value, fpov.profile_option_name description from fnd_profile_options_vl fpov order by fpov.user_profile_option_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US A740BB138CC6308CE053B46B6358F365 select fav0.application_name, fpo.user_profile_option_name, decode(fpov.level_id,10001,'Site',10002,'Application', 10003,'Responsibility', 10004,'User', 10005,'Server',10006,'Operating Unit', 10007,decode(to_char(fpov.level_value2),'-1','Responsibility',decode(to_char(fpov.level_value),'-1','Server','Server+Resp')) ) level_, decode(fpov.level_id,10001,null,10002,fav.application_name,10003,frv.responsibility_name,10004,xxen_util.user_name(decode(fpov.level_id,10004,fpov.level_value)),10005,fn.node_name,10006,haouv.name, 10007,decode(to_char(fpov.level_value2),'-1',frv.responsibility_name,decode(to_char(fpov.level_value),'-1',fn.node_name,fn.node_name||' - '||frv.responsibility_name)) ) level_name, xxen_util.display_profile_option_value(fpo.application_id,fpo.profile_option_id,fpov.profile_option_value) profile_option_value, xxen_util.user_name(fpov.last_updated_by) last_updated_by, xxen_util.client_time(fpov.last_update_date) last_update_date, fpov.profile_option_value system_profile_option_value, fpo.profile_option_name system_profile_option_name, fpo.profile_option_id, fpov.level_value, fpov.level_value2, xxen_util.user_name(fpov.created_by) created_by, xxen_util.client_time(fpov.creation_date) creation_date from fnd_application_vl fav0, fnd_profile_options_vl fpo, fnd_profile_option_values fpov, fnd_responsibility_vl frv, fnd_user fu, fnd_application_vl fav, hr_all_organization_units_vl haouv, fnd_nodes fn where 1=1 and fav0.application_id=fpo.application_id and fpo.profile_option_id=fpov.profile_option_id and fpo.application_id=fpov.application_id and decode(fpov.level_id,10002,fpov.level_value)=fav.application_id(+) and case when fpov.level_id in (10003,10007) then fpov.level_value end=frv.responsibility_id(+) and case when fpov.level_id in (10003,10007) then fpov.level_value_application_id end=frv.application_id(+) and decode(fpov.level_id,10004,fpov.level_value)=fu.user_id(+) and decode(fpov.level_id,10005,fpov.level_value,10007,fpov.level_value2)=fn.node_id(+) and decode(fpov.level_id,10006,fpov.level_value)=haouv.organization_id(+) order by fpo.user_profile_option_name, fpov.level_id, decode(fpov.level_id,10001,null,10002,fav.application_name, 10003,frv.responsibility_name, 10004,xxen_util.user_name(decode(fpov.level_id,10004,fpov.level_value)), 10005,fn.node_name,10006,haouv.name) complete unit test Y 49A8B1A8038C08ACE0530100007FEB91 :User_Profile_Name_starts_with is not null or :User_Profile_Name_any_lang is not null or :Setup_Level is not null or :Setup_Level_Value is not null or :Application_Name is not null or :Application_Short_Name is not null or :System_Profile_Name_starts_wi is not null or :Last_Update_Date_From is not null or :Last_Updated_By is not null or :Profile_System_Value_like is not null or :Redundant is not null US Profile Setup Track and Change BR100 Export / change tracking Unlike Oracle's SQL script from note 201945.1, this report also shows the user visible profile option value in addition to the internal system profile option value. 1=1 1 10 1=1 upper(fpo.user_profile_option_name) like upper(:user_profile_option_name)||'%' LOV FND User Profile Name 8E2FF36EDEF679D2E0530100007F1FF2 select fpov.user_profile_option_name value, fpov.profile_option_name description from fnd_profile_options_vl fpov order by fpov.user_profile_option_name US User Profile Name starts with 2 20 1=1 fpo.profile_option_name in (select fpot.profile_option_name from fnd_profile_options_tl fpot where fpot.user_profile_option_name=:user_profile_name_any_lang) LOV custom Y select distinct fpot.user_profile_option_name value, fpot.profile_option_name||': '||fpot.language description from fnd_profile_options_tl fpot where fpot.user_profile_option_name is not null order by fpot.profile_option_name||': '||fpot.language US User Profile Name any lang 3 30 1=1 fpov.level_id=decode(:setup_level,'Site',10001,'Application',10002,'Responsibility',10003,'User',10004,'Server',10005,'Operating Unit',10006) LOV custom Y select 'Site' value, null description from dual union all select 'Application' value, null description from dual union all select 'Responsibility' value, null description from dual union all select 'User' value, null description from dual union all select 'Server' value, null description from dual union all select 'Operating Unit' value, null description from dual Site US Setup Level 4 40 1=1 upper(decode(fpov.level_id,10002,fav.application_name, 10003,frv.responsibility_name, 10004,fu.user_name, 10005,'serverx',10006,haouv.name)) like upper(:setup_level_value) LOV custom Y select x.* from ( select fav.application_name value, 'APPLICATION: '||fav.application_short_name description from fnd_application_vl fav union all select hou.name value, 'OPERATING_UNIT' from hr_operating_units hou union all select frv.responsibility_name value, 'RESPONSIBILITY' description from fnd_responsibility_vl frv union all select fu.user_name value, 'USER'||nvl2(nvl(fu.description,fu.email_address),': '||nvl(fu.description,fu.email_address),null) description from fnd_user fu ) x where :$flex$.setup_level is null or x.description like upper(translate(:$flex$.setup_level,' ','_'))||'%' order by x.description, x.value US Setup Level Value 5 45 1=1 fav0.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US Application Name 6 47 1=1 fav0.application_short_name=:application_short_name LOV FND Application Short Name 8E2FF36EDEBE79D2E0530100007F1FF2 Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name US Application Short Name 7 50 1=1 fpo.profile_option_name like upper(:profile_option_name)||'%' LOV FND System Profile Name 8E2FF36EDEF579D2E0530100007F1FF2 select fpov.profile_option_name value, fpov.user_profile_option_name description from fnd_profile_options_vl fpov order by fpov.profile_option_name US System Profile Name starts with 8 55 1=1 fpov.last_update_date>=:updated_from DateTime 01-JUN-2019 00:00:00 US Last Update Date From 9 56 1=1 fpov.last_update_date<=:updated_to DateTime US Last Update Date To 10 57 1=1 fpov.last_updated_by=xxen_util.user_id(:last_updated_by) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US Last Updated By 11 60 1=1 fpov.profile_option_value like :profile_option_value Char US Profile System Value like 12 70 1=1 fpov.level_id<>10001 and exists ( select null from fnd_profile_option_values fpov2 where fpov.profile_option_value=fpov2.profile_option_value and fpov.application_id=fpov2.application_id and fpov.profile_option_id=fpov2.profile_option_id and fpov2.level_id=10001 and fpov2.level_value=0 ) and 'Yes'=:redundant LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Redundant :$flex$.setup_level Setup Level Setup Level Value Profiles DEVELOPER 1 APPLICATION_NAME 13 CREATED_BY 14 CREATION_DATE 7 LAST_UPDATED_BY 8 LAST_UPDATE_DATE 3 LEVEL_ 4 LEVEL_NAME 11 LEVEL_VALUE 12 LEVEL_VALUE2 10 PROFILE_OPTION_ID 5 PROFILE_OPTION_VALUE 9 SYSTEM_PROFILE_OPTION_NAME 6 SYSTEM_PROFILE_OPTION_VALUE 2 USER_PROFILE_OPTION_NAME S Site DEVELOPER Profiles