Blitz Report Template Sharing

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Lists the sharing records for Blitz Report templates - who each template is shared with at Site, Responsibility or User level.

For a Responsibility-level share the Shared With column shows the responsibility name and the Application column shows its owning application; for a User-level share it shows the user name; a Site-level share is available to everyone.

For Responsibility-level ...  Lists the sharing records for Blitz Report templates - who each template is shared with at Site, Responsibility or User level.

For a Responsibility-level share the Shared With column shows the responsibility name and the Application column shows its owning application; for a User-level share it shows the user name; a Site-level share is available to everyone.

For Responsibility-level shares the Menu Name column shows the responsibility's menu and Blitz Report Menu Entries counts the Blitz Report menu functions already on that menu (blank when none). A blank Blitz Report Menu Entries with a shared template flags a responsibility whose menu is still missing the Blitz Report function - run the Update Menu Entries program to add it.

Use the Report Name, Template Name and Sharing Level parameters to narrow the list.   more 
select
xrv.report_name,
xrv.type_dsp type,
xrv.category,
xrtsv.template_name,
xrtsv.sharing_level_desc sharing_level,
xrtsv.level_value shared_with,
fav.application_name,
fm.menu_name,
xxen_util.zero_to_null((select count(*) from fnd_menu_entries fme where fme.menu_id=fr.menu_id and fme.function_id in (select fff.function_id from fnd_form_functions fff where fff.function_name in ('XXEN_REPORTS','XXEN_REPORTS_WEB')))) blitz_report_menu_entries,
xxen_util.user_name(xrtsv.created_by) created_by,
xxen_util.client_time(xrtsv.creation_date) creation_date,
xxen_util.user_name(xrtsv.last_updated_by) last_updated_by,
xxen_util.client_time(xrtsv.last_update_date) last_update_date
from
xxen_report_template_sharing_v xrtsv,
xxen_report_templates xrt,
xxen_reports_v xrv,
fnd_application_vl fav,
fnd_responsibility fr,
fnd_menus fm
where
1=1 and
xrtsv.template_id=xrt.template_id and
xrt.report_id=xrv.report_id and
xrtsv.id2=fav.application_id(+) and
decode(xrtsv.sharing_level,'R',xrtsv.id1)=fr.responsibility_id(+) and
decode(xrtsv.sharing_level,'R',xrtsv.id2)=fr.application_id(+) and
fr.menu_id=fm.menu_id(+)
order by
xrv.report_name,
xrtsv.template_name,
decode(xrtsv.sharing_level,'S',1,'R',2,'U',3),
xrtsv.level_value
Parameter NameSQL textValidation
Report Name
xrv.report_name=:report_name
LOV
Template Name
xrtsv.template_name=:template_name
LOV
Sharing Level
xrtsv.sharing_level=:sharing_level
LOV
Download
Related Blitz Reports
Blitz Report Assignments and Responsibilities FND Responsibility Access Blitz Reports FND Responsibility Access 11i Blitz Report Template Sharing Upload FND Menu Entries CAC Interface Error Summary FND Responsibility Menu Exclusions FND User Login Page Favorites
Blitz Report™