FND Concurrent Programs and Executables – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Concurrent programs, executables and program parameters
Report Parameters
Concurrent Program Name like, Concurrent Progr. (all languages), Concurrent Progr. Short Name like, Enabled, Creation Date From, Application Name, Application Short Name, Executable Name, Executable Short Name, Executable Description, Execution Method, Execution File Name like, Output Format, Show Parameters, Parameter Default Type, Show Reports only
Oracle EBS Tables Used
fnd_application_vl, fnd_concurrent_programs_vl, fnd_executables_vl, fnd_descr_flex_col_usage_vl, fnd_flex_value_sets, fnd_concurrent_request_class, fnd_conc_prog_onsite_info
Report Categories
Related Reports
FND Concurrent Programs and Executables 11i, FND Concurrent Requests, FND Concurrent Requests 11i, FND Flex Value Sets, Usages and Values, FND Responsibility Access, FND Responsibility Access 11i, XDO Publisher Data Definitions, PER Organizations, FND Concurrent Requests Summary
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 | FND Concurrent Programs and Executables 24-Jul-2017 144449.xlsx |
| Blitz Report™ XML Import | FND_Concurrent_Programs_and_Executables.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-concurrent-programs-and-executables/ |
Executive Summary
The FND Concurrent Programs and Executables report is the definitive documentation tool for all concurrent programs in the system. It provides a complete technical specification of each program, including its executable logic, parameters, and value sets.
Business Challenge
- Documentation: Keeping technical documentation up to date with system changes.
- Impact Analysis: Identifying all programs that use a specific PL/SQL package or value set before making changes.
- Cleanup: Finding obsolete or disabled programs that clutter the system.
The Solution
This Blitz Report extracts the full definition of concurrent programs:
- Full Hierarchy: Links the Program -> Executable -> Execution File (e.g., PL/SQL package name).
- Parameter Detail: Lists every parameter, its sequence, prompt, and associated value set.
- Output Configuration: Shows the default output format (Text, PDF, XML) and print style.
Technical Architecture
The report joins FND_CONCURRENT_PROGRAMS, FND_EXECUTABLES, and FND_DESCR_FLEX_COL_USAGE (for parameters). It provides a flattened view where header information is repeated for each parameter row.
Parameters & Filtering
- Program Name: Search by user-friendly name or short code.
- Execution File: Find all programs that call a specific SQL script or package.
- Show Parameters: Toggle to show detailed parameter rows or just the program header.
Performance & Optimization
- Data Volume: There are thousands of standard programs. Always filter by Application or Name to avoid a massive export.
FAQ
- Q: Can I see the SQL code of the program?
- A: This report gives the name of the execution file (e.g.,
XX_MY_PKG). You would need a separate tool or SQL developer to view the package code itself.
- A: This report gives the name of the execution file (e.g.,
- Q: Does it show Request Groups?
- A: No, this report focuses on the program definition. Use “FND Request Groups” to see where the program is assigned.
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
© 2026 Enginatics