2 Replies Latest reply on Oct 10, 2015 5:03 AM by Kirushna

    unable to login - EBS R12

    Kirushna

      Hi all,

       

      My Env:

      EBS: R12.1.3

      DB: 11.2.0.3 (RAC)

      OS: HP UX

       

      Receiving the below error, when trying to login.

      Oracle error &ERRNO: &REASON has been detected in &ROUTINE.


      We used AOL/J test and thrown below error,

      Your session is no longer valid.

      Oracle error 20001: java.sql.SQLException: ORA-20001: Oracle error -942: ORA-00942: table or view does not exist has been detected in FND_SIGNON.NEW_PROXY_ICX_SESSION.

      ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 638

      ORA-06512: at line 1

      has been detected in createSession(int)(userId=5484,sessionMode='null','1BAE7CF1478023BFE0540017A477040632598214614568963512461143777241').

      Oracle error 20001: java.sql.SQLException: ORA-20001: Oracle error -942: ORA-00942: table or view does not exist has been detected in FND_SIGNON.is_pwd_expired.

      ORA-06512: at "APPS.APP_EXCEPTION", line 72

      ORA-06512: at "APPS.FND_SIGNON", line 18

      ORA-06512: at "APPS.FND_SIGNON", line 460

      ORA-06512: at line 1

      has been detected in SessionManager.recordSuccess.


      We have bounced the application&DB, crosschecked the Alerts related to FND_USER and it not exists. still no luck...

       

      kindly share your inputs to troubleshoot further.


      If you need info, let me know.

       

      Regards,

      Kirushna