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