Last Friday I received a message from an international EBS user. The GUEST password was changed in the profile option GUEST_USER_PASSWORD (default GUEST/ORACLE). After the change, they could not login the Oracle EBS anymore. She asked me for some advice, how to solve this problem since it was their production environment.
What the current password is, is shown by the following sql
SQL> select profile_option_value from fnd_profile_option_values
2 where profile_option_id = 3805;
To see if the login password for user GUEST is the default password...
Because autoconfig was no option at that time, I suggested to change the profile back to it's default by using the SAVE function from the FND_PROFILE package.
stat := FND_PROFILE.SAVE('GUEST_USER_PWD', 'GUEST/ORACLE', 'SITE');
dbms_output.put_line( 'Stat = TRUE - profile updated' );
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
After running this function the password was set to ORACLE. The GUEST user password is also mentioned in the dbc file and in the xml file. If all the entry's are the same, everything should work fine.
Well, at Sunday we lost contact. But last Monday I received an email saying the problem was solved. I asked what solved the problem in the end, but I did not receive an answer yet.