ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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. B2998B7D582438F7E0530100007F1BBB RWB Report Name Y select rr.report_name value, rr.description from xxfo.rx_reports rr order by rr.report_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B5DBCD4936680723E0530100007F88DE select rrs.stat_id, xxen_util.user_name(rrs.user_id) user_name, frv.responsibility_name responsibility, decode(rrs.report_id,-1,'output generation ('||rrs.output_type||')',rr.report_name) report_name, decode(rr.report_type,'USER','Adhoc','SEEDED','Seeded Adhoc','DASH_BOARD','BI Publisher','VAR','PL/SQL Custom','FLEX','Dashboard','SEEDED_VAR','Seeded PL/SQL Custom',rr.report_type) report_type, y.view_name, y.view_alias, rrs.params_text, xxen_util.client_time(rrs.start_time) start_time, xxen_util.client_time(rrs.end_time_) end_time, xxen_util.time(rrs.seconds) time, rrs.seconds, rrs.row_count, rrs.row_count/xxen_util.zero_to_null(rrs.seconds) rows_second, rrs.run_type, rrs.output_type, rr.report_type, rrs.error_stack, decode(rrs.report_id,-1,null,rrs.report_id) report_id, y.view_id, y.view_count, decode(rrs.template_id,-1,null,rrs.template_id) template_id, rrs.user_id from (select (nvl(nvl2(rrs.row_count,rrs.end_time,null),sysdate)-rrs.start_time)*86400 seconds, nvl2(rrs.row_count,rrs.end_time,null) end_time_, rrs.* from rx_report_stats rrs) rrs, rx_reports rr, fnd_responsibility_vl frv, ( select distinct x.report_id, listagg(rv.view_name,', ') within group (order by x.view_id) over (partition by x.report_id) view_name, listagg(rv.view_alias,', ') within group (order by x.view_id) over (partition by x.report_id) view_alias, listagg(x.view_id,',') within group (order by x.view_id) over (partition by x.report_id) view_id, count(x.view_id) over (partition by x.report_id) view_count from ( select distinct rrc.report_id, rvc.view_id from rx_report_columns rrc, rx_view_columns rvc where rrc.view_column_id=rvc.view_column_id ) x, rx_views rv where x.view_id=rv.view_id ) y where 1=1 and rrs.report_id=rr.report_id(+) and rrs.responsibility_id=frv.responsibility_id(+) and rrs.application_id=frv.application_id(+) and rrs.report_id=y.report_id(+) order by rrs.start_time desc, rrs.stat_id desc Y US RWB Execution History Execution history of Polaris Reporting Workbench reports. This can be used when migrating from Polaris Reporting Workbench to Blitz Report, to analyze which Polaris reports were previously used by the business. RWB 1=1 1 10 1=1 upper(rr.report_name) like upper(:report_name) LOV RWB Report Name B2998B7D582438F7E0530100007F1BBB Y select rr.report_name value, rr.description from xxfo.rx_reports rr order by rr.report_name F Nom du rapport US Report Name 2 20 1=1 rrs.user_id=xxen_util.user_id(:created_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 F Soumis par l'utilisateur US Submitted by User 3 30 1=1 rrs.start_time>sysdate-:days Number 90 F Commencé en quelques jours US Started within Days 4 40 1=1 rrs.start_time>=:start_date_from DateTime F Date de début de US Start Date From 5 50 1=1 rrs.start_time<=:start_date_to DateTime F Date de début au US Start Date To 6 60 1=1 rrs.run_type=:run_type LOV custom Y select 'BI Publisher' value, null description from dual union all select 'Dashboard' value, null description from dual union all select 'Excel/Pivot Excel' value, null description from dual union all select 'Pivot Online' value, null description from dual union all select 'RWB Conc Program' value, null description from dual union all select 'RWB Excel Publisher' value, null description from dual union all select 'Tabular' value, null description from dual union all select 'View Output' value, null description from dual F Type de course US Run Type 7 70 1=1 rrs.report_id>0 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Exclure la génération de sortie US Exclude output generation