Monday 1 April 2013

How to register concurrent executable from back end in oracle apps

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.
    
BEGIN

              FND_PROGRAM.executable('XXMZ_ERPSCHOOLS_EMPLOYEE' -- executable
                                                               , 'XXMZ Custom' -- application
                                                               , 'XXMZ_ERPSCHOOLS_EMPLOYEE' -- short_name
                                        , 'Executable for ERPSCHOOLS Employee INFORMATION' -- description
                                                               , 'PL/SQL Stored Procedure' -- execution_method
                                                               , 'XXMZ_ERPSCHOOLS_EMPLOYEE' -- execution_file_name
                                                               , '' -- subroutine_name
                                                               , '' -- Execution File Path
                                                               , 'US' -- language_code
                                                               , '');
              COMMIT;
END;

No comments:

Post a Comment