1 Reply Latest reply: Dec 18, 2013 1:20 AM by 998339 RSS

    APP-FND-01564: ORACLE error 6502 in afscpcon on IE9

    998339

      While opening oracle forms on Windows 7 and IE9 system below error message is coming please help


      APP-FND-01564: ORACLE error 6502 in afscpcon

      Cause: afscpcon failed due to ORA-06502: PL/SQL: numeric or value error
      ORA-06512: at "SYS.OWA_UTIL", line 325
      ORA-06512: at "SYS.HTP", line 1322
      ORA-06512: at "SYS.HTP", line 1397
      ORA-06512: at "SYS.HTP", line 1689
      ORA-06512: at "APPS.ICX_SEC", line 3457
      ORA-06502: PL.

      The SQL statement being executed at the time of the error was: SELECT SES.USER_ID, SES.RESPONSIBILITY_ID, SES.RESPONSIBILITY_APPLICATION_ID, SES.SECURITY_GROUP_ID, FSG.SECURITY_GROUP_KEY, U.USER_NAME, U.ENCRYPTED_USER_PASSWORD, SES.SESSION_ID, NVL(SES.LOGIN_ID, -1) FROM ICX_SESSIONS SES, FND_SECURITY_GROUPS FSG, FND_USER U WHERE SES.SESSION_ID = ICX_SEC.GetSessionCookie(:tik) AND NVL(SES.SECURITY_GROUP_ID, 0) = FSG.SECURITY_GROUP_ID AND SES.USER_ID = U.USER_ID AND DISABLED_FLAG = 'N' AND COUNTER + 1 < LIMIT_CONNECTS AND FIRST_CONNECT + LIMIT_TIME/24 > SYSDATE and was executed from the file &ERRFILE."

       

      Please help.

       

       

      Thanks & Regards,

       

      Sundeep Kumar Sahoo