Search Results fnd_executables_uk1

Overview

The FND_EXECUTABLES table is a core Application Object Library repository that defines the executable components for the Oracle E-Business Suite Concurrent Processing framework. It serves as the master definition table for all executable files, stored procedures, or other runnable entities that can be invoked as concurrent programs. Every concurrent program in the system must reference a valid executable defined in this table. Its role is to decouple the definition of the executable logic from the concurrent program definition itself, allowing a single executable to be reused by multiple concurrent programs with different parameters or options. This table is fundamental to the operation and administration of concurrent requests in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores metadata that uniquely identifies and describes an executable. Key columns include the primary key composed of APPLICATION_ID and EXECUTABLE_ID. The EXECUTABLE_ID is the system-generated unique identifier for the executable within its owning application. The EXECUTABLE_NAME column, combined with APPLICATION_ID in a unique key (FND_EXECUTABLES_UK1), stores the name used to reference the executable. Other critical columns define the executable's type (e.g., 'PL/SQL Stored Procedure', 'Oracle Reports', 'SQL*Loader', 'Host', 'Java Concurrent Program', 'Spawned'), the actual execution file or procedure name, and the method for execution. The table maintains a relationship to its parent application via the APPLICATION_ID foreign key to FND_APPLICATION.

Common Use Cases and Queries

This table is central to development, troubleshooting, and auditing of concurrent programs. Common use cases include identifying all concurrent programs that use a specific executable, auditing executable definitions, and resolving setup issues. A typical query to find an executable's details and its associated concurrent programs is:

• SELECT fe.executable_name, fe.executable_id, fe.application_id, fa.application_short_name, fcp.concurrent_program_name FROM apps.fnd_executables fe JOIN apps.fnd_application fa ON fe.application_id = fa.application_id LEFT JOIN apps.fnd_concurrent_programs fcp ON fe.executable_id = fcp.executable_id AND fe.application_id = fcp.executable_application_id WHERE fe.executable_name = '<EXECUTABLE_NAME>';

Another frequent query involves listing all executables of a specific type, such as 'PL/SQL Stored Procedure', to analyze logic or dependencies. Administrators often query this table to verify the correct executable is assigned when a concurrent program errors or behaves unexpectedly.

Related Objects

FND_EXECUTABLES is a central hub with several key dependencies. The primary relationship is with FND_CONCURRENT_PROGRAMS, which references the executable via the EXECUTABLE_APPLICATION_ID and EXECUTABLE_ID foreign key columns. The FND_EXECUTABLES_TL table stores the translated user-facing name (description) for the executable. For advanced setups, the table is also referenced by FND_REQUEST_SET_STAGES and FND_STAGE_FN_PARAMETERS_TL when defining request set workflow stages. All these relationships enforce data integrity, ensuring that a concurrent program or stage cannot reference a non-existent executable definition.