How to delete a Concurrent Program and Concurrent Executable

Concurrent program cannot be deleted from Oracle Applications front-end, it can only be disabled.

Try to delete a concurrent program from Oracle Applications front-end:-

 

 

 

 

 

 

 

                                                                                             

 

Execute the following database script using fnd_program.delete_program to delete Concurrent program programmatically:-
 

 

  BEGIN
       fnd_program.delete_program (program_short_name => 'XX_CP', -- Conc. Executable Short Name
                                                  application => 'AR' -- Program Application Short Name
                                                           );
    COMMIT;
END;

 

After the program deletion script is executed, try to query the Concurrent Program from Oracle Applications front-end:-

Steps:- F11, Enter Program: XX Concurrent Program, Ctrl + F11

Note: - The concurrent program is deleted

 

The Concurrent executable can be deleted from the Oracle Applications front-end after the associated Concurrent Program is deleted or it can be deleted by using a database script:-

Press on “Delete” icon and save to delete Concurrent executable:-

 

 

 

 

 

 

                                                                                                                                                                      

Following database script using fnd_program.delete_executable can be used to delete Concurrent executable programmatically:-

BEGIN
  fnd_program.delete_executable (executable_short_name => 'XX_EXEC', -- Conc. Executable Short Name
                                                 application => 'AR' -- Program Application Short Name
                                                    );
   COMMIT;
END;

 

 

After the executable deletion script is executed in the database, try to query the Concurrent Program from Oracle Applications front-end:-

Steps:- F11, Enter Executable: XX_EXEC, Ctrl + F11

Note: - The concurrent executable is deleted