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.
stat boolean;
IF stat
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.


Anonymous said...


Anonymous said...

Great post.

Anonymous said... Cheap drugs at Online Buy tramadol Buy Xanax! Forex Club

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!

Microsoft Office 2007 said...

NEVERTHELESS, THE CIVIL LAW is and must be neutral about who has a more noble or rewarding faith. The breakaway parishes ought to win every Office 2010facet of the lawsuit not becauseMicrosoft Office 2010 their beliefs or their politics are better, Microsoft wordbut because both lawOffice 2007and equity, along with common sense, are on Microsoft Officetheir side.Microsoft Office 2007 Not only does Virginia state law (the Division Statute)Office 2007 keyexplicitly apply to just such a Office 2007 downloadsituation as now exists, but the history Office 2007 Professionalespecially of The Falls Church argues against the claims of Outlook 2010the Virginia Diocese with which theyMicrosoft outlookhave disassociated.Microsoft outlook 2010First, The Falls Church wasWindows 7 founded, formed, and developed long before the diocese, or the national Episcopal Church, even existed.

Unknown said...

Sridevi Koduru (Senior Oracle Apps Trainer
LinkedIn profile -
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at | +91 - 9581017828.

yaklibber924 said...

Your house is valueble for me. Thanks!… casino slots

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