Blitz Report Access Upload – Oracle EBS SQL Report

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

Overview

Upload to update value for profile option ‘Blitz Report Access’ at user or responsibility level.

Someone having this upload assigned, can maintain the profile option values for other users or responsibilities up to their own access level. He could, for example, set the value to ‘User’ for other users, but not to anything higher, such as ‘Developer’. Someone with Developer access could set the value for other users and developers, but not to the highest level ‘System’.

Report Parameters

Level, Value

Oracle EBS Tables Used

fnd_profile_options_vl, fnd_profile_option_values, fnd_user, fnd_responsibility_vl, fnd_application_vl

Report Categories

Enginatics, Upload

FND Responsibilities, FND Concurrent Requests, FND Responsibility Access, FND Profile Option Values, Blitz Report Assignments and Responsibilities, FND Profile Options

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 Access Upload 25-Apr-2024 060349.xlsm
Blitz Report™ XML Import Blitz_Report_Access_Upload.xml
Full SQL on Enginatics www.enginatics.com/reports/blitz-report-access-upload/

Blitz Report Access Upload - Case Study & Technical Analysis

Executive Summary

The Blitz Report Access Upload is an administrative utility designed to streamline the management of user access rights within the Blitz Report framework. It allows authorized administrators to bulk-update the Blitz Report Access profile option for multiple users or responsibilities via an Excel upload. This tool is essential for maintaining security and governance in large environments where managing access one-by-one is inefficient.

Business Challenge

Controlling who can create, edit, or run reports is critical for system security and performance.

Solution

The Blitz Report Access Upload tool solves these challenges by:

Technical Architecture

The tool interacts with the standard Oracle FND Profile Option tables.

Key Tables & Joins

Logic

  1. Input: The user uploads an Excel sheet with columns for Level (User/Responsibility), Level Value (UserName/RespName), and Value (The access level to grant).
  2. Validation:
    • Checks if the target User/Responsibility exists.
    • Security Check: Verifies that the uploader’s own access level is greater than or equal to the level they are trying to grant. For example, a “Developer” cannot grant “System” access.
  3. Update: Uses standard FND APIs (e.g., FND_PROFILE.SAVE) to apply the changes safely.

Parameters

FAQ

Q: What are the different access levels? A: Typically: * User: Can run assigned reports. * Developer: Can create and edit SQL queries. * System: Full administrative control.

Q: Can I use this to remove access? A: Yes, by uploading a blank value or a specific “No Access” value, depending on the configuration.

Q: Is this safe? A: Yes, the tool enforces a hierarchy check. You cannot grant permissions higher than what you possess yourself, preventing unauthorized elevation of privileges.

© 2026 Enginatics