FND Request Groups – 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
FND request groups and their assigned units, such as concurrent programs, request sets or applications
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
Request Group, Group Application, Concurrent Program Name
Oracle EBS Tables Used
fnd_request_groups, fnd_application_vl, fnd_request_group_units, fnd_concurrent_programs_vl, fnd_request_sets_vl
Report Categories
Related Reports
FND Responsibility Access, PAY Payroll Process Summary, XDO Publisher Data Definitions, FND Concurrent Requests, FND Attached Documents, FND Concurrent Programs and Executables, AP Invoice Upload
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 Request Groups 27-Jun-2024 161133.xlsx |
| Blitz Report™ XML Import | FND_Request_Groups.xml |
| SQL Source | FND Request Groups.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-request-groups/ |
Executive Summary
The FND Request Groups report documents which concurrent programs are assigned to which Request Groups. This is the mechanism that controls which reports a user can run.
Business Challenge
- Security Audit: Verifying that sensitive reports (e.g., “Employee Salary Report”) are not in standard request groups.
- Troubleshooting: Explaining why a user cannot find a specific report in the “Submit Request” window.
- Configuration: Documenting the contents of custom request groups.
The Solution
This Blitz Report lists the assignments:
- Request Group: The name of the group (e.g., “GL Concurrent Program Group”).
- Unit Type: Program, Set, or Application.
- Unit Name: The specific report or set assigned.
Technical Architecture
The report queries FND_REQUEST_GROUPS and FND_REQUEST_GROUP_UNITS.
Parameters & Filtering
- Request Group: Filter by the group name.
- Concurrent Program Name: Find all groups that contain a specific report (Reverse Search).
Performance & Optimization
- Fast Execution: Runs quickly against the configuration tables.
FAQ
- Q: What does “Application” unit type mean?
- A: It means all reports belonging to that application are automatically included in the group.
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