ERROR:Failed to validate GUEST user in Profiles.

696973
    I have r12.
    I try to do the Application Object Library AOL/J Setup Test http://download.oracle.com/docs/cd/B40089_10/current/acrobat/120sacg.pdf

    There is the error under "Verify Guest User" of Coonection Test.
    ERROR:Failed to validate GUEST user in Profiles.



    I can login to the applications and just want to try the test. This is a new setup r12 instance.


    Thank You.

    Edited by: user11080703 on Jun 6, 2009 2:53 PM
      • 1. Re: ERROR:Failed to validate GUEST user in Profiles.
        Hussein Sawwan-Oracle
        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:
        Checking guest user/password... ...verified:GUEST/ORACLE
        
        Continue to next step only if you see no errors in this page. 
        Under "Making AOL/J Connection":
        =>Testing validateLogin...
        validateLogin(GUEST,ORACLE) returned: true
        Successfully created WebAppsContext, login validated.
        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:
        SQL> select fnd_web_sec.validate_login('GUEST','Guest Password')
        from dual;
        This should return something like the following:
        FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
        --------------------------------------------------------
        Y
        Please verify that the GUEST password is set properly in the following:

        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
          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
            found that if the apps 12.1 then ignore the profile check.

            Edited by: user11080703 on Jun 6, 2009 8:30 PM