How To Set A System Profile Value Without Logging In To The Applications

To set a profile option without accessing the applications, use the SAVE function from the FND_PROFILE package.

As a test case, below is the detailed procedure of changing the "Guest User Password" profile's value to GUEST/ORACLE.

1. To obtain the internal name of the profile option use the following select statement as APPS:
SQL> select profile_option_name from fnd_profile_options_tl where user_profile_option_name like '<Your Profile Option User Name or Part of it>';
e.g. For the "Guest User Password" profile option the internal name GUEST_USER_PWD

SQL> select profile_option_name from fnd_profile_options_tl where user_profile_option_name like 'Guest%';

PROFILE_OPTION_NAME
--------------------
GUEST_USER_PWD
2. Use the following sample code to set the profile option to the required value:

DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('GUEST_USER_PWD', 'GUEST/ORACLE', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;