Monday, 2 December 2019

DELETE CONCURRENT PROGRAM FROM BACKEND in oracle apps EBS System.


/*=================================================================
DELETE CONCURRENT PROGRAM FROM BACKEND in oracle apps EBS System
==================================================================*/
DECLARE
   v_short_name   VARCHAR2 (50) := 'XXAA_AR_AGING';
BEGIN
   fnd_program.delete_program (program_short_name      => v_short_name,
                               application             => 'XXCUST Custom Application'
                              );
   COMMIT;
   DBMS_OUTPUT.put_line ( 'Concurrent Program succeefully Deleted ' || v_short_name );
END;

SELECT * FROM fnd_concurrent_programs_vl
WHERE concurrent_program_name='XXAA_AR_AGING'

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 ...