Wednesday 27 April 2022

EBS R12 Update profile option from backend script

 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;


No comments:

Post a Comment

Number of Visitors