How To Delete a Concurrent Program and Executable

How To Delete a Concurrent Program and Executable

 

Here is a simple script to delete a concurrent program and an executable from oracle applications through back end.

Script to delete the concurrent program and executable from Oracle Apps:

Begin

fnd_program.delete_program('program short name','schema');

fnd_program.delete_executable('program short name','schema');

commit;

End; 

Example: If you have a concurrent Progam called "Employee Details Report" with the short name EMPDTLSREP and an Executable EMPDTLSEXE is associated with the concurrent program Employee Details Report in apps schema then use the script below to delete both the concurrent program and executable.

Begin

fnd_program.delete_program('EMPDTLSREP', 'apps' );

fnd_program.delete_executable('EMPDTLSEXE', 'apps' );

commit;

End; 

Note: The same concurrent program can be disable through from end if a user decides not to use it.