Thursday, 14 June 2018

How To Delete A Concurrent Program, Executable (Short Name),Data Definition and Template From Back End In Oracle Apps EBS R12

How To Delete A Concurrent Program, Executable (Short Name),Data Definition and Template From Back End In Oracle Apps EBS R12



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

Syntax :
----------
Begin
fnd_program.delete_program('program short name','schema');
fnd_program.delete_executable('program short name','schema');
commit;
End;

Example :
------------

Begin
fnd_program.delete_program('XX_SALARY_DETAIL_REPORT', 'XXBRAC' );
fnd_program.delete_executable('XX_SALARY_DETAIL_REPORT', 'XXBRAC' );
commit;
End;

----------------------------------------------------------------------------------

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.

------------------------------------------------>
-- Script for deleting the datadefinition
------------------------------------------------>

BEGIN
XDO_DS_DEFINITIONS_PKG.DELETE_ROW('INV','XX_SALARY_DETAIL_REPORT');
END;

------------------------------------------------------
-- script for deleting the template
------------------------------------------------------>

BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('INV','XX_SALARY_DETAIL_REPORT');
END;

No comments:

Post a Comment

How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps EBS R12 Using Custom.Pll

  How to make responsibilities as read only in oracle apps EBS R12 Using Custom.Pll Or Creating a read only Responsibility in oracle apps ...