Friday, July 31, 2015

How to remove the Concurrent Program from a Request Group


SET SERVEROUTPUT ON spool /tmp/XXCDS_HRRPTXXX_REMOVE_RG.TXT WHENEVER SQLERROR EXIT FAILURE ROLLBACK BEGIN apps.fnd_program.remove_from_group(program_short_name => 'XXCDS_HREXT002_EMP_RECT_CP', -- Program Short Name program_application => 'XXCDS', -- Application Short Name request_group => 'XXCDS Audit Request Group', -- Request Group Name group_application => 'XXCDS'); -- Application Short Name dbms_output.put_line('Concurrent Program has been removed from request group Successfully '); COMMIT; EXCEPTION WHEN NO_DATA_FOUND THEN dbms_output.put_line ('Concurrent Program has already been removed from the Request group'); WHEN OTHERS THEN dbms_output.put_line ('Others Exception Removing Conc Program. ERROR:' || SQLERRM); END; / SHOW ERROR SPOOL OFF

No comments:

Post a Comment