1 Reply Latest reply on Dec 5, 2017 12:49 PM by Shaik

    Gust Password

    happy10319

      Hi,

      On R12.1.3 DB 11.2.0.4

       

      I have :

      sqlplus apps

      SQL> select fnd_profile.value('GUEST_USER_PWD') from dual;

       

      FND_PROFILE.VALUE('GUEST_USER_PWD')

      --------------------------------------------------------------------------------

      SQL>

      Then no value. Is it normal? How to update that?

       

      in CONTEXT_FILE and dbc:

      grep  -i GUEST_USER_PWD $FND_SECURE/mysystem.dbc

       

       

      GUEST_USER_PWD=GUEST/ORACLE

       

       

      grep -i guest $CONTEXT_FILE

               <oa_user type="GUEST">

                  <username oa_var="s_guest_user">GUEST</username>

                  <password oa_var="s_guest_pass">ORACLE</password>

       

      Thanks.

        • 1. Re: Gust Password
          Shaik

          Hi

           

          Yes its correct behaviour and doubled checked my instance

           

          You can see the below doc where mentione this profile moved in R12.1

          GUEST_USER_PWD Profile Option Is Not Available In R12.1 Instance (Doc ID 788979.1)

           

           

           

          you can check the connectivity

          Guest user connectivity check

           

          sqlplus apps/passwd

          SQL> select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;

          FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')

          ——————————————————————————–-----

          Y

           

          In your case if it's  Y noissues

           

          Regards

          Shaik