Skip to content

FND Concurrent Programs and Executables

Directory actions

More options

Directory actions

More options

Latest commit

 

History

History

FND Concurrent Programs and Executables

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
DESCRIPTION.md
DESCRIPTION.md
 
 
FND Concurrent Programs and Executables.sql
FND Concurrent Programs and Executables.sql
 
 
README.md
README.md
 
 

README.md

layout default
title FND Concurrent Programs and Executables | Oracle EBS SQL Report
description Concurrent programs, executables and program parameters – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, R12 only, FND, Concurrent, Programs, Executables, fnd_application_vl, fnd_concurrent_programs_vl, fnd_executables_vl
permalink /FND%20Concurrent%20Programs%20and%20Executables/

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

Enginatics, R12 only

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.
  • 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

© 2026 Enginatics