FND Responsibilities – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Active responsibilites with active user count and related setup information such as menus, data access sets, security profiles and associated ledgers and operating units.
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 like, User Name, Application, Access to Inventory Org, Access to Operating Unit, Access to Ledger, Access to Function, No Access to Function, Request Group, User Menu Name, Menu Name, Custom Application Responsibilities, Expand Multiple Operating Units, Show Active only, Having Active Users only
Oracle EBS Tables Used
gl_access_set_norm_assign, gl_ledger_set_norm_assign_v, gl_ledgers, per_security_profiles, per_organization_list, hr_operating_units, hr_all_organization_units_vl, org_access, org_access_view, gl_access_sets_v, fnd_data_groups, fnd_application_vl, fnd_profile_option_values, fnd_profile_options, fnd_responsibility_vl, fnd_request_groups, fnd_menus_vl, fnd_user_resp_groups, fnd_user, fnd_mo_product_init
Report Categories
Related Reports
FND Responsibility Access, AR Customer Upload, AP Supplier Upload, IBY Payment Process Request Details, AR Customers and Sites, INV Item Upload 11i, Blitz Report Security, CAC Intercompany SO Price List vs. Item Cost Comparison, GL Account Distribution Analysis
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 | FND Responsibilities 04-Aug-2024 171326.xlsx |
| Blitz Report™ XML Import | FND_Responsibilities.xml |
| SQL Source | FND Responsibilities.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-responsibilities/ |
Executive Summary
The FND Responsibilities report provides a high-level overview of Responsibility definitions. It focuses on the setup of the responsibility itself, including its menu, request group, and data access controls.
Business Challenge
- License Audit: Counting the number of active users assigned to each responsibility.
- Configuration Review: Checking which Menu and Request Group are linked to a responsibility.
- MOAC Analysis: Verifying the “Multi-Org” setup (Security Profile) for each responsibility.
The Solution
This Blitz Report aggregates responsibility data:
- Definition: Responsibility Name, Key, and Application.
- Components: Assigned Menu, Request Group, and Data Group.
- Access Control: MO: Security Profile, GL Data Access Set.
- Usage: Count of active users assigned.
Technical Architecture
The report queries FND_RESPONSIBILITY_VL and joins to profile option values to determine the MOAC and GL security settings.
Parameters & Filtering
- Responsibility Name: Filter by name.
- Show Active only: Hide end-dated responsibilities.
- Having Active Users only: Filter to show only responsibilities that are actually being used.
Performance & Optimization
- Complex Joins: The report logic to determine the “Effective” Operating Unit or Ledger involves checking multiple profile levels, which makes the SQL complex but robust.
FAQ
- Q: Does this show which users have the responsibility?
- A: It shows the count of users. Use “FND Responsibility Access” or “FND User Responsibilities” to see the list of names.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© Enginatics GmbH