Blitz Report Template Sharing – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Blitz Report · all Blitz Report reports

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.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

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, 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

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

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

Case Study & Technical Analysis: Blitz Report Template Sharing

Executive Summary

The Blitz Report Template Sharing report lists who each Blitz Report™ template is shared with, at Site, Responsibility or User level, and who owns it. It serves two audiences. Administrators use the default view to review sharing across the template library and to find responsibilities whose menus lack the Blitz Report function. Support staff use the user view to answer one question: which templates can this EBS user actually run, and through which access path. The report reflects the same report-access rules as the run screen, so a template is not shown as usable if its underlying report is not assigned to that user.

Business Challenge

The Solution

Technical Architecture (High Level)

Primary Tables

Logical Relationships

  1. A common table expression lists the responsibilities of the selected user, from role assignments matched to responsibilities whose menus carry the Blitz Report function.
  2. Each sharing row is joined to its template, the template’s report, and the report’s catalogue entry.
  3. For responsibility shares, the responsibility, its application and its menu are outer joined, and the Blitz Report menu entry count is taken from FND_MENU_ENTRIES.
  4. In user mode, the rows are limited to shares the user can use: site shares, responsibility shares held directly or indirectly, user shares, and templates the user owns with no share reaching them.
  5. Each row is then kept only if a matching include assignment exists and no exclude assignment applies to the user.

Parameters & Filtering

Performance & Optimization

FAQ

Q: How do I find which templates a specific user can use? A: Enter the user name in Assigned to User. The report lists one row per access path, and the Assigned To User Via column names the level for each row.

Q: Why does a responsibility show a blank Blitz Report Menu Entries count? A: A blank count on a responsibility with a shared template means its menu has no Blitz Report menu function, and the Update Menu Entries program should be run to add it.

Q: Can a user see a template that is shared with them if the report is not assigned to them? A: No. In user mode the report applies the same report-access rules as the run screen, so such a template is not listed.

© Enginatics GmbH