24 February 2011

APP-FND-01564: ORACLE error 6502 in afscpcon

Hi,

Am using 11.5.7   am trying to open on Internet explorer 9 .then am facing 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 :-
My url:-   http://backserver.bilt.com:8002


but now am using  :  http://backserver.bilt.com:8002/dev60cgi/f60cgi


Now its working fine

1 comment:

Farook Issudeen said...

Add http://backserver.bilt.com in trusted sites and keep the security level as low for trusted sites. It will solve your problem