FND Responsibility Access 11i – Oracle EBS SQL Report

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

Overview

Responsibilites and related data such as users, concurrent programs, menus, functions, forms, data access set and security profiles and associated ledgers and operating units. This report basically answers all system access related questions. It shows which users or responsibilities have acess to which functions, forms, concurrent programs, ledgers, operating units or inventory organizations.

Depending on parameter selection, this report shows for example:

The parameters ‘User’, ‘Form’, ‘Function’ and ‘Concurrent Program’ are optional and can either be populated to filter records for a particular value only or entered with % to show all values or left blank to not show data related to that parameter. If the user parameter is left blank for example, then the report does not show any user names and shows information related to responsibility level only.

Example: To show all users having access to the user maintenance form, enter parameters as follows: User Name: % User Form Name: Define Application User

Please note that the SQL currently doesn’t consider menu exclusions yet, which means that it’s not 100% accurate as excluded functions would still show up in the report.

Report Parameters

Responsibility Name, User Name like, Application, Access to Inventory Org, Access to Operating Unit, Concurrent Program Name like, Concurrent Progr. (all languages), Concurrent Program Short Name, Request Group, Menu Entry like, User Function Name like, Function Name, User Form Name like, Form Name, User Menu Name, Menu Name, Expand Multiple Operating Units

Oracle EBS Tables Used

fnd_form_functions_vl, fnd_form_vl, fnd_menu_entries_vl, fnd_menus_tl, per_security_profiles, hr_operating_units, per_organization_list, hr_all_organization_units_vl, org_access_view, fnd_user_resp_groups, fnd_user, per_all_people_f, fnd_profile_option_values, fnd_application_vl, fnd_responsibility_vl, fnd_request_groups, fnd_request_group_units, fnd_concurrent_programs_vl, fnd_request_sets_vl, fnd_menus_vl, usr, fnd_compiled_menu_functions, func, nav, fnd_mo_product_init, prof, org

Report Categories

Enginatics

FND Responsibility Access, Blitz Report Assignments and Responsibilities, FND Responsibilities, FND User Login History, PA Revenue, Cost, Budgets by Resources, PA Revenue, Cost, Budgets by Work Breakdown Structure, AR Customer Upload, CAC Intercompany SO Price List vs. Item Cost Comparison, CAC Receiving Expense Value (Period-End)

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 None
Blitz Report™ XML Import FND_Responsibility_Access_11i.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-responsibility-access-11i/

Executive Summary

This report provides a comprehensive view of system access for Oracle EBS 11i environments. It details the relationships between users, responsibilities, menus, functions, forms, and data access sets (including ledgers and operating units). It is designed to answer critical security questions regarding “who has access to what” at a granular level.

Business Challenge

In Oracle EBS 11i, security is defined across multiple layers: users are assigned responsibilities, responsibilities are assigned menus, and menus contain functions and forms. Additionally, data access is controlled via security profiles and operating unit assignments. Auditing this complex web of permissions to ensure compliance (e.g., SOX) or to troubleshoot access issues is difficult and time-consuming when relying on standard screens or disparate reports.

The Solution

The FND Responsibility Access 11i report consolidates all access information into a single view. It allows security administrators and auditors to:

Technical Architecture

The report joins core FND security tables including fnd_user, fnd_responsibility, fnd_menus, fnd_form_functions, and fnd_request_groups. It also incorporates HR security tables like per_security_profiles and hr_operating_units to determine data access. Note: The current SQL does not fully account for menu exclusions, so excluded functions may still appear in the output.

Parameters & Filtering

The report supports flexible filtering to target specific access queries:

Performance & Optimization

The report is optimized for reporting but involves complex joins across the security model. For best performance, it is recommended to provide at least one high-level filter (e.g., User Name or Responsibility Name) rather than running it wide open for the entire system.

FAQ

Q: Does this report show 11i specific data? A: Yes, this version is specifically tailored for the 11i data model.

Q: Does it show if a user is end-dated? A: Yes, user and responsibility effective dates are considered.

Q: Why might a function show up even if I excluded it? A: As noted in the description, the current SQL logic does not filter out menu exclusions.

© 2026 Enginatics