java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 [Caused by: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 ] Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable.

Oracle Community | user11262316 | 4 years ago
  1. 0

    Create user fails when used from SOAP UI

    Oracle Community | 4 years ago | user11262316
    java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 [Caused by: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 ] Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable.
  2. 0

    Create user fails when used from SOAP UI

    Oracle Community | 4 years ago | user11262316
    java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 [Caused by: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 ] Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable.
  3. 0

    Create user fails when used from SOAP UI

    Oracle Community | 4 years ago | user11262316
    java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 [ ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 ] Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Create user fails when used from SOAP UI

    Oracle Community | 4 years ago | user11262316
    java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 Error Code: 6510
  6. 0

    Isue while installing SSO 10.1.4.0.1 as part of 11g R1 Portal.

    Oracle Community | 5 years ago | 875519
    java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "ORASSO.WWSSO_API_PRIVATE", line 154 ORA-01403: no data found ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 [Caused by: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.FND_SSO_MANAGER", line 248 ORA-01403: no data found ORA-06512: at "APPS.FND_USER_PKG", line 525 ORA-06512: at "APPS.FND_USER_PKG", line 663 ORA-06512: at line 1 ] Check to ensure that the API is defined in the database and that the parameters match the signature of the API. Contact oracle support if error is not fixable.

      at oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation()
    2. oracle.tip.adapter
      JCABindingOperation.executeInputOnlyOperation
      1. oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:620)
      2. oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeInputOnlyOperation(WSIFOperation_JCA.java:723)
      3. oracle.tip.adapter.client.JCABindingOperation.invokeWsifProvider(JCABindingOperation.java:259)
      4. oracle.tip.adapter.client.JCABindingOperation.executeInputOnlyOperation(JCABindingOperation.java:152)
      4 frames
    3. oracle.apps.fnd
      SOAProvider.processMessage
      1. oracle.apps.fnd.soa.provider.services.jca.JCAHandler.invoke(JCAHandler.java:256)
      2. oracle.apps.fnd.soa.provider.services.jca.JCAHandler.handleRequest(JCAHandler.java:149)
      3. oracle.apps.fnd.soa.provider.SOAProvider.processMessage(SOAProvider.java:272)
      3 frames
    4. oracle.j2ee.ws
      WebServiceProcessor$1.run
      1. oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:956)
      2. oracle.j2ee.ws.server.WebServiceProcessor$1.run(WebServiceProcessor.java:358)
      2 frames
    5. Java RT
      Subject.doAs
      1. java.security.AccessController.doPrivileged(Native Method)
      2. javax.security.auth.Subject.doAs(Subject.java:396)
      2 frames
    6. oracle.j2ee.ws
      WebServiceServlet.doPost
      1. oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:355)
      2. oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:466)
      3. oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:114)
      4. oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:96)
      5. oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:194)
      5 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      2 frames
    8. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    9. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    10. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame