This content has been marked as final.
Show 3 replies
-
1. Re: ERROR:Failed to validate GUEST user in Profiles.
Hussein Sawwan-Oracle Jun 6, 2009 10:27 PM (in response to 696973)Hi,
What R12 release you are running? What is the OS?
I am unable to reproduce the issue on my R12 (12.0.4) instance as the AOL/J test shows the following:
Under "Verify DBC Settings" page:
Under "Making AOL/J Connection":Checking guest user/password... ...verified:GUEST/ORACLE Continue to next step only if you see no errors in this page.
Get the value of the GUEST password from the application context file (search for "s_guest_pass"), and use this password in the following command:=>Testing validateLogin... validateLogin(GUEST,ORACLE) returned: true Successfully created WebAppsContext, login validated.
This should return something like the following:SQL> select fnd_web_sec.validate_login('GUEST','Guest Password') from dual;
Please verify that the GUEST password is set properly in the following:FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') -------------------------------------------------------- Y
1) DBC files (under $FND_TOP/secure)
2) "Guest User Password" profile option
3) The above SELECT statement
Regards,
Hussein -
2. Re: ERROR:Failed to validate GUEST user in Profiles.
696973 Jun 7, 2009 3:33 AM (in response to Hussein Sawwan-Oracle)it's 12.1.1 on OEL5
SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
----------------------------------------------------------------------------
Y
SQL>
thanks.
Edited by: user11080703 on Jun 6, 2009 8:33 PM -
3. Re: ERROR:Failed to validate GUEST user in Profiles.
696973 Jun 7, 2009 3:32 AM (in response to Hussein Sawwan-Oracle)found that if the apps 12.1 then ignore the profile check.
Edited by: user11080703 on Jun 6, 2009 8:30 PM