Wednesday, February 14, 2007

Guest password in Oracle EBS

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...

select fnd_web_sec.validate_login('GUEST','ORACLE)
from dual;

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.
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;
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.

5 comments:

Anonymous said...

这个方法metalink上有讲的……

Anonymous said...

Great post.
Thanks.

Anonymous said...

Who knows where to download XRumer 5.0 Palladium?
Help, please. All recommend this program to effectively advertise on the Internet, this is the best program!

Anonymous said...


Microsoft Power BI
Microsoft Dynamics 365
Microsoft Dynamics NAV
Oracle Business Intelligence
Oracle EBS
Oracle HCM
Oracle Fusion

Tents Suppliers Nigeria said...

Al Fares International Tents and Marquees are rented for the purpose of accommodating indoor and outdoor events, such as Exhibition, Tradeshows, Wedding celebrations, Concerts, Music Festivals, Carnivals, Defense Exhibitions, Sporting Events, etc. We are also engaged in other services such as Field Hospitals, Drive Through or Screening Tents, Cooling Solutions, Commercial, and Industrial Mobile Halls. Labor Tents Rental Dubai | Tent Rental Abu Dhabi