How To Delete A Concurrent Program And Executable From Back End In Oracle Apps

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.

Most Frequently Used PLSQL Scripts In Oracle Apps:

1. How To Add Any Responsibility To A User From Back End
2. How To Call A Standard Interface Program From Sql or pl/sql Code
3. How To Copy Files Using a PL/SQL Script
4. How To Delete A Concurrent Program And Executable From Back End In Oracle Apps
5. How To Dump Data From Pl/SQL Block To Flat Files
6. How To Get All The View That Are Referring To A Particular Table
7. How To Get RESPONSIBILITY_ID, APPLICATION_ID & USER_ID
8. How To Send An SMS Using PL/SQL Code/Script
9. PL/SQL Script To Change/Reset The Oracle Applications Password From Back End
10. PL/SQL Script To Create A User In Oracle Applications
11. PL/SQL Script To Remove End Date From Responsibilities Assigned To A User