Forgot your password?    
+ Reply to Thread
Results 1 to 1 of 1

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

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

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

    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)

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics