Blitz Report Template Sharing – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Lists the sharing records for Blitz Report templates - who each template is shared with at Site, Responsibility or User level. The Owner column shows the user who owns each template.

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.

Set the Assigned to EBS User parameter to a user to answer “which templates can this user actually use, and how”. The report then shows one row per access path - a Site share (available to everyone), each Responsibility share on a responsibility the user holds, a direct User share, or ownership - but ONLY for reports the user is allowed to run: it applies the same report-access reach as the run screen (Site, Application, Request Group, Responsibility and User assignments), so a template shared with the user whose report is not assigned to the user is not listed (the user could not run it). The Assigned To User Via column names the level for that row (for example “Responsibility (AP Manager)” or “Owner”); the per-share administrative columns are blank in this mode.

Use the Report Name, Category, Template Name, Template Owner and Sharing Level parameters to narrow the list - for example set Category to Discoverer to pull the templates of all Discoverer reports, or Template Owner to list one user’s templates. The Template Name list is filtered to the selected Report Name when one is chosen.

Report Parameters

Report Name, Category, Template Name, Template Owner, Sharing Level, Assigned to User

Oracle EBS Tables Used

fnd_application, wf_user_role_assignments, fnd_responsibility, fnd_form_functions, fnd_compiled_menu_functions, fnd_menu_entries, xxen_report_template_sharing_v, xxen_report_templates, xxen_reports_v, fnd_application_vl, fnd_menus, fnd_user, fnd_user_resp_groups_direct, fnd_user_resp_groups_indirect, xxen_report_assignments, user_resps, xxen_report_assignment_users

Report Categories

Enginatics

Blitz Report Assignments and Responsibilities, FND Responsibility Access, FND User Login Page Favorites, Blitz Reports, FND Menu Entries, FND Responsibility Upload, FND Forms Personalizations

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output
Blitz Report™ XML Import Blitz_Report_Template_Sharing.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-template-sharing/

© 2026 Enginatics