Search Results fnd_executables_vl




The FND_EXECUTABLES_VL view in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical data dictionary object that provides a comprehensive list of executable programs registered within the system. This view is part of the Oracle Application Object Library (FND) and serves as a key reference for developers, administrators, and functional consultants working with concurrent programs, custom integrations, or system configurations. Below is a detailed analysis of its structure, purpose, and usage in Oracle EBS.

Overview and Purpose

The FND_EXECUTABLES_VL view is a language-sensitive (VL denotes "View with Language support") representation of the FND_EXECUTABLES base table. It stores metadata about executable programs that can be invoked as concurrent programs, PL/SQL procedures, Java methods, or shell scripts. This view is essential for managing and querying executable definitions across multiple languages, ensuring compatibility with Oracle EBS's multilingual capabilities.

Key Columns and Structure

The view includes the following critical columns:
  • APPLICATION_ID: Identifies the application (e.g., GL, AP, AR) owning the executable.
  • EXECUTABLE_ID: A unique numeric identifier for the executable.
  • EXECUTABLE_NAME: The name of the executable program (e.g., "GLPPIN").
  • EXECUTION_METHOD: Specifies how the executable runs (e.g., "PL/SQL Stored Procedure," "Host," "Java Concurrent Program").
  • EXECUTION_FILE_NAME: The file or procedure name to execute (e.g., "GLPPIN" for a PL/SQL procedure).
  • DESCRIPTION: A user-friendly description of the executable.
  • LANGUAGE: The language code (e.g., "US" for English) for multilingual support.

Usage Scenarios

  1. Concurrent Program Setup: When defining a concurrent program in Oracle EBS, administrators reference an executable from this view to specify the underlying logic (e.g., a PL/SQL procedure or shell script).
  2. Troubleshooting Developers query this view to verify executable metadata or diagnose issues like missing executables.
  3. Integration: Custom integrations or extensions often rely on executables registered here to ensure consistent execution across environments.

Technical Considerations

  • The view joins FND_EXECUTABLES with FND_EXECUTABLES_TL (the translation table) to support multilingual descriptions.
  • In EBS 12.2.x, the view remains largely unchanged from 12.1.1, but performance may differ due to underlying architectural changes (e.g., Online Patching in 12.2).
  • Security: Access to this view typically requires the "System Administrator" responsibility or equivalent privileges.

Example Query

A common query to retrieve executables for a specific application (e.g., General Ledger, app_id = 101) would be: 
SELECT executable_name, execution_method, execution_file_name, description
FROM FND_EXECUTABLES_VL
WHERE application_id = 101
AND language = 'US';

Conclusion

The FND_EXECUTABLES_VL view is a foundational component of Oracle EBS, enabling the registration, management, and execution of programs across modules. Its language-sensitive design ensures global deployments can maintain consistent executable definitions while adhering to localization requirements. Understanding this view is crucial for anyone involved in EBS customization, support, or upgrade projects.