3 Replies Latest reply on Jun 7, 2009 3:32 AM by 696973

    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