Friday, March 22, 2019

Oracle Apps: How to set Profile Option Value to enable personalization from backend


In this post, I will just post a sample code to set a profile option value from the backend.

This is the sample screen shot of the Profile Option Definition.
Navigation :- Application Developer --> Profile --> System




 --To set the Profile value at user Level

BEGIN
   IF fnd_profile.save (profile_name    => 'DIAGNOSTICS',
                        profile_value   => 'Y',
                        level_name      => 'USER',
                        level_value     => 4516) -- User ID from fnd_user table
   THEN
      DBMS_OUTPUT.put_line ('Success');
   ELSE
      DBMS_OUTPUT.put_line ('Fail');
   END IF;

   COMMIT;
END;

No comments:

Post a Comment