1 Reply Latest reply on Jul 17, 2018 1:32 PM by Aldrich

    Changing System Profile Values at the back end

    Shareef Khaleel

      Dear All,

       

      Can we change system profile values at database level using update statement or API?

       

      Example:

      update table_name set Java Color Scheme = 'blue'

       

      We are using EBS 12.1.2; db:11.1.0.7.

       

      Thanks and Regards,

      Shareef

        • 1. Re: Changing System Profile Values at the back end
          Aldrich

          FND_PROFILE.SAVE() function.

           

          This will allow you to update profile options....

           

          If its on the server level or user level, you will need the  node_id from fnd_nodes....or user_id from FND_USER.  Use the FND_PROFILE.get or FND_PROFILE.get_specific command to get the before and after values.  We also use profile_option_name from fnd_profile_options_tl to tie it all together...