Blitz Report Assignments and Responsibilities – 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 all responsibilities, users, and the bitz reports that they can access, presumed they have their Blitz Report Access profile option set to ‘User’

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

Responsibility Name, Report Name, Category, User Name, Show Users

Oracle EBS Tables Used

fnd_profile_option_values, fnd_profile_options, fnd_user_resp_groups, fnd_user, fnd_responsibility, fnd_form_functions, fnd_compiled_menu_functions, xxen_report_assignments, xxen_report_assignment_users, xxen_reports_v, fnd_responsibility_vl, fnd_application_vl

Report Categories

Enginatics

Blitz Report Template Sharing, FND Responsibility Access, INV Item Upload, FND User Login History, FND Responsibilities, FND Forms Personalizations, INV Item Upload 11i

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 Blitz Report Assignments and Responsibilities 14-Oct-2023 123917.xlsx
Blitz Report™ XML Import Blitz_Report_Assignments_and_Responsibilities.xml
SQL Source Blitz Report Assignments and Responsibilities.sql
Full Report on Enginatics www.enginatics.com/reports/blitz-report-assignments-and-responsibilities/

Blitz Report Assignments and Responsibilities - Case Study & Technical Analysis

Executive Summary

Blitz Report Assignments and Responsibilities is a security matrix report. Unlike the standard “Assignments” report which lists the rules defined in the system, this report explodes those rules to show the effective access for every user. It answers the question: “Which users can run which reports, and through which responsibilities?”

Business Challenge

Solution

This report joins the Blitz Report assignment rules with the Oracle EBS User and Responsibility tables (FND_USER, FND_USER_RESP_GROUPS). It provides a flattened view of access rights.

Technical Architecture

This report performs a complex join between the Blitz Report security model and the Oracle FND security model.

Key Tables & Joins

Logic

  1. Identify Assignments: Finds all active report assignments.
  2. Expand Responsibilities: For responsibility-level assignments, it finds all valid users who hold that responsibility within the active date range.
  3. Profile Check: It verifies that the user has the necessary profile options enabled to access the Blitz Report form.

Parameters

FAQ

Q: Why does a user appear in this report but cannot see the report in Oracle? A: Check the “Effective Dates” on their responsibility assignment. Also, ensure the Blitz Report Access profile option is set correctly for that user or responsibility.

Q: Does this include “Site” level assignments? A: Yes, if a report is assigned at the Site level, it is technically available to all users, and this report should reflect that breadth of access.

© Enginatics GmbH