EBS R12.2 Enable JWS from backend

--SELECT *

--FROM fnd_profile_options_tl

--WHERE user_profile_option_name = 'Enable Java Web Start';

--- FND_ENABLE_JAVA_WEB_START 

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('FND_ENABLE_JAVA_WEB_START', 'Yes', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

---

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('ICX_FORMS_LAUNCHER', 'http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

-----------------

--ICX: Forms Launcher

SELECT *

FROM fnd_profile_options_tl

WHERE user_profile_option_name = 'ICX: Forms Launcher';

-- ICX_FORMS_LAUNCHER

SELECT po.profile_option_name "NAME", po.user_profile_option_name,

DECODE (TO_CHAR (pov.level_id),

'10001', 'SITE',

'10002', 'APP',

'10003', 'RESP',

'10005', 'SERVER',

'10006', 'ORG',

'10004', 'USER',

'???'

) "LEV",

DECODE (TO_CHAR (pov.level_id),

'10001', '',

'10002', app.application_short_name,

'10003', rsp.responsibility_key,

'10005', svr.node_name,

'10006', org.NAME,

'10004', usr.user_name,

'???'

) "CONTEXT",

pov.profile_option_value "VALUE"

FROM fnd_profile_options_vl po,

fnd_profile_option_values pov,

fnd_user usr,

fnd_application app,

fnd_responsibility rsp,

fnd_nodes svr,

hr_operating_units org

WHERE 1 = 1

AND pov.application_id = po.application_id

AND pov.profile_option_id = po.profile_option_id

AND usr.user_id(+) = pov.level_value

AND rsp.application_id(+) = pov.level_value_application_id

AND rsp.responsibility_id(+) = pov.level_value

AND app.application_id(+) = pov.level_value

AND svr.node_id(+) = pov.level_value

AND org.organization_id(+) = pov.level_value

and po.user_profile_option_name = 'ICX: Forms Launcher'

ORDER BY NAME, pov.level_id, VALUE;

Add

--http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws

Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('ICX_FORMS_LAUNCHER', 'http://moi-ebs.tahaluf.ae:8000/forms/frmservlet?config=jws', 'SITE');

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

 Apply Oracle Forms 10g Technology Patch 32960401

Generate JAR files with force option from adadmin