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
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."
Thanks & Regards,
Sundeep Kumar Sahoo
I have found a solution for this. It worked for me...
Solution: Open Internet Options --> Security Tab --> Internet and Click Custom level. Perform below actions:
1. Enable "Allow ActiveX Filtering"
2. Disable " Use Pop-up blocker" and 'Use SmartScreen Filter'
3. Disable "Enable XSS Filter"