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