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. B29A78367A174C9BE0530100007FD3E8 RWB View Name Y select rv.db_view_name value, rv.view_name||nvl2(rv.description,' ('||rv.description||')',null) description from xxfo.rx_views rv order by rv.db_view_name US Polaris Reporting Workbench database view name BC8FA829113A2D68E053B86B6358B2DD select distinct decode(count(distinct y.report_id) over (partition by y.view_ids),1,rr.report_name,'<multiple>') report_name, y.views, y.db_views, count(*) over (partition by y.view_ids) execution_count, count(distinct y.report_id) over (partition by y.view_ids) report_count, count(distinct rrs.user_id) over (partition by y.view_ids) user_count, y.view_ids from ( select distinct x.report_id, listagg(rv.view_alias,', ') within group (order by rv.view_alias) over (partition by x.report_id) views, listagg(rv.db_view_name,', ') within group (order by rv.view_alias) over (partition by x.report_id) db_views, listagg(x.view_id,',') within group (order by x.view_id) over (partition by x.report_id) view_ids 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 2=2 and x.view_id=rv.view_id ) y, rx_report_stats rrs, rx_reports rr where y.report_id=rrs.report_id and y.report_id=rr.report_id and 1=1 order by execution_count desc, y.views Y US RWB Execution Summary Execution history of Polaris Reporting Workbench reports, summarized by combination of accessed views, similar to the Blitz Report import menu option LOV. This can be used when migrating from Polaris Reporting Workbench to Blitz Report, to analyze which Polaris view were previously used by the business RWB 1=1 2=2 1 10 2=2 rv.db_view_name=:db_view_name LOV RWB View Name B29A78367A174C9BE0530100007FD3E8 Y select rv.db_view_name value, rv.view_name||nvl2(rv.description,' ('||rv.description||')',null) description from xxfo.rx_views rv order by rv.db_view_name F Nom de vue US View 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 365 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