ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B88A54A6DFBFC53FE0530100007F0EBC FND Role Code Y select wlr.name value, nvl(wlrt.display_name,wlr.display_name) description from wf_local_roles wlr, wf_local_roles_tl wlrt where wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') order by wlr.name US B88A54A6DFC0C53FE0530100007F0EBC FND Role Name Y select decode(wlr.orig_system,'FND_RESP',frv.responsibility_name,nvl(wlrt.display_name,wlr.display_name)) value, decode(wlr.orig_system,'FND_RESP',fnd_message.get_string('FND','W3H_RESPONSIBILITY_ROLETYPE'),fnd_message.get_string('FND','W3H_ROLE_ROLETYPE'))||': '||wlr.name||case when sysdate>wlr.expiration_date then ' ('||xxen_util.meaning('I','ACTIVE_INACTIVE',3)||')' end description from wf_local_roles wlr, wf_local_roles_tl wlrt, fnd_responsibility_vl frv where wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') and wlr.partition_id=wlrt.partition_id(+) and wlr.orig_system_id=frv.responsibility_id(+) order by value 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. 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B87AC3D9B9D59622E0530100007F2695 select x.* from ( select xxen_util.user_name(wlur.user_name) user_name, decode(wlur.role_orig_system,'FND_RESP',frv.responsibility_name,nvl(wlrt.display_name,wlr.display_name)) role_name, wlr.name role_code, decode(wlur.role_orig_system,'FND_RESP',fnd_message.get_string('FND','W3H_RESPONSIBILITY_ROLETYPE'),fnd_message.get_string('FND','W3H_ROLE_ROLETYPE')) role_type, decode(wlur.assignment_type,'D',fnd_message.get_string('FND','W3H_DIRECT_ASSIGNMENTTYPE'),'I',fnd_message.get_string('FND', 'W3H_INDIRECT_ASSIGNMENTTYPE'),'B',fnd_message.get_string('FND','W3H_BOTH_ASSIGNMENTTYPE')) assignment_type, decode(umx_w3h_utl.isfunctionaccessible(wlur.user_name,wlur.role_name),'true',fnd_message.get_string('FND','W3H_SHOW_ACTIVE_FUNCTIONS'),fnd_message.get_string('FND','W3H_SHOW_INACTIVE_FUNCTIONS')) assignment_status, ( select decode(wlr.orig_system,'FND_RESP',frv.responsibility_name,nvl(wlrt.display_name,wlr.display_name)) assigning_role_name from wf_local_roles wlr0, wf_local_roles_tl wlrt0, fnd_responsibility_vl frv0 where nullif(wura.assigning_role,wlr.name)=wlr0.name and wlr0.orig_system in ('UMX','FND_RESP') and wlr0.name=wlrt0.name(+) and wlr0.orig_system=wlrt0.orig_system(+) and wlr0.orig_system_id=wlrt0.orig_system_id(+) and wlrt0.language(+)=userenv('lang') and wlr0.partition_id=wlrt0.partition_id(+) and wlr0.orig_system_id=frv0.responsibility_id(+) ) assigning_role_name, nullif(wura.assigning_role,wlr.name) assigning_role_code, wura.effective_start_date, wura.effective_end_date, wura.role_start_date, wura.role_end_date, xxen_util.user_name(wura.created_by) assigned_by, wura.assignment_reason from wf_local_user_roles wlur, wf_user_role_assignments wura, fnd_responsibility_vl frv, wf_local_roles wlr, wf_local_roles_tl wlrt where 1=1 and wlur.role_orig_system in ('UMX','FND_RESP') and wlur.role_orig_system_id=frv.responsibility_id(+) and wlur.role_name=wlr.name and wlr.orig_system in ('UMX','FND_RESP') and wlur.user_name=wura.user_name and wlur.role_name=wura.role_name and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') and wlr.partition_id=wlrt.partition_id(+) ) x where 2=2 order by x.user_name, x.role_name Y AR FND User Roles تقرير لأدوار إدارة المستخدم (UMX) والمستخدمين المعينين لإدارة التحكم في الوصول المستند إلى الدور (RBAC) D FND User Roles Report for User Management (UMX) Rollen und die ihnen zugewiesenen Benutzer zur Verwaltung der rollenbasierten Zugriffskontrolle (RBAC) E FND User Roles Informe para la gestión de usuarios (UMX) roles y sus usuarios asignados para gestionar el control de acceso basado en roles (RBAC) F FND User Roles Rapport pour les rôles de gestion des utilisateurs (UMX) et les utilisateurs qui leur sont assignés pour gérer le contrôle d'accès basé sur les rôles (RBAC) I FND User Roles Rapporto per i ruoli di gestione degli utenti (UMX) e i loro utenti assegnati per gestire il controllo di accesso basato sui ruoli (RBAC) JA FND User Roles ロールベースのアクセス制御（RBAC）を管理するためのユーザー管理（UMX）ロールとその割り当てられたユーザーのレポート KO FND User Roles RBAC (역할 기반 액세스 제어)를 관리하기 위해 사용자 관리 (UMX) 역할 및 할당 된 사용자에 대한 보고서 PTB FND User Roles Relatório para funções de Gerenciamento de Usuários (UMX) e seus usuários designados para gerenciar o controle de acesso baseado em funções (RBAC) RU FND User Roles Отчет для ролей управления пользователями (UMX) и их назначенных пользователей для управления доступом на основе ролей (RBAC). S FND User Roles Rapportera för UMX-roller (User Management) och deras tilldelade användare för att hantera rollbaserad åtkomstkontroll (RBAC) TR FND User Roles Rol tabanlı erişim denetimini (RBAC) yönetmek için Kullanıcı Yönetimi (UMX) rolleri ve bunların atanmış kullanıcıları için rapor US FND User Roles Report for User Management (UMX) roles and their assigned users to manage role-based access control (RBAC). User uoles are maintained from the User Management responsibility, but you would require the UMX|SECURITY_ADMIN role for this. If you do not have this role but apps DB access, you can add it from the backend: begin wf_local_synch.propagateuserrole( p_user_name=>'ANDY.HAACK', p_role_name=>'UMX|SECURITY_ADMIN' ); commit; end; ZHS FND User Roles 为用户管理（UMX）角色及其分配的用户提供报告，以管理基于角色的访问控制（RBAC）。 Enginatics R12 only 1=1 2=2 1 10 1=1 wlur.user_name=:user_name 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 F Nom de l'utilisateur US User Name 2 20 2=2 x.role_name=:role_name LOV FND Role Name B88A54A6DFC0C53FE0530100007F0EBC Y select decode(wlr.orig_system,'FND_RESP',frv.responsibility_name,nvl(wlrt.display_name,wlr.display_name)) value, decode(wlr.orig_system,'FND_RESP',fnd_message.get_string('FND','W3H_RESPONSIBILITY_ROLETYPE'),fnd_message.get_string('FND','W3H_ROLE_ROLETYPE'))||': '||wlr.name||case when sysdate>wlr.expiration_date then ' ('||xxen_util.meaning('I','ACTIVE_INACTIVE',3)||')' end description from wf_local_roles wlr, wf_local_roles_tl wlrt, fnd_responsibility_vl frv where wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') and wlr.partition_id=wlrt.partition_id(+) and wlr.orig_system_id=frv.responsibility_id(+) order by value F Nom du rôle US Role Name 3 30 1=1 wlr.name=:role_code LOV FND Role Code B88A54A6DFBFC53FE0530100007F0EBC Y select wlr.name value, nvl(wlrt.display_name,wlr.display_name) description from wf_local_roles wlr, wf_local_roles_tl wlrt where wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') order by wlr.name F Code de rôle US Role Code 4 40 1=1 umx_w3h_utl.isfunctionaccessible(wlur.user_name,wlur.role_name)='true' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Actif uniquement US Active only