How to set profile options in oracle apps from backend . api to update profile option value

How to set profile options in oracle apps from backend . api to update profile option value

First of all We should have the name of the Profile option which we are going to change from database.

There are two name of the profile option in Oracle.

1.User Profile Option Name

2.Internal Profile Option Name

 

As an Example, We have profile  GL Ledger Name , and we want to set this from back end.

 

 

Sql Query to Extract the internal Name of the Profile Option

how to get the profile option value in oracle apps

 

SELECT profile_option_name

FROM fnd_profile_options_tl

WHERE user_profile_option_name = 'GL Ledger Name'

 

 

 

profile_option_name = GL_SET_OF_BKS_NAME

 

We have the Ledger Name ‘Vision Ledger’

Now We will set the Ledger in Oracle application from the Backend.

 

 

 

Profile_option_name = GL_SET_OF_BKS_NAME

 

We have the Ledger Name ‘Vision Ledger’

Now We will set the Ledger in Oracle application from the Backend.

 

This below  script helps to update or change the Profile options from the backend. We are using fnd_profile.save user level api to change or update the profiles in oracle application. We can also set fnd_profile.save responsibility level

Script to update profile values in oracle apps

Declare

Result Boolean;
BEGIN

   Result:= fnd_profile.SAVE (‘GL_SET_OF_BKS_NAME ‘, ‘Vision Ledger’, 'SITE');
   IF Result
   THEN
      DBMS_OUTPUT.put_line (‘Profile Updated’);
   ELSE
      DBMS_OUTPUT.put_line (‘Profile Not Updated’);
   END IF;
   COMMIT;
END;