FND Concurrent Programs and Executables – 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
Concurrent programs, executables and program parameters
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
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 Requests, FND Flex Value Sets, Usages and Values, FND Responsibility Access, XDO Publisher Data Definitions, PER Organizations, FND Concurrent Requests Summary, DBA Sessions
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 Concurrent Programs and Executables 24-Jul-2017 144449.xlsx |
| Blitz Report™ XML Import | FND_Concurrent_Programs_and_Executables.xml |
| SQL Source | FND Concurrent Programs and Executables.sql |
| Full Report 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
© Enginatics GmbH