PL/SQL Script to Create an Executable from backend

By | May 1, 2013

We need to use FND_PROGRAM.EXECUTABLE api to create an executable from backend database, below is the sample script.

Creating the Executable from backed:

/**************************************************
*PURPOSE: To Create an Executable from backend    *
*AUTHOR: Shailender Thallam                       *
***************************************************/
--
DECLARE
 --
   l_executable            VARCHAR2 (200);
   l_application           VARCHAR2 (200);
   l_short_name            VARCHAR2 (200);
   l_description           VARCHAR2 (200);
   l_execution_method      VARCHAR2 (200);
   l_execution_file_name   VARCHAR2 (200);
   l_subroutine_name       VARCHAR2 (200);
   l_icon_name             VARCHAR2 (200);
   l_language_code         VARCHAR2 (200);
   l_execution_file_path   VARCHAR2 (200);
   l_check                 VARCHAR2 (2);
 --  
BEGIN
 --
   l_executable          := 'XX_ORACLEAPPSDNA_EXE';
   l_application         := 'CUSTOM Custom'; -- Your target application name
   l_short_name          := 'XX_ORACLEAPPSDNA_EXE';
   l_description         := 'Test Script for creating Executable from Backend';
   l_execution_method    := 'PL/SQL Stored Procedure';
   l_execution_file_name := 'XX_ORACLEAPPSDNA_PKG.MAIN';
   l_subroutine_name     := NULL;
   l_icon_name           := NULL;
   l_language_code       := 'US';
   l_execution_file_path := NULL;
 --
 --Calling API to create executable
 --
   apps.fnd_program.executable (executable               => l_executable,
                                application              => l_application,
                                short_name               => l_short_name,
                                description              => l_description,
                                execution_method         => l_execution_method,
                                execution_file_name      => l_execution_file_name,
                                subroutine_name          => l_subroutine_name,
                                icon_name                => l_icon_name,
                                language_code            => l_language_code,
                                execution_file_path      => l_execution_file_path
                               );
   COMMIT;
   BEGIN
   --
   --To check whether executable is created or not
   --
      SELECT 'Y'
        INTO l_check
        FROM fnd_executables
       WHERE executable_name = 'XX_ORACLEAPPSDNA_EXE';
       --
       DBMS_OUTPUT.put_line ('Executable Created Successfully');
       --
   EXCEPTION
      WHEN NO_DATA_FOUND
      THEN
         DBMS_OUTPUT.put_line ('Executable Registration Failed');
   END;
END;

View from front end application:

Executable_from_Application

  1. The above script inserts data into FND_EXECUTABLES and FND_EXECUTABLES_TL tables
  2. Execute the below query to find out different Execution Methods
     SELECT MEANING "Execution_Method"
       FROM fnd_lookup_values
      WHERE lookup_type = 'CP_EXECUTION_METHOD_CODE'
    AND enabled_flag    = 'Y';
WOW! Did you like this post? We'll send more interesting posts like PL/SQL Script to Create an Executable from backend to you!
Enter your Email Address: