Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 29 March 2016

Script to delete Concurrent program and Executable and Data definition and Template

Begin
fnd_program.delete_program('program short name','applicaton shot name');
fnd_program.delete_executable('program short name','applicaton shot name');
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 concurrentprogram 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', 'applicaton shot name' );
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.

Script for deleting the datadefinition
------------------------------------------------>
BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('INV','NRGINTR');
END;
--------------------------------------------------------
--------------------------------------------------------
script for deleting the template
------------------------------------------------------>
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('INV','NRGINTR');
END;
Share this article :

1 comments:

  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete