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 8E2FF36EDE8279D2E0530100007F1FF2 FND Concurrent Program Name (SRS enabled only) select fcpv.user_concurrent_program_name value, fav.application_name||nvl2(fcpv.description,': ',null)||fcpv.description description from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv where fcpv.application_id=fav.application_id and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' order by fcpv.user_concurrent_program_name AR اسم البرنامج المتزامن FND يقتصر على SRS الممكّن فقط D FND gleichzeitiger Programmname beschränkt auf SRS aktiviert nur E Nombre del programa concurrente FND restringido sólo a los SRS habilitados F FND nom du programme concurrent limité à SRS activé uniquement I Nome del programma concorrente FND limitato al solo SRS abilitato JA FND 同時接続プログラム名をSRSに限定した場合のみ有効になります。 KO SRS로만 제한된 FND 동시 프로그램 이름 사용 가능 PTB FND nome do programa concorrente restrito à SRS habilitado apenas RU Одновременное имя программы FND, ограниченное только включенной SRS S FND: s samtidiga programnamn är endast begränsat till SRS aktiverat TR FND eşzamanlı program adı yalnızca SRS etkinleştirilmiş olarak sınırlandırılmıştır US FND concurrent program name restricted to SRS enabled only ZHS FND并发程序名称仅限于SRS启用。 8E2FF36EDEB079D2E0530100007F1FF2 FND Concurrent Program Name (all languages) Y select fcpt.user_concurrent_program_name value, '('||fcpt.language||') '||fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt where fcp.application_id=fav.application_id and fcp.srs_flag in ('Y','Q') and fcp.enabled_flag='Y' and fcp.application_id=fcpt.application_id and fcp.concurrent_program_id=fcpt.concurrent_program_id and fcpt.language=fcpt.source_lang order by fcpt.user_concurrent_program_name AR اسم البرنامج المتزامن بأي من اللغات المثبتة (وليس فقط لغة تسجيل الدخول) D Gleichzeitiger Programmname in einer beliebigen der installierten Sprachen (nicht nur der Anmeldesprache) E Nombre del programa concurrente en cualquiera de los idiomas instalados (no sólo el idioma de inicio de sesión) F Nom du programme simultané dans l'une des langues installées (pas seulement la langue de connexion) I Nome del programma concorrente in una qualsiasi delle lingue installate (non solo la lingua di login) JA インストールされているいずれかの言語での同時使用プログラム名 (ログイン言語だけではありません) KO 설치된 모든 언어로 된 동시 프로그램 이름 (로그인 언어뿐만 아니라) PTB Nome do programa concorrente em qualquer um dos idiomas instalados (não apenas o idioma de login) RU Одновременное имя программы на любом из установленных языков (а не только на языке входа в систему). S Samtidigt programnamn på något av de installerade språken (inte bara inloggningsspråket) TR Yüklü dillerden herhangi birinde eşzamanlı program adı (sadece giriş dili değil) US Concurrent program name in any of the installed languages (not just the login language) ZHS 用任何一种安装的语言（不仅仅是登录语言）并发的程序名称。 8E2FF36EDEA079D2E0530100007F1FF2 FND Concurrent Program Short Name (SRS enabled only) Y select fcpv.concurrent_program_name value, fav.application_name||': '||fcpv.user_concurrent_program_name description from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv where fav.application_id=fcpv.application_id and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' order by fcpv.concurrent_program_name AR الاسم المختصر للبرنامج المتزامن (البرامج الممكّنة والتي يمكن للمستخدم إرسالها فقط) D Kurzname des konkurrierenden Programms (nur freigegebene und vom Benutzer einreichbare Programme) E Nombre corto del programa concurrente (sólo para programas habilitados y que puedan ser enviados por el usuario) F Nom court du programme simultané (programmes activés et soumis par l'utilisateur uniquement) I Nome breve del programma concorrente (solo programmi abilitati e inviabili dall'utente) JA 同時使用プログラムの短縮名 (有効なプログラムとユーザーサブミット可能なプログラムのみ) KO 동시 프로그램 축약 이름 (사용 가능 및 사용자 제출 가능 프로그램 만 해당) PTB Nome curto do programa concorrente (somente programas habilitados e que podem ser submetidos pelo usuário) RU Одновременное короткое имя программы (только включенные и доступные для отправки пользователю программы). S Samtidigt programkortnamn (endast aktiverade och program som kan skickas av användare) TR Eşzamanlı program kısa adı (yalnızca etkin ve kullanıcı tarafından gönderilebilir programlar) US Concurrent program short name (enabled and user submittable programs only) ZHS 并发程序简称（仅启用和用户可提交的程序）。 8E2FF36EDEA779D2E0530100007F1FF2 FND Form Name Y select ffv.form_name value, fav.application_name||': '||ffv.user_form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.form_name US 8E2FF36EDEBB79D2E0530100007F1FF2 FND Function Name Y select fffv.function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.function_name US 8E2FF36EDE9379D2E0530100007F1FF2 FND Menu Name Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name US 8E2FF36EDE8F79D2E0530100007F1FF2 FND Request Group Y select frg.request_group_name value, frg.description from fnd_request_groups frg where (:$flex$.fnd_application_name is null or frg.application_id in (select fav.application_id from fnd_application_vl fav where fav.application_name=:$flex$.fnd_application_name)) order by frg.request_group_name US 8E2FF36EDEBA79D2E0530100007F1FF2 FND User Form Name (wildcard) select ffv.user_form_name value, fav.application_name||': '||ffv.form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.user_form_name US 8E2FF36EDEBC79D2E0530100007F1FF2 FND User Function Name (wildcard) select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where 1=1 and fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.user_function_name US 8E2FF36EDE8B79D2E0530100007F1FF2 FND User Menu Name Y select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name US 8E2FF36EDEB179D2E0530100007F1FF2 FND User Name (wildcard, active) Y select fu.user_name value, coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address ) description from fnd_user fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf where trunc(sysdate) between fu.start_date and nvl(fu.end_date,sysdate) and fu.employee_id=papf.person_id(+) order by fu.user_name US A95C471001B20DD1E0530100007FBF83 GL Ledger (all) Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'NONE',1,'PRIMARY',2,'SECONDARY',3,'ALC',4), gl.name D Alle Hauptbücher E Todos los libros de contabilidad F Tous les livres I Tutti i libri contabili US All ledgers 8E2FF36EDE8879D2E0530100007F1FF2 HR Operating Unit (all) Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name US 8E2FF36EDEA279D2E0530100007F1FF2 INV Organization Code (all) Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code US All active inventory organization codes 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 49A8B1A8037B08ACE0530100007FEB91 with func as ( select /*+ materialize*/ fffv.function_id from fnd_form_functions_vl fffv, fnd_form_vl ffv where 2=2 and '&show_function'='Y' and fffv.form_id=ffv.form_id(+) and fffv.application_id=ffv.application_id(+) ), nav as ( select /*+ materialize*/ sys_connect_by_path(fmev.prompt,'-> ') navigation_path_orig_, sys_connect_by_path(fmev.user_menu_name ,'-> ') menu_path_, sys_connect_by_path(to_char(fmev.entry_sequence,'000000.0'),'>') entry_sequence_, fmev.menu_id, connect_by_root fmev.function_id function_id from (select fmt.user_menu_name, fmev.* from fnd_menu_entries_vl fmev, fnd_menus_tl fmt where '&show_function'='Y' and fmev.sub_menu_id=fmt.menu_id(+) and fmt.language(+)=userenv('lang')) fmev connect by nocycle prior fmev.menu_id=fmev.sub_menu_id start with '&show_function'='Y' and fmev.function_id in (select func.function_id from func) ), gl as ( select distinct listagg(gl.name,chr(10)) within group (order by gl.object_type_code desc, gl.name) over (partition by gl.access_set_id) ledger, listagg(gl.ledger_id,chr(10)) within group (order by gl.object_type_code desc, gl.name) over (partition by gl.access_set_id) ledger_id, gl.access_set_id from ( select sum(lengthb(gl.name)+1) over (partition by gl.access_set_id order by gl.object_type_code desc, gl.name rows between unbounded preceding and current row) total_length, gl.* from ( select gl.name||decode(gl.object_type_code,'S',' ('||xxen_util.meaning(gl.object_type_code,'LEDGERS',101)||')') name, gl.ledger_id, gl.object_type_code, gasna.access_set_id from ( select gasna.access_set_id, gasna.ledger_id, gasna.status_code from gl_access_set_norm_assign gasna union select gasna.access_set_id, glsnav.ledger_id, gasna.status_code from gl_access_set_norm_assign gasna, gl_ledger_set_norm_assign_v glsnav where gasna.ledger_id=glsnav.ledger_set_id ) gasna, gl_ledgers gl where nvl(gasna.status_code,'x') not in ('D','I') and gasna.ledger_id=gl.ledger_id ) gl ) gl where gl.total_length<=4000 ), prof as ( select /*+ materialize*/ distinct y.security_profile_id, y.security_profile, decode('&expand_operating_units','Y',y.operating_unit,listagg(y.operating_unit,chr(10)) within group (order by y.operating_unit) over (partition by y.security_profile_id)) operating_unit, decode('&expand_operating_units','Y',y.legal_entity,listagg(y.legal_entity,chr(10)) within group (order by y.operating_unit) over (partition by y.security_profile_id)) legal_entity, decode('&expand_operating_units','Y',to_char(y.organization_id),listagg(y.organization_id,chr(10)) within group (order by y.operating_unit) over (partition by y.security_profile_id)) operating_unit_id from ( select decode('&expand_operating_units','Y',0,sum(lengthb(haouv.name)+1) over (partition by x.security_profile_id order by haouv.name rows between unbounded preceding and current row)) total_length, haouv.name operating_unit, (select xfi.name from hr_operating_units hou, xle_firstparty_information_v xfi where haouv.organization_id=hou.organization_id and hou.default_legal_context_id=xfi.legal_entity_id) legal_entity, x.* from ( select psp.security_profile_name security_profile, psp.security_profile_id, psp.business_group_id, psp.view_all_flag, coalesce(pol.organization_id,hou.organization_id,hou0.organization_id) organization_id from per_security_profiles psp, (select pol.* from per_organization_list pol, hr_operating_units hou where pol.organization_id=hou.organization_id and hou.usable_flag is null) pol, (select hou.* from hr_operating_units hou where hou.usable_flag is null) hou, (select -1 view_all, hou.* from hr_operating_units hou where hou.usable_flag is null) hou0 where decode(psp.view_all_flag,'N',psp.security_profile_id)=pol.security_profile_id(+) and decode(psp.view_all_flag,'Y',psp.business_group_id)=hou.business_group_id(+) and decode(psp.view_all_flag,'Y',nvl2(psp.business_group_id,null,-1))=hou0.view_all(+) ) x, (select haouv.* from hr_all_organization_units_vl haouv where sysdate between haouv.date_from and nvl(haouv.date_to,sysdate)) haouv where x.organization_id=haouv.organization_id(+) ) y where y.total_length<=4000 ), usr as ( select /*+ materialize*/ furg.responsibility_application_id, furg.responsibility_id, furg.user_id, xxen_util.user_name(furg.user_id) user_name, nvl(fu.email_address,papf.email_address) email, papf.first_name||' '||papf.last_name person, haouv.name person_bg from fnd_user_resp_groups furg, fnd_user fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date+1) papf, (select haouv.* from hr_all_organization_units_vl haouv where sysdate between haouv.date_from and nvl(haouv.date_to,sysdate)) haouv where 3=3 and '&show_user'='Y' and furg.user_id=fu.user_id and trunc(sysdate) between fu.start_date and nvl(fu.end_date,sysdate) and fu.employee_id=papf.person_id(+) and papf.business_group_id=haouv.organization_id(+) ) --------------SQL starts here------------- select /*+ dynamic_sampling(3) */ z.responsibility_name responsibility, z.application_name, &col1 z.request_group_application, z.request_group_name, &col_conc z.user_menu_name, z.gl_access_set "GL: Data Access Set", z.ledger, z.security_profile "MO: Security Profile", z.operating_unit, z.legal_entity, z.organization, z.responsibility_key, &col2 z.menu_name, z.sql_session_init, z.responsibility_created_by, z.responsibility_creation_date, z.responsibility_last_updated_by, z.responsibility_last_updt_date, z.resp_application_id application_id, z.responsibility_id, z.ledger_id, z.operating_unit_id, z.organization_id from ( select y.*, case when y.fffv_type<>'SUBFUNCTION' and y.navigation_path_orig not like '%-> ' and y.navigation_path_orig not like '%-> -> %' then substr(y.navigation_path_orig,4) end navigation_path, (select gasv.name from gl_access_sets_v gasv where y.gl_access_set_id=gasv.access_set_id) gl_access_set, gl.ledger, gl.ledger_id, prof.security_profile, case when prof.security_profile_id is not null then prof.operating_unit else (select haouv.name from hr_all_organization_units_vl haouv where y.org_id=haouv.organization_id) end operating_unit, case when prof.security_profile_id is not null then prof.legal_entity else (select xfi.name from hr_operating_units hou, xle_firstparty_information_v xfi where y.org_id=hou.organization_id and hou.default_legal_context_id=xfi.legal_entity_id) end legal_entity, case when prof.security_profile_id is not null then prof.operating_unit_id else y.org_id end operating_unit_id, oav.organization, oav.organization_id from ( select frv.responsibility_name, fav.application_name, usr.user_name, usr.email, usr.person, usr.person_bg, xxen_util.reverse(nav.navigation_path_orig_,'-> ') navigation_path_orig, fffv.user_function_name, xxen_util.meaning(fffv.type,'FORM_FUNCTION_TYPE',0) function_type, ffv.user_form_name, fffv.web_html_call html_call, fav3.application_name request_group_application, frg.request_group_name, decode(frgu.request_unit_type,'P','Program','A','Application','S','Set') assignment_type, decode(frgu.request_unit_type,'P',fcpv.user_concurrent_program_name,'A',fav2.application_name,'S',frsv.user_request_set_name) assignment_name, fmv.user_menu_name, frv.responsibility_key, nvl(fcpv.user_concurrent_program_name,fcpv2.user_concurrent_program_name) concurrent_program, nvl(fcpv.concurrent_program_name,fcpv2.concurrent_program_name) conc_program_code, xxen_util.meaning(nvl(fev.execution_method_code,fev2.execution_method_code),'CP_EXECUTION_METHOD_CODE',0) execution_method, nvl(fev.execution_file_name,fev2.execution_file_name) execution_file_name, fmv.menu_name||'-> '||substr(xxen_util.reverse(nav.menu_path_,'-> '),4) menu_path, fffv.function_name, ffv.form_name, fffv.parameters, fmv.menu_name, coalesce( (select fpov.profile_option_value from fnd_profile_option_values fpov where fpov.application_id=602 and fpov.profile_option_id=3796 and fpov.level_id=10004 and usr.user_id=fpov.level_value), (select fpov.profile_option_value from fnd_profile_option_values fpov where fpov.application_id=602 and fpov.profile_option_id=3796 and fpov.level_id=10003 and frv.responsibility_id=fpov.level_value and frv.application_id=fpov.level_value_application_id), (select fpov.profile_option_value from fnd_profile_option_values fpov where fpov.application_id=602 and fpov.profile_option_id=3796 and fpov.level_id=10001 and fpov.level_value=0) ) security_profile_id, coalesce( (select fpov.profile_option_value from fnd_profile_option_values fpov where fpov.application_id=0 and fpov.profile_option_id=1991 and fpov.level_id=10004 and usr.user_id=fpov.level_value), (select fpov.profile_option_value from fnd_profile_option_values fpov where fpov.application_id=0 and fpov.profile_option_id=1991 and fpov.level_id=10003 and frv.responsibility_id=fpov.level_value and frv.application_id=fpov.level_value_application_id), (select fpov.profile_option_value from fnd_profile_option_values fpov where fpov.application_id=0 and fpov.profile_option_id=1991 and fpov.level_id=10001 and fpov.level_value=0) ) org_id, coalesce( (select to_number(fpov.profile_option_value) from fnd_profile_option_values fpov where fpov.application_id=101 and fpov.profile_option_id=(select fpo.profile_option_id from fnd_profile_options fpo where fpo.profile_option_name='GL_ACCESS_SET_ID') and fpov.level_id=10004 and usr.user_id=fpov.level_value), (select to_number(fpov.profile_option_value) from fnd_profile_option_values fpov where fpov.application_id=101 and fpov.profile_option_id=(select fpo.profile_option_id from fnd_profile_options fpo where fpo.profile_option_name='GL_ACCESS_SET_ID') and fpov.level_id=10003 and frv.responsibility_id=fpov.level_value and frv.application_id=fpov.level_value_application_id), (select to_number(fpov.profile_option_value) from fnd_profile_option_values fpov where fpov.application_id=101 and fpov.profile_option_id=(select fpo.profile_option_id from fnd_profile_options fpo where fpo.profile_option_name='GL_ACCESS_SET_ID') and fpov.level_id=10001 and fpov.level_value=0) ) gl_access_set_id, fffv.type fffv_type, xxen_util.reverse(nav.entry_sequence_,'>') entry_sequence, xxen_util.user_name(frv.created_by) responsibility_created_by, xxen_util.client_time(frv.creation_date) responsibility_creation_date, xxen_util.user_name(frv.last_updated_by) responsibility_last_updated_by, xxen_util.client_time(frv.last_update_date) responsibility_last_updt_date, frv.application_id resp_application_id, frv.responsibility_id, frgu.request_unit_type, frgu.unit_application_id, frgu.request_unit_id, nvl(fcpv.application_id,fcpv2.application_id) conc_application_id, nvl(fcpv.concurrent_program_id,fcpv2.concurrent_program_id) concurrent_program_id, usr.user_id, fcmf.function_id, case when usr.user_id is not null then 'begin fnd_global.apps_initialize('||usr.user_id||','||usr.responsibility_id||','||usr.responsibility_application_id||'); mo_global.init('''||decode(fmpi.status,'Y','M','S')||'''); '|| nvl2(frv.default_mo_org,'fnd_profile.put(''MFG_ORGANIZATION_ID'','''||frv.default_mo_org||'''); ',null)||'gl_security_pkg.init; end;' end sql_session_init from fnd_application_vl fav, ( select (select oav.organization_id from org_access_view oav where frv.application_id=oav.resp_application_id and frv.responsibility_id=oav.responsibility_id and rownum=1) default_mo_org, frv.* from fnd_responsibility_vl frv where trunc(sysdate) between frv.start_date and nvl(frv.end_date,sysdate) ) frv, fnd_application_vl fav3, fnd_request_groups frg, (select frgu.* from fnd_request_group_units frgu where '&show_concurrent'='Y') frgu, (select fcpv.* from fnd_concurrent_programs_vl fcpv where fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y') fcpv, fnd_executables_vl fev, (select fcpv2.* from fnd_concurrent_programs_vl fcpv2 where 4=4 and '&show_concurrent'='Y' and fcpv2.srs_flag in ('Y','Q') and fcpv2.enabled_flag='Y') fcpv2, fnd_executables_vl fev2, fnd_application_vl fav2, fnd_request_sets_vl frsv, fnd_menus_vl fmv, usr, (select fcmf.* from fnd_compiled_menu_functions fcmf where '&show_function'='Y' and fcmf.function_id in (select func.function_id from func) and nvl(fcmf.grant_flag,'Y')='Y') fcmf, nav, fnd_form_functions_vl fffv, fnd_form_vl ffv, fnd_mo_product_init fmpi where 1=1 and fav.application_id=frv.application_id and frv.group_application_id=fav3.application_id(+) and frv.group_application_id=frg.application_id(+) and frv.request_group_id=frg.request_group_id(+) and frg.application_id=frgu.application_id(+) and frg.request_group_id=frgu.request_group_id(+) and decode(frgu.request_unit_type,'P',frgu.unit_application_id)=fcpv.application_id(+) and decode(frgu.request_unit_type,'P',frgu.request_unit_id)=fcpv.concurrent_program_id(+) and fcpv.executable_application_id=fev.application_id(+) and fcpv.executable_id=fev.executable_id(+) and decode(frgu.request_unit_type,'A',frgu.unit_application_id)=fav2.application_id(+) and decode(frgu.request_unit_type,'A',frgu.unit_application_id)=fcpv2.application_id(+) and fcpv2.executable_application_id=fev2.application_id(+) and fcpv2.executable_id=fev2.executable_id(+) and decode(frgu.request_unit_type,'S',frgu.unit_application_id)=frsv.application_id(+) and decode(frgu.request_unit_type,'S',frgu.request_unit_id)=frsv.request_set_id(+) and frv.responsibility_id=usr.responsibility_id(+) and frv.application_id=usr.responsibility_application_id(+) and frv.menu_id=fmv.menu_id(+) and frv.menu_id=fcmf.menu_id(+) and fcmf.menu_id=nav.menu_id(+) and fcmf.function_id=nav.function_id(+) and fcmf.function_id=fffv.function_id(+) and fffv.application_id=ffv.application_id(+) and fffv.form_id=ffv.form_id(+) and fav.application_short_name=fmpi.application_short_name(+) and (fcmf.function_id is null or not exists (select null from fnd_resp_functions frf where frf.rule_type='F' and frf.application_id=frv.application_id and frf.responsibility_id=frv.responsibility_id and frf.action_id=fcmf.function_id)) and (fcmf.function_id is null or not exists (select null from fnd_resp_functions frf, fnd_compiled_menu_functions fcmf2 where frf.rule_type='M' and frf.application_id=frv.application_id and frf.responsibility_id=frv.responsibility_id and fcmf2.menu_id=frf.action_id and fcmf2.function_id=fcmf.function_id and nvl(fcmf2.grant_flag,'Y')='Y')) ) y, gl, prof, ( select distinct listagg(oav.organization_code,chr(10)) within group (order by oav.organization_code) over (partition by oav.resp_application_id, oav.responsibility_id) organization, listagg(oav.organization_id,chr(10)) within group (order by oav.organization_code) over (partition by oav.resp_application_id, oav.responsibility_id) organization_id, oav.resp_application_id, oav.responsibility_id from ( select greatest( sum(lengthb(oav.organization_code)+1) over (partition by oav.resp_application_id, oav.responsibility_id order by oav.organization_code rows between unbounded preceding and current row), sum(lengthb(oav.organization_id)+1) over (partition by oav.resp_application_id, oav.responsibility_id order by oav.organization_code rows between unbounded preceding and current row) ) total_length, oav.* from org_access_view oav ) oav where oav.total_length<=4000 ) oav where y.gl_access_set_id=gl.access_set_id(+) and y.security_profile_id=prof.security_profile_id(+) and y.responsibility_id=oav.responsibility_id(+) and y.resp_application_id=oav.resp_application_id(+) ) z where 5=5 order by z.application_name, z.responsibility_name, z.user_name, case when z.navigation_path is not null and z.fffv_type<>'SUBFUNCTION' then 1 else 2 end, z.entry_sequence, z.menu_path, z.user_function_name, z.operating_unit Added legal entity column linked to operating unit. Added menu exclusion filtering (fnd_resp_functions rule_type F and M) so excluded functions/menus no longer show. Y not ( nvl(:User_Name_like,'x')='%' and (nvl(:User_Form_Name_like,'x')='%' or nvl(:Form_Name,'x')='%' or nvl(:User_Function_Name_like,'x')='%') or nvl(:Concurrent_Program_Name_like,'x')='%' and (nvl(:User_Form_Name_like,'x')='%' or nvl(:Form_Name,'x')='%' or nvl(:User_Function_Name_like,'x')='%') or nvl(:Concurrent_Program_Name_like,'x')='%' and nvl(:User_Name_like,'x')='%') AR FND Access Control المسؤوليات والبيانات ذات الصلة مثل المستخدمين والبرامج المتزامنة والقوائم والوظائف والنماذج ومجموعة الوصول إلى البيانات وملفات تعريف الأمان ودفاتر الأستاذ ووحدات التشغيل المرتبطة بها. هذا التقرير يجيب بشكل أساسي على جميع الأسئلة المتعلقة بالوصول إلى النظام. وهو يوضح المستخدمين أو المسؤوليات التي لها حق الوصول إلى الوظائف أو النماذج أو البرامج المتزامنة أو دفاتر الأستاذ أو وحدات التشغيل أو مؤسسات المخزون. بناءً على اختيار المعلمة ، يعرض هذا التقرير على سبيل المثال: - المسؤوليات والقوائم ذات الصلة ومجموعات الطلب - المسؤوليات والقوائم والنماذج والوظائف المضمنة ومسار تصفح القائمة الكامل - المستخدمون والمسؤوليات النشطة الموكلة إليهم - المستخدمون والمسؤوليات المعينة والبرامج المتزامنة التي يمكنهم الوصول إليها - البرامج المتزامنة والمسؤوليات التي يمكن تشغيلها من خلالها - الأشكال أو الوظائف والمسؤوليات والمستخدمين الذين يمكنهم الوصول إليها - المسؤوليات ومسارات التنقل للوصول إلى شكل أو وظيفة معينة من مستخدم معين - وحدات التشغيل التي يمكن لمسؤول معين أو مستخدم الوصول إليها من خلال ملفات تعريف أمان MOAC أو خيار الملف الشخصي "MO: وحدة التشغيل" المعلمات "المستخدم" و "النموذج" و "الوظيفة" و "البرنامج المتزامن" اختيارية ويمكن ملؤها إما لتصفية السجلات لقيمة معينة فقط أو إدخالها مع٪ لإظهار جميع القيم أو تركها فارغة لعدم إظهار البيانات المتعلقة تلك المعلمة. إذا تم ترك معلمة المستخدم فارغة على سبيل المثال ، فلن يعرض التقرير أي أسماء مستخدمين ويعرض المعلومات المتعلقة بمستوى المسؤولية فقط. مثال: لإظهار جميع المستخدمين الذين لديهم حق الوصول إلى نموذج صيانة المستخدم ، أدخل المعلمات على النحو التالي: اسم االمستخدم: ٪ اسم نموذج المستخدم: تحديد مستخدم التطبيق يرجى ملاحظة أن SQL لا تأخذ في الاعتبار استثناءات القائمة حتى الآن ، مما يعني أنها ليست دقيقة بنسبة 100٪ لأن الوظائف المستبعدة ستستمر في الظهور في التقرير. الرجاء إدخال معلمات أكثر تقييدًا. D FND Access Control Zuständigkeiten und zugehörige Daten wie Benutzer, gleichzeitige Programme, Menüs, Funktionen, Formulare, Datenzugriffssätze und Sicherheitsprofile sowie zugehörige Ledger und Bedieneinheiten. Dieser Bericht beantwortet grundsätzlich alle Fragen zum Systemzugriff. Er zeigt, welche Benutzer oder Verantwortlichkeiten Zugriff auf welche Funktionen, Formulare, konkurrierende Programme, Ledger, Betriebseinheiten oder Bestandsorganisationen haben. Je nach Auswahl der Parameter zeigt dieser Bericht z. B. an: - Verantwortlichkeiten und zugehörige Menüs und Anforderungsgruppen - Zuständigkeiten, Menüs, enthaltene Formulare, Funktionen und deren vollständiger Menüpfad - Benutzer und ihre zugewiesenen aktiven Zuständigkeiten - Benutzer, zugewiesene Zuständigkeiten und die gleichzeitigen Programme, auf die sie Zugriff haben - Gleichzeitige Programme und die Zuständigkeiten, von denen aus sie ausgeführt werden können - Formulare oder Funktionen und die Zuständigkeiten und Benutzer, die auf sie zugreifen können - Zuständigkeiten und Navigationspfade für den Zugriff auf ein bestimmtes Formular oder eine Funktion durch einen bestimmten Benutzer - Betriebseinheiten, auf die eine bestimmte Verantwortung oder ein bestimmter Benutzer über MOAC-Sicherheitsprofile oder die Profiloption 'MO: Bedieneinheit' Die Parameter 'User', 'Form', 'Function' und 'Concurrent Program' sind optional und können entweder ausgefüllt werden, um Datensätze nur nach einem bestimmten Wert zu filtern, oder mit % eingegeben werden, um alle Werte anzuzeigen, oder leer gelassen werden, um keine Daten zu diesem Parameter anzuzeigen. Wenn z. B. der Parameter "Benutzer" leer gelassen wird, zeigt der Bericht keine Benutzernamen und nur Informationen zur Verantwortungsebene an. Beispiel: Um alle Benutzer anzuzeigen, die Zugriff auf das Benutzerpflegeformular haben, geben Sie die Parameter wie folgt ein: Benutzer-Name: % Name des Benutzerformulars: Benutzer der Anwendung definieren Bitte beachten Sie, dass das SQL derzeit noch keine Menüausschlüsse berücksichtigt, was bedeutet, dass es nicht 100%ig genau ist, da ausgeschlossene Funktionen immer noch im Bericht auftauchen würden. Bitte geben Sie restriktivere Parameter ein. E FND Access Control Responsabilidades y datos relacionados como usuarios, programas concurrentes, menús, funciones, formularios, conjunto de acceso a datos y perfiles de seguridad y libros de contabilidad y unidades operativas asociadas. Este informe responde básicamente a todas las preguntas relacionadas con el acceso al sistema. Muestra qué usuarios o responsabilidades tienen acceso a qué funciones, formularios, programas concurrentes, libros mayores, unidades operativas u organizaciones de inventario. Dependiendo de la selección de parámetros, este informe muestra, por ejemplo - responsabilidades y menús relacionados y grupos de solicitudes - las responsabilidades, los menús, los formularios incluidos, las funciones y su ruta completa de navegación por los menús - usuarios y sus responsabilidades activas asignadas - usuarios, responsabilidades asignadas y los programas concurrentes a los que tienen acceso - los programas concurrentes y las responsabilidades desde las que se pueden ejecutar - formularios o funciones y las responsabilidades y usuarios que pueden acceder a ellos - responsabilidades y rutas de navegación para acceder a un determinado formulario o función desde un determinado usuario - unidades operativas a las que una determinada responsabilidad o usuario tiene acceso a través de los perfiles de seguridad del MOAC o de la opción de perfil 'MO: Unidad operativa". Los parámetros 'Usuario', 'Formulario', 'Función' y 'Programa Concurrente' son opcionales y pueden rellenarse para filtrar los registros sólo para un valor concreto o introducirse con % para mostrar todos los valores o dejarse en blanco para no mostrar los datos relacionados con ese parámetro. Si el parámetro de usuario se deja en blanco, por ejemplo, el informe no muestra ningún nombre de usuario y muestra la información relacionada con el nivel de responsabilidad solamente. Ejemplo: Para mostrar todos los usuarios que tienen acceso al formulario de mantenimiento de usuarios, introduzca los parámetros de la siguiente manera Nombre de usuario: % Nombre del formulario de usuario: Definir usuario de la aplicación Tenga en cuenta que el SQL actualmente no considera las exclusiones de los menús, lo que significa que no es 100% exacto ya que las funciones excluidas seguirían apareciendo en el informe. Por favor, introduzca parámetros más restrictivos. F FND Access Control Responsabilités et données connexes telles que les utilisateurs, les programmes concurrents, les menus, les fonctions, les formulaires, l'ensemble des accès aux données et les profils de sécurité ainsi que les grands livres et les unités opérationnelles associés. Ce rapport répond essentiellement à toutes les questions relatives à l'accès au système. Il indique quels utilisateurs ou responsabilités ont accès à quelles fonctions, formulaires, programmes concurrents, grands livres, unités opérationnelles ou organisations d'inventaire. Selon le choix des paramètres, ce rapport montre par exemple - les responsabilités, les menus et les groupes de demandes connexes - les responsabilités, les menus, les formulaires inclus, les fonctions et leur chemin de navigation complet dans le menu - les utilisateurs et les responsabilités actives qui leur sont attribuées - les utilisateurs, les responsabilités attribuées et les programmes concurrents auxquels ils ont accès - les programmes concurrents et les responsabilités qui peuvent être assumées - les formes ou les fonctions, ainsi que les responsabilités et les utilisateurs qui peuvent y accéder - les responsabilités et les chemins de navigation pour accéder à une certaine forme ou fonction à partir d'un utilisateur donné - les unités opérationnelles auxquelles une responsabilité ou un utilisateur particulier a accès grâce aux profils de sécurité MOAC ou à l'option de profil "MO" : Unité opérationnelle". Les paramètres "Utilisateur", "Formulaire", "Fonction" et "Programme simultané" sont facultatifs et peuvent être remplis pour filtrer les enregistrements pour une valeur particulière seulement ou être entrés avec un % pour montrer toutes les valeurs ou laissés vides pour ne pas montrer les données liées à ce paramètre. Si le paramètre utilisateur est laissé vide, par exemple, le rapport n'affiche pas de nom d'utilisateur et présente uniquement les informations relatives au niveau de responsabilité. Exemple : Pour afficher tous les utilisateurs ayant accès au formulaire de maintenance des utilisateurs, entrez les paramètres comme suit : Nom de l'utilisateur : % Nom du formulaire d'utilisateur : Définir l'utilisateur de l'application Veuillez noter que le SQL ne tient pas encore compte des exclusions de menu, ce qui signifie qu'il n'est pas précis à 100 % car les fonctions exclues apparaîtraient toujours dans le rapport. Veuillez entrer des paramètres plus restrictifs. I FND Access Control Responsabilità e dati correlati come utenti, programmi concorrenti, menu, funzioni, moduli, set di accesso ai dati e profili di sicurezza, nonché libri mastri e unità operative associate. Questo rapporto risponde fondamentalmente a tutte le domande relative all'accesso al sistema. Mostra quali utenti o responsabilità hanno accesso a quali funzioni, moduli, programmi concorrenti, registri, unità operative o organizzazioni di inventario. A seconda della selezione dei parametri, questo rapporto mostra per esempio: - responsabilità e relativi menu e gruppi di richiesta - responsabilità, menu, moduli inclusi, funzioni e il loro percorso di navigazione del menu completo - gli utenti e le responsabilità attive loro assegnate - gli utenti, le responsabilità assegnate e i programmi concorrenti a cui hanno accesso - programmi concorrenti e le responsabilità da cui possono essere eseguiti - moduli o funzioni e le responsabilità e gli utenti che possono accedervi - responsabilità e percorsi di navigazione per accedere a un determinato modulo o funzione da un determinato utente - unità operative a cui una particolare responsabilità o utente ha accesso attraverso i profili di sicurezza MOAC o l'opzione di profilo 'MO: Unità operativa'. I parametri 'User', 'Form', 'Function' e 'Concurrent Program' sono opzionali e possono essere o popolati per filtrare i record solo per un particolare valore o inseriti con % per mostrare tutti i valori o lasciati vuoti per non mostrare i dati relativi a quel parametro. Se il parametro utente è lasciato vuoto per esempio, allora il rapporto non mostra alcun nome utente e mostra solo le informazioni relative al livello di responsabilità. Esempio: Per mostrare tutti gli utenti che hanno accesso al modulo di manutenzione utenti, inserisci i parametri come segue: Nome utente: % Nome del modulo utente: Definisci utente dell'applicazione Si prega di notare che l'SQL attualmente non considera ancora le esclusioni di menu, il che significa che non è accurato al 100% poiché le funzioni escluse verrebbero comunque visualizzate nel rapporto. Si prega di inserire parametri più restrittivi. JA FND Access Control ユーザー、同時実行プログラム、メニュー、機能、フォーム、データアクセスセットとセキュリティプロファイル、関連する台帳や操作ユニットなどの責任と関連データ。 このレポートは、基本的にすべてのシステムアクセス関連の質問に答えます。これは、どのユーザーまたは責任がどの機能、フォーム、同時実行プログラム、台帳、操作ユニットまたはインベントリ組織にアクセスできるかを示しています。 パラメータの選択に応じて、このレポートでは、例えば以下のように表示されます。 - 担当業務と関連メニュー、リクエストグループ - 責任、メニュー、含まれるフォーム、機能、およびそれらのフルメニューのナビゲーションパス - ユーザーとその割り当てられたアクティブな責任 - ユーザー、割り当てられた責任、および同時にアクセスできるプログラム - 同時進行のプログラムと、それらが実行できる責任 - フォームや機能、およびそれらにアクセスできる責任とユーザー - レスポンシビリティパス - 特定の責任者またはユーザーが MOAC セキュリティプロファイルまたはプロファイルオプション 'MO.オペレーティングユニット パラメータ 'User'、'Form'、'Function' および 'Concurrent Program' はオプションで、特定の値のみのレコードをフィルタリングするために入力するか、すべての値を表示するために % を入力するか、そのパラメータに関連するデータを表示しないために空白のままにしておくことができます。例えば、ユーザ・パラメータが空白のままになっている場合、レポートにはユーザ名は表示されず、責任レベルに関連する情報のみが表示されます。 例）以下のようにパラメータを入力します。ユーザーメンテナンスフォームにアクセスできるすべてのユーザーを表示するには、次のようにパラメータを入力します。 ユーザ名。% ユーザーフォーム名。アプリケーションのユーザーを定義します。 現在のところ、SQLはメニューの除外を考慮していないので、除外された関数はまだレポートに表示されるため、100%正確ではないことに注意してください。 より制限的なパラメータを入力してください。 KO FND Access Control 사용자, 동시 작업 프로그램, 메뉴, 기능, 양식, 데이터 액세스 세트 및 보안 프로필, 관련 원장 및 운영 단위와 같은 책임 및 관련 데이터. 이 보고서는 기본적으로 모든 시스템 액세스 관련 질문에 답합니다. 어떤 사용자 또는 책임이 어떤 기능, 양식, 동시 작업 프로그램, 원장, 운영 단위 또는 재고 조직에 액세스하는지 보여줍니다. 매개 변수 선택에 따라이 보고서는 예를 들어 다음을 표시합니다. -책임 및 관련 메뉴 및 요청 그룹 -책임, 메뉴, 포함 된 양식, 기능 및 전체 메뉴 탐색 경로 -사용자 및 할당 된 활성 책임 -사용자, 할당 된 책임 및 액세스 권한이있는 동시 프로그램 -동시 프로그램 및 실행할 수있는 책임 -양식 또는 기능과 이에 액세스 할 수있는 책임 및 사용자 -주어진 사용자로부터 특정 양식 또는 기능에 액세스하기위한 책임 및 탐색 경로 -특정 책임 또는 사용자가 MOAC 보안 프로필 또는 프로필 옵션 'MO : Operating Unit'을 통해 액세스 할 수있는 운영 단위 '사용자', '양식', '함수'및 '동시 프로그램'매개 변수는 선택 사항이며 특정 값에 대한 레코드 만 필터링하도록 채우거나 모든 값을 표시하려면 %를 입력하거나 관련 데이터를 표시하지 않으려면 공백으로 둘 수 있습니다. 그 매개 변수. 예를 들어 사용자 매개 변수를 비워두면 보고서에 사용자 이름이 표시되지 않고 책임 수준과 관련된 정보 만 표시됩니다. 예 : 사용자 유지 관리 양식에 액세스 할 수있는 모든 사용자를 표시하려면 다음과 같이 매개 변수를 입력합니다. 사용자 이름: % 사용자 양식 이름 : 응용 프로그램 사용자 정의 SQL은 현재 메뉴 제외를 아직 고려하지 않습니다. 즉, 제외 된 기능이 보고서에 계속 표시되므로 100 % 정확하지 않습니다. 더 제한적인 매개 변수를 입력하십시오. PTB FND Access Control Responsabilidades e dados relacionados tais como usuários, programas simultâneos, menus, funções, formulários, conjunto de acesso aos dados e perfis de segurança e ledgers e unidades operacionais associados. Este relatório basicamente responde a todas as perguntas relacionadas ao acesso ao sistema. Ele mostra quais usuários ou responsabilidades têm acesso a quais funções, formulários, programas simultâneos, ledgers, unidades operacionais ou organizações de inventário. Dependendo da seleção de parâmetros, este relatório mostra, por exemplo: - responsabilidades e cardápios relacionados e grupos de solicitação - responsabilidades, menus, formulários incluídos, funções e seu caminho completo de navegação no menu - usuários e suas responsabilidades ativas atribuídas - usuários, responsabilidades atribuídas e os programas simultâneos a que têm acesso - programas simultâneos e as responsabilidades de que eles podem ser executados a partir - formas ou funções e as responsabilidades e usuários que podem acessá-las - responsabilidades e caminhos de navegação para acessar uma determinada forma ou função de um determinado usuário - unidades operacionais que uma determinada responsabilidade ou usuário tem acesso através de perfis de segurança MOAC ou opção de perfil "MO": Unidade Operacional''. Os parâmetros 'Usuário', 'Formulário', 'Função' e 'Programa Concorrente' são opcionais e podem ser preenchidos para filtrar registros apenas para um determinado valor ou inseridos com % para mostrar todos os valores ou deixados em branco para não mostrar dados relacionados a esse parâmetro. Se o parâmetro do usuário for deixado em branco, por exemplo, então o relatório não mostra nenhum nome de usuário e mostra informações relacionadas apenas ao nível de responsabilidade. Exemplo: Para mostrar a todos os usuários que têm acesso ao formulário de manutenção do usuário, digite os parâmetros a seguir: Nome do usuário: % Nome do formulário de usuário: Definir usuário da aplicação Por favor, note que atualmente o SQL ainda não considera exclusões de menu, o que significa que ele não é 100% exato, pois funções excluídas ainda apareceriam no relatório. Por favor, insira parâmetros mais restritivos. RU FND Access Control Responsibilites and related data such as users, concurrent programs, menus, functions, forms, data access set and security profiles and associated ledgers and operating units. This report basically answers all system access related questions. It shows which users or responsibilities have acess to which functions, forms, concurrent programs, ledgers, operating units or inventory organizations. Depending on parameter selection, this report shows for example: - responsibilities and related menus and request groups - responsibilities, menus, included forms, functions and their full menu navigation path - users and their assigned active responsibilities - users, assigned responsibilities and the concurrent programs they have access to - concurrent programs and the responsibilities that they can be run from - forms or functions and the responsibilities and users that can access them - responsibilities and navigation paths to access a certain form or function from a given user - operating units that a particular responsibility or user has access to through MOAC security profiles or profile option 'MO: Operating Unit' The parameters 'User', 'Form', 'Function' and 'Concurrent Program' are optional and can either be populated to filter records for a particular value only or entered with % to show all values or left blank to not show data related to that parameter. If the user parameter is left blank for example, then the report does not show any user names and shows information related to responsibility level only. Example: To show all users having access to the user maintenance form, enter parameters as follows: User Name: % User Form Name: Define Application User Please note that the SQL currently doesn't consider menu exclusions yet, which means that it's not 100% accurate as excluded functions would still show up in the report. Пожалуйста, введите более ограничительные параметры. S FND Access Control Ansvar och relaterad data såsom användare, samtidiga program, menyer, funktioner, formulär, dataåtkomstuppsättning och säkerhetsprofiler och tillhörande huvudböcker och styrenheter. Denna rapport svarar i princip på alla systemåtkomstrelaterade frågor. Den visar vilka användare eller ansvarsområden som har tillgång till vilka funktioner, formulär, samtidiga program, huvudböcker, driftsenheter eller lagerorganisationer. Beroende på parameterval visar denna rapport till exempel: - Ansvar och relaterade menyer och förfrågningsgrupper - Ansvar, menyer, inkluderade formulär, funktioner och deras fullständiga navigeringsväg - användare och deras tilldelade aktiva ansvar - användare, tilldelade ansvarsområden och de samtidiga program de har tillgång till - samtidiga program och det ansvar de kan köras från - formulär eller funktioner och ansvar och användare som kan komma åt dem - Ansvar och navigeringsvägar för att komma åt en viss form eller funktion från en given användare - manövreringsenheter som ett särskilt ansvar eller en användare har tillgång till genom MOAC-säkerhetsprofiler eller profilalternativet "MO: operativ enhet" Parametrarna 'Användare', 'Form', 'Funktion' och 'Samtidigt program' är valfria och kan antingen fyllas i för att endast filtrera poster för ett visst värde eller anges med% för att visa alla värden eller lämnas tomma för att inte visa data relaterade till den parametern. Om användarparametern lämnas tom till exempel, visar rapporten inga användarnamn och visar endast information relaterad till ansvarsnivå. Exempel: För att visa alla användare som har åtkomst till formuläret för användarunderhåll anger du parametrar enligt följande: Användarnamn: % Användarnas formulärnamn: Definiera applikationsanvändare Observera att SQL för närvarande inte beaktar menyundantag ännu, vilket innebär att det inte är 100% korrekt eftersom uteslutna funktioner fortfarande skulle visas i rapporten. Ange mer begränsande parametrar. TR FND Access Control Sorumluluklar ve kullanıcılar, eşzamanlı programlar, menüler, işlevler, formlar, veri erişim seti ve güvenlik profilleri ve ilgili defterler ve işletim birimleri gibi ilgili veriler. Bu rapor temelde sistem erişimiyle ilgili tüm soruları yanıtlar. Hangi kullanıcıların veya sorumlulukların hangi işlevlere, formlara, eşzamanlı programlara, defterlere, işletim birimlerine veya envanter organizasyonlarına erişimi olduğunu gösterir. Parametre seçimine bağlı olarak, bu rapor örneğin şunları gösterir: - sorumluluklar ve ilgili menüler ve talep grupları - sorumluluklar, menüler, dahil edilen formlar, işlevler ve bunların tam menü gezinme yolu - kullanıcılar ve atanmış aktif sorumlulukları - kullanıcılar, atanmış sorumluluklar ve erişim sahibi oldukları eşzamanlı programlar - eşzamanlı programlar ve çalıştırılabilecekleri sorumluluklar - formlar veya işlevler ve bunlara erişebilen sorumluluklar ve kullanıcılar - belirli bir kullanıcıdan belirli bir forma veya işleve erişmek için sorumluluklar ve gezinme yolları - MOAC güvenlik profilleri veya profil seçeneği 'MO: İşletim Birimi' aracılığıyla belirli bir sorumluluğun veya kullanıcının erişebildiği işletim birimleri 'Kullanıcı', 'Form', 'İşlev' ve 'Eşzamanlı Program' parametreleri isteğe bağlıdır ve yalnızca belirli bir değer için kayıtları filtrelemek için doldurulabilir veya tüm değerleri göstermek için% ile girilebilir veya ilgili verileri göstermemek için boş bırakılabilir. bu parametre. Örneğin kullanıcı parametresi boş bırakılırsa, rapor herhangi bir kullanıcı adı göstermez ve sadece sorumluluk seviyesiyle ilgili bilgileri gösterir. Örnek: Kullanıcı bakım formuna erişimi olan tüm kullanıcıları göstermek için parametreleri aşağıdaki gibi girin: Kullanıcı adı: % Kullanıcı Formu Adı: Uygulama Kullanıcısını Tanımlayın Lütfen SQL'in şu anda menü dışlamalarını dikkate almadığını unutmayın; bu, hariç tutulan işlevler raporda görünmeye devam edeceği için% 100 doğru olmadığı anlamına gelir. Lütfen daha kısıtlayıcı parametreler girin. US FND Responsibility Access Responsibilites and related data such as users, concurrent programs, menus, functions, forms, data access set and security profiles and associated ledgers and operating units. This report basically answers all system access related questions. It shows which users or responsibilities have acess to which functions, forms, concurrent programs, ledgers, operating units or inventory organizations. Depending on parameter selection, this report shows for example: - responsibilities and related menus and request groups - responsibilities, menus, included forms, functions and their full menu navigation path - users and their assigned active responsibilities - users, assigned responsibilities and the concurrent programs they have access to - concurrent programs and the responsibilities that they can be run from - forms or functions and the responsibilities and users that can access them - responsibilities and navigation paths to access a certain form or function from a given user - operating units that a particular responsibility or user has access to through MOAC security profiles or profile option 'MO: Operating Unit' The parameters 'User', 'Form', 'Function' and 'Concurrent Program' are optional and can either be populated to filter records for a particular value only or entered with % to show all values or left blank to not show data related to that parameter. If the user parameter is left blank for example, then the report does not show any user names and shows information related to responsibility level only. Example: To show all users having access to the user maintenance form, enter parameters as follows: User Name: % Form Name: FNDSCAUS Menu exclusions (fnd_resp_functions) are considered: functions excluded directly (rule_type F) or through an excluded menu (rule_type M) are filtered out. Please enter more restrictive parameters. ZHS FND Access Control 职责和相关数据，如用户、并发程序、菜单、功能、表单、数据访问集和安全配置文件以及相关的台账和操作单元。 该报告基本上回答了所有与系统访问相关的问题。它显示了哪些用户或职责可以访问哪些功能、表格、并发程序、分类账、操作单位或库存组织。 根据参数选择，该报告显示，例如： - 职责及相关菜单和请求组 - 职责、菜单、包含的表单、功能及其完整的菜单导航路径。 - 用户及其分配的主动责任 - 用户、分配的职责和他们可以访问的并发程序。 - 并发程序以及它们可以从以下地方运行的责任。 - 表格或功能，以及可以访问这些表格或功能的责任和用户。 - 职责和导航路径，以便从给定的用户访问某个表单或功能。 - 通过MOAC安全配置文件或配置文件选项 "MO"，特定职责或用户可以访问的操作单元。操作单元 用户"、"表格"、"功能 "和 "并发程序 "等参数是可选的，它们既可以被填入以过滤某个特定值的记录，也可以用%输入以显示所有值，或者留空以不显示与该参数相关的数据。例如，如果用户参数留空，则报告不显示任何用户名称，只显示与责任级别相关的信息。 例子：要显示所有有访问权限的用户的用户维护表，输入参数如下要显示所有有权限访问用户维护表的用户，输入参数如下。 用户名称。% 用户表名。定义应用程序用户 请注意，目前SQL还没有考虑菜单排除，这意味着它不是100%准确的，因为被排除的函数仍然会显示在报告中。 请输入更多限制性参数。 Enginatics R12 only &col1 &col2 &col_conc &expand_operating_units &show_concurrent &show_function &show_user 1=1 2=2 3=3 4=4 5=5 1 10 1=1 upper(frv.responsibility_name) like upper(:responsibility_name) LOV custom select frv.responsibility_name value, frv.description from ( select distinct furg.responsibility_application_id, furg.responsibility_id from ( select distinct fu.user_id from fnd_user fu where :$flex$.user_name_like is not null and :$flex$.user_name_like<>'%' and xxen_util.contains(:$flex$.user_name_like,fu.user_name)='Y' ) fu, fnd_user_resp_groups furg where fu.user_id=furg.user_id ) furg, fnd_responsibility_vl frv where furg.responsibility_application_id=frv.application_id and furg.responsibility_id=frv.responsibility_id union all select frv.responsibility_name, frv.description from fnd_responsibility_vl frv where :$flex$.user_name_like is null or :$flex$.user_name_like like '%\%%' escape '\' or :$flex$.user_name_like like '%\_%' escape '\' order by value F Nom de la responsabilité comme US Responsibility Name like 2 20 3=3 upper(fu.user_name) like upper(:user_name) LOV FND User Name (wildcard, active) 8E2FF36EDEB179D2E0530100007F1FF2 Y select fu.user_name value, coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address ) description from fnd_user fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf where trunc(sysdate) between fu.start_date and nvl(fu.end_date,sysdate) and fu.employee_id=papf.person_id(+) order by fu.user_name select fu.user_name from fnd_user fu where fu.user_id=fnd_global.user_id F Nom d'utilisateur comme US User Name like 3 &col1 z.user_name, z.email, z.person, z.person_bg, F Nom d'utilisateur comme US User Name like 4 &show_user Y F Nom d'utilisateur comme US User Name like 5 1=1 frv.responsibility_id=usr.responsibility_id and frv.application_id=usr.responsibility_application_id F Nom d'utilisateur comme US User Name like 6 30 1=1 fav.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 7 40 1=1 (frv.application_id, frv.responsibility_id) in (select oav.resp_application_id, oav.responsibility_id from org_access_view oav where oav.organization_code=:organization_code) LOV INV Organization Code (all) 8E2FF36EDEA279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code F Accès à l'inventaire Org US Access to Inventory Org 8 50 5=5 z.operating_unit like '%'||:operating_unit||'%' LOV HR Operating Unit (all) 8E2FF36EDE8879D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by hou.name F Accès à l'unité opérationnelle US Access to Operating Unit 9 55 5=5 z.legal_entity like '%'||:legal_entity||'%' LOV custom Y select xfi.name value, xfi.legal_entity_identifier description from xle_firstparty_information_v xfi where (:$flex$.operating_unit is null or xfi.legal_entity_id in (select hou.default_legal_context_id from hr_operating_units hou, hr_all_organization_units_vl haouv where hou.organization_id=haouv.organization_id and xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or xfi.legal_entity_id in (select glcd.object_id from gl_ledger_config_details glcd, gl_ledgers gl where glcd.configuration_id=gl.configuration_id and glcd.object_type_code='LEGAL_ENTITY' and glcd.setup_step_code='NONE' and xxen_util.contains(:$flex$.ledger,gl.name)='Y')) order by xfi.name US Access to Legal Entity 10 60 5=5 z.ledger like '%'||:ledger||'%' LOV GL Ledger (all) A95C471001B20DD1E0530100007FBF83 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and gl.object_type_code='L' and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, decode(gl.ledger_category_code,'NONE',1,'PRIMARY',2,'SECONDARY',3,'ALC',4), gl.name US Access to Ledger 11 70 1=1 (frgu.request_unit_id, frgu.unit_application_id, frgu.request_unit_type) in ( select fcpv.concurrent_program_id, fcpv.application_id, 'P' from fnd_concurrent_programs_vl fcpv where upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name) and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' union all select fcpv.application_id, fcpv.application_id, 'A' from fnd_concurrent_programs_vl fcpv where upper(fcpv.user_concurrent_program_name) like upper(:user_concurrent_program_name) and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' ) LOV FND Concurrent Program Name (SRS enabled only) 8E2FF36EDE8279D2E0530100007F1FF2 select fcpv.user_concurrent_program_name value, fav.application_name||nvl2(fcpv.description,': ',null)||fcpv.description description from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv where fcpv.application_id=fav.application_id and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' order by fcpv.user_concurrent_program_name F Nom du programme concomitant comme US Concurrent Program Name like 12 &col2 z.conc_program_code, F Nom du programme concomitant comme US Concurrent Program Name like 13 &col_conc z.concurrent_program, z.execution_method, z.execution_file_name, z.assignment_type, z.assignment_name, F Nom du programme concomitant comme US Concurrent Program Name like 14 &show_concurrent Y F Nom du programme concomitant comme US Concurrent Program Name like 15 4=4 upper(fcpv2.user_concurrent_program_name) like upper(:user_concurrent_program_name) F Nom du programme concomitant comme US Concurrent Program Name like 16 80 1=1 (frgu.request_unit_id, frgu.unit_application_id, frgu.request_unit_type) in ( select fcpt.concurrent_program_id, fcpt.application_id, 'P' from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt where fcp.application_id=fcpt.application_id and fcp.concurrent_program_id=fcpt.concurrent_program_id and fcpt.user_concurrent_program_name=:user_conc_name_all_languages and fcp.srs_flag in ('Y','Q') and fcp.enabled_flag='Y' union all select fcpt.application_id, fcpt.application_id, 'A' from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt where fcp.application_id=fcpt.application_id and fcp.concurrent_program_id=fcpt.concurrent_program_id and fcpt.user_concurrent_program_name=:user_conc_name_all_languages and fcp.srs_flag in ('Y','Q') and fcp.enabled_flag='Y' ) LOV FND Concurrent Program Name (all languages) 8E2FF36EDEB079D2E0530100007F1FF2 Y select fcpt.user_concurrent_program_name value, '('||fcpt.language||') '||fav.application_name||nvl2(fcpt.description,': ',null)||fcpt.description description from fnd_application_vl fav, fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt where fcp.application_id=fav.application_id and fcp.srs_flag in ('Y','Q') and fcp.enabled_flag='Y' and fcp.application_id=fcpt.application_id and fcp.concurrent_program_id=fcpt.concurrent_program_id and fcpt.language=fcpt.source_lang order by fcpt.user_concurrent_program_name US Concurrent Progr. (all languages) 17 &col2 z.conc_program_code, US Concurrent Progr. (all languages) 18 &col_conc z.concurrent_program, z.assignment_type, z.assignment_name, US Concurrent Progr. (all languages) 19 &show_concurrent Y US Concurrent Progr. (all languages) 20 4=4 fcpv2.user_concurrent_program_name in ( select fcpt.user_concurrent_program_name from fnd_concurrent_programs_tl fcpt0, fnd_concurrent_programs_tl fcpt where fcpt0.user_concurrent_program_name=:user_conc_name_all_languages and fcpt0.application_id=fcpt.application_id and fcpt0.concurrent_program_id=fcpt.concurrent_program_id and fcpt.language=userenv('lang') ) US Concurrent Progr. (all languages) 21 90 1=1 (frgu.request_unit_id, frgu.unit_application_id, frgu.request_unit_type) in ( select fcpv.concurrent_program_id, fcpv.application_id, 'P' from fnd_concurrent_programs_vl fcpv where upper(fcpv.concurrent_program_name) like upper(:concurrent_program_name) and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' union all select fcpv.application_id, fcpv.application_id, 'A' from fnd_concurrent_programs_vl fcpv where upper(fcpv.concurrent_program_name) like upper(:concurrent_program_name) and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' ) LOV FND Concurrent Program Short Name (SRS enabled only) 8E2FF36EDEA079D2E0530100007F1FF2 Y select fcpv.concurrent_program_name value, fav.application_name||': '||fcpv.user_concurrent_program_name description from fnd_application_vl fav, fnd_concurrent_programs_vl fcpv where fav.application_id=fcpv.application_id and fcpv.srs_flag in ('Y','Q') and fcpv.enabled_flag='Y' order by fcpv.concurrent_program_name F Programme concomitant Nom court US Concurrent Program Short Name 22 &col2 z.conc_program_code, F Programme concomitant Nom court US Concurrent Program Short Name 23 &col_conc z.concurrent_program, z.assignment_type, z.assignment_name, F Programme concomitant Nom court US Concurrent Program Short Name 24 &show_concurrent Y F Programme concomitant Nom court US Concurrent Program Short Name 25 4=4 upper(fcpv2.concurrent_program_name) like upper(:concurrent_program_name) F Programme concomitant Nom court US Concurrent Program Short Name 26 100 1=1 frg.request_group_name=:request_group LOV FND Request Group 8E2FF36EDE8F79D2E0530100007F1FF2 Y select frg.request_group_name value, frg.description from fnd_request_groups frg where (:$flex$.fnd_application_name is null or frg.application_id in (select fav.application_id from fnd_application_vl fav where fav.application_name=:$flex$.fnd_application_name)) order by frg.request_group_name F Groupe de demande US Request Group 27 110 2=2 ( upper(fffv.user_function_name) like upper(:menu_entry) or upper(fffv.function_name) like upper(:menu_entry) or upper(ffv.user_form_name) like upper(:menu_entry) or upper(ffv.form_name) like upper(:menu_entry) ) Char F Entrée de menu comme Recherche par joker pour les noms de fonctions et de formulaires (à la fois, interne et système) US Menu Entry like Wildcard search for function and form names (both, internal and system) 28 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Entrée de menu comme US Menu Entry like 29 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Entrée de menu comme US Menu Entry like 30 &show_function Y F Entrée de menu comme US Menu Entry like 31 1=1 frv.menu_id=fcmf.menu_id F Entrée de menu comme US Menu Entry like 32 120 2=2 upper(fffv.user_function_name) like upper(:user_function_name) LOV FND User Function Name (wildcard) 8E2FF36EDEBC79D2E0530100007F1FF2 select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where 1=1 and fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.user_function_name F Nom de la fonction utilisateur comme US User Function Name like 33 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Nom de la fonction utilisateur comme US User Function Name like 34 &col2 z.menu_path, z.function_name, z.function_id, z.form_name, z.parameters, F Nom de la fonction utilisateur comme US User Function Name like 35 &show_function Y F Nom de la fonction utilisateur comme US User Function Name like 36 1=1 frv.menu_id=fcmf.menu_id F Nom de la fonction utilisateur comme US User Function Name like 37 130 2=2 fffv.function_name=:function_name LOV FND Function Name 8E2FF36EDEBB79D2E0530100007F1FF2 Y select fffv.function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.function_name F Nom de la fonction US Function Name 38 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Nom de la fonction US Function Name 39 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Nom de la fonction US Function Name 40 &show_function Y F Nom de la fonction US Function Name 41 1=1 frv.menu_id=fcmf.menu_id F Nom de la fonction US Function Name 42 140 2=2 upper(ffv.user_form_name) like upper(:user_form_name) LOV FND User Form Name (wildcard) 8E2FF36EDEBA79D2E0530100007F1FF2 select ffv.user_form_name value, fav.application_name||': '||ffv.form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.user_form_name F Nom du formulaire de l'utilisateur comme US User Form Name like 43 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Nom du formulaire de l'utilisateur comme US User Form Name like 44 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Nom du formulaire de l'utilisateur comme US User Form Name like 45 &show_function Y F Nom du formulaire de l'utilisateur comme US User Form Name like 46 1=1 frv.menu_id=fcmf.menu_id F Nom du formulaire de l'utilisateur comme US User Form Name like 47 150 2=2 ffv.form_name=:form_name LOV FND Form Name 8E2FF36EDEA779D2E0530100007F1FF2 Y select ffv.form_name value, fav.application_name||': '||ffv.user_form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.form_name F Nom du formulaire US Form Name 48 &col1 z.navigation_path, z.user_function_name, z.function_type, z.user_form_name, z.html_call, F Nom du formulaire US Form Name 49 &col2 z.menu_path, z.function_name, z.form_name, z.parameters, F Nom du formulaire US Form Name 50 &show_function Y F Nom du formulaire US Form Name 51 1=1 frv.menu_id=fcmf.menu_id F Nom du formulaire US Form Name 52 160 1=1 fmv.user_menu_name=:user_menu_name LOV FND User Menu Name 8E2FF36EDE8B79D2E0530100007F1FF2 Y select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name F Nom du menu utilisateur US User Menu Name 53 170 1=1 fmv.menu_name=:menu_name LOV FND Menu Name 8E2FF36EDE9379D2E0530100007F1FF2 Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name F Nom du menu US Menu Name 54 180 1=1 frv.application_id>=20000 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Custom Application Responsibilities 55 190 &expand_operating_units Y LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y F Étendre les unités d'exploitation multiples US Expand Multiple Operating Units :$flex$.fnd_application_name Application Request Group :$flex$.user_name_like User Name like Responsibility Name like