How to set FND Profile Option Value programmatically

 

Sample script to set FND Profile value programmatically at the User Level:-

 

Note:- The profile value can as well be set at SITE/APPLICATION/RESPONSIBILITY level by changing the "X_LEVEL_NAME" parameter accordingly.

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

SET SERVEROUTPUT ON

 

DECLARE

   x_val       BOOLEAN;

   x_profile   fnd_profile_options_tl.PROFILE_OPTION_NAME%TYPE;

BEGIN

   SELECT PROFILE_OPTION_NAME

     INTO x_profile

     FROM fnd_profile_options_tl

    WHERE user_profile_option_name = 'ABM: ABM Help';           -- Change here

 

  FOR rec_i IN (SELECT user_id FROM fnd_user WHERE user_name IN ( 'EBSPRO' -- Build List Here ))

 

     LOOP

      x_val :=  FND_PROFILE.SAVE

                  ( X_NAME        => x_profile

                  , X_VALUE       => 'Test123'    -- Change here

                  , X_LEVEL_NAME  => 'USER'

                  , X_LEVEL_VALUE => rec_i.user_id

                  );

      IF x_val THEN

        dbms_output.put_line('TRUE');

      ELSE

        dbms_output.put_line('FALSE');

      END IF;

    END LOOP;

END;

/

COMMIT;

/

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