java.sql.SQLException: Missing IN or OUT parameter at index:: 3

Oracle Community | 2709643 | 11 months ago
  1. 0

    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-271

    Oracle Community | 6 years ago | 828271
    java.sql.SQLException: Missing IN or OUT parameter at index:: 3
  2. 0

    JBO-27122: SQL error during statement preparation Error

    Oracle Community | 3 years ago | Pradeep Navin Kumar
    java.sql.SQLException: Missing IN or OUT parameter at index:: 6
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    iExpense - Error Searching for Expense Report

    Oracle Community | 3 years ago | LMartin
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 351
  5. 0

    Filter values in the Multi-list depending on the value in Drop-down list.

    Oracle Community | 6 years ago | 27091988
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1

  1. qavid 1 times, last 5 months ago
18 unregistered visitors
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

    Missing IN or OUT parameter at index:: 3

    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
    2. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
    3. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    4. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    4 frames
  3. oracle.jbo.server
    OAJboViewObjectImpl.executeQueryForCollection
    1. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
    2. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
    3. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)
    4. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
    4 frames
  4. oracle.apps.fnd
    OAViewObjectImpl.executeQueryForCollection
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
    1 frame
  5. oracle.jbo.server
    ViewObjectImpl.executeQuery
    1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
    2. oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
    3. oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
    4. oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
    5. oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3674)
    5 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQuery
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
    1 frame
  7. bulsimap.oracle.apps
    MainAMImpl.getBLdetails
    1. bulsimap.oracle.apps.fnd.bulsipr.server.MainAMImpl.getBLdetails(MainAMImpl.java:72)
    1 frame
  8. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  9. oracle.apps.fnd
    OAApplicationModuleImpl.invokeMethod
    1. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:190)
    2. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
    3. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:764)
    3 frames
  10. bulsimap.oracle.apps
    ViewPGCO.processFormRequest
    1. bulsimap.oracle.apps.fnd.bulsipr.webui.ViewPGCO.processFormRequest(ViewPGCO.java:59)
    1 frame
  11. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:827)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1206)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:860)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1039)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1005)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:860)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3061)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1895)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
    18 frames
  12. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:213)
    1 frame
  13. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  14. oracle.jsp.runtimev2
    JspServlet.service
    1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
    2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
    3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
    3 frames
  15. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  16. com.evermind.server
    ResourceFilterChain.doFilter
    1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    1 frame
  17. oracle.apps.jtf
    ReleaseResFilter.doFilter
    1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    1 frame
  18. com.evermind.server
    EvermindFilterChain.doFilter
    1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    1 frame
  19. oracle.apps.fnd
    AppsServletFilter.doFilter
    1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
    1 frame
  20. com.evermind.server
    AJPRequestHandler.run
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
    3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
    4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
    5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
    6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
    6 frames
  21. oracle.oc4j.network
    ServerSocketReadHandler$SafeRunnable.run
    1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    1 frame
  22. com.evermind.util
    ReleasableResourcePooledExecutor$MyWorker.run
    1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    1 frame
  23. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame