Registering the Executable from back-end

 Registering the Executable from back-end:

Usually we create executable in the front-end, but this can be done from the database tier i.e. back-end too. Below is the PL/SQL code to create an executable from back-end.

1 2 3 4 5 6 7 8 9 10 11 12 13 14

BEGIN   FND_PROGRAM.executable(executable => 'XXFIN TEST EXECUTABLE' , -- Executable Name   application=>'XXFIN' , -- Application Short Name   short_name=>'XXFINTSTEXE' , -- Executable Short Name   description=>'Test Executable created from Backend' ,     -- Description,DEFAULT NULL   execution_method=>'PL/SQL Stored Procedure',              -- Execution Method   execution_file_name=>'XXFIN_TEST_PROC' ,                  -- Execution File Name,DEFAULT NULL   subroutine_name=>NULL ,                                   -- Subroutine Name,DEFAULT NULL   icon_name=>NULL ,                                         -- Icon Name,DEFAULT NULL   language_code=>'US' ,                                     -- Language Code,DEFAULT 'US'   execution_file_path=>NULL                                 -- Execution File Path, DEFAULT NULL   );   COMMIT; END;

View from Frontend: