1 Reply Latest reply on May 11, 2016 5:21 AM by Jason Brincat

    Forms not launching after cloning 11.5.9 APPS

    2923606

      Hi All,

      After cloning 11.5.8 Oracle APPS, forms are not launching. There are no errors in error_log.

      In one of the Community post, its mentioned that having default GUEST password (ORACLE) resolved the issue.

      I have it ORACLE1.

      So I changed it to ORACLE(default)  in xml CONTEXT file, ran autoconfig. The .dbc file got updated with default password.

      However, in database ( 9.2.0.5) , I see mixed results:

      SQL> SELECT UPPER (fnd_profile.VALUE ('GUEST_USER_PWD')) user_pwd from dual;

       

      USER_PWD

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

      GUEST/ORACLE

       

      But validate login still hods the old value:

      SQL> select fnd_web_sec.validate_login('GUEST','ORACLE') from dual;

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

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

      N

       

      SQL>  select fnd_web_sec.validate_login('GUEST','ORACLE1') from dual;

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

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

      Y

       

      I tried changing the password using below, but no help :

      select fnd_web_sec.change_password('GUEST','ORACLE') from dual;

       

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

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

      N

       

      Please help!