Sunday, March 31, 2013

How to delete a Concurrent Program and Concurrent Executable


Concurrent program cannot be deleted from Oracle Applications front-end, it can only be disabled.
Try to delete a concurrent program from Oracle Applications front-end:-












 
 
 
 
 
 



 
                                                                                             
 


Execute the following database script using fnd_program.delete_program to delete Concurrent program programmatically:-
 
 

  BEGIN
       fnd_program.delete_program (program_short_name => 'XX_CP', -- Conc. Executable Short Name
                                                  application => 'AR' -- Program Application Short Name
                                                           );

    COMMIT;
END;
 

After the program deletion script is executed, try to query the Concurrent Program from Oracle Applications front-end:-
Steps:- F11, Enter Program: XX Concurrent Program, Ctrl + F11


Note: - The concurrent program is deleted

 
The Concurrent executable can be deleted from the Oracle Applications front-end after the associated Concurrent Program is deleted or it can be deleted by using a database script:-

Press on “Delete” icon and save to delete Concurrent executable:-

 
 
 
 
 
 
                                                                                                                                                                      
Following database script using fnd_program.delete_executable can be used to delete Concurrent executable programmatically:-

BEGIN
  fnd_program.delete_executable (executable_short_name => 'XX_EXEC', -- Conc. Executable Short Name
                                                 application => 'AR' -- Program Application Short Name
                                                    );

   COMMIT;
END;
 
 
After the executable deletion script is executed in the database, try to query the Concurrent Program from Oracle Applications front-end:-
Steps:- F11, Enter Executable: XX_EXEC, Ctrl + F11




Note: - The concurrent executable is deleted

No comments:

Post a Comment