🔍 Query to Find Executable of a Concurrent Program in Oracle EBS
In Oracle E-Business Suite (EBS), each Concurrent Program is linked to an executable file that runs in the backend. To find out the executable associated with a given concurrent program, use the SQL query below.
📌 SQL Query to Fetch Executable Details
SELECT
prog.user_concurrent_program_name AS "Program Name",
prog.concurrent_program_name AS "Program Short Name",
appl.application_name AS "Program Application Name",
prog.description AS "Program Description",
exe.executable_name AS "Executable Name",
exe.execution_file_name AS "Executable File Name",
DECODE(
exe.execution_method_code,
'I', 'PL/SQL Stored Procedure',
'P', 'Oracle Reports',
'L', 'SQL*Loader',
'Q', 'SQL*Plus',
exe.execution_method_code
) AS "Execution Method"
FROM
apps.fnd_executables exe,
apps.fnd_application_tl appl,
apps.fnd_concurrent_programs_vl prog
WHERE
exe.application_id = appl.application_id
AND exe.executable_id = prog.executable_id
AND appl.language = 'US'
AND prog.user_concurrent_program_name LIKE '%AP%'; -- Optional filter
Tip: Replace '%AP%' with any part of the program name you want to search. For example, to find a specific report like "Invoice Register", use '%Invoice%'.
🧠 Columns Explained
- Program Name: User-friendly name of the concurrent program.
- Executable Name: Name given to the executable in EBS.
- Executable File Name: Actual file or procedure name that runs.
- Execution Method: How the program is run (e.g., Report, PL/SQL, SQL Loader).
