APP-FND-01564 ORA-6502,ORA-06512 in afscpcon IE 9

最新推荐文章于 2021-06-25 11:20:35 发布

转载最新推荐文章于 2021-06-25 11:20:35 发布 · 262 阅读

文章标签：

#数据库

遇到Oracle错误6502及其相关错误时，通过将服务器地址添加到受信任站点中并调整安全性级别为低，可以有效解决AFSCP连接失败的问题。本文提供了解决步骤及详细解释。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ERROR :

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."

Solution :
Add your server http://hostname.domainname in trusted sites and kept the security level as low for trusted sites.
(You may need to uncheck in the checkbox that permits only 'https' / secure sites to be added to the trusted sites)