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 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', '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','NRGINTR');
END;
--------------------------------------------------------
--------------------------------------------------------
script for deleting the template
------------------------------------------------------>
BEGIN
XDO_TEMPLATES_PKG.DELETE_ROW('INV','NRGINTR');
END;
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;
while running this am getting ora-06501 how to get rectify it please let me know. thanks in advance
ReplyDeleteThe parameters given in the above example are wrong.
ReplyDeleteThe Concurrent name parameter is correct. It should be the concurrent program short name however the second parameter for the delete_program call should be the application name, not the name of the schema.