After upgrading my Internet Explorer to IE9, faced the below 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:
Added my server http://bkptapsrv2.com in trusted sites and kept the security level as low for trusted sites. It solved the problem
APP-FND-01564: ORACLE error 6502 in afscpcon
ReplyDeleteI have upgraded my IE from 8 to 9 and got the same issue. Followed the above steps and got resolved; Here is my solution with detail
1) Click on Internet Settings-->Internet Options-->Click on Security-->Click on Trusted Sites-->Click on Sites button-->Copy your Apps URL and Add this website to the zone then click on Add and Click on Close button
Restart your IE9
Thx/JDK
Thanks alot ..Jaydev Katrapati it worked.
ReplyDeletethanks bro... its working
ReplyDelete