Tuesday 23 April 2013

To disable the Concurrent Program from Backend


To disable the Concurrent Program from Backend
whenever sqlerror continue
SET ECHO OFF
SET SERVEROUTPUT ON
SET LINESIZE 200

BEGIN
  fnd_program.enable_program('XXCAMARJ',     --CP Short Name
                             '9GS Financials', -- Application Name
                             'N');               --Enable Flag 'Y' or 'N'
EXCEPTION
  WHEN OTHERS THEN
    dbms_output.put_line('Main Exception : '||sqlerrm);
END;
/

0 comments:

Post a Comment