Thursday, 5 December 2019

How to Delete Concurrent Program oracle Report From The Request Group From Backend in oracle EBS R12


/*=============================================
DELETE CONCURRENT PROGRAM FROM THE REQUEST GROUP FROM BACKEND
==============================================*/
DECLARE
   v_short_name   VARCHAR2 (50) := 'XXAA_AR_AGING'; --> Conc Program Short Name
BEGIN
   fnd_global.apps_initialize (user_id           => 1318,
                               resp_id           => 21623,
                               resp_appl_id      => 660
                              );
   fnd_program.remove_from_group (program_short_name       => v_short_name,
                                  program_application      => 'XXCUST Custom Application',
                                  request_group            => 'Receivables All',
                                  group_application        => 'Receivables'
                                 );
   COMMIT;
   DBMS_OUTPUT.put_line (   'Successfully Deleted executable name is ' || v_short_name );
END;

No comments:

Post a Comment

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...