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

Oracle Community | rg3 | 4 years ago
  1. 0

    Error while terminating a 'Payment Process Request' in R12.

    Oracle Community | 4 years ago | rg3
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  2. 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
  3. 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
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

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

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

    : Missing IN or OUT parameter at index:: 8 at

    Oracle Community | 5 years ago | 802240
    java.sql.SQLException: Missing IN or OUT parameter at index:: 8

  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:: 1

    at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1783)
    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:3723)
    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:4559)
    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:3643)
    5 frames
  6. oracle.apps.fnd
    OAViewObjectImpl.executeQuery
    1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
    1 frame
  7. oracle.apps.iby
    ReviewProposedPaymentsAMImpl.initDetails
    1. oracle.apps.iby.disbursement.transaction.payment.server.SubmissionDetailsVOImpl.initQuery(SubmissionDetailsVOImpl.java:32)
    2. oracle.apps.iby.disbursement.transaction.payment.server.ReviewProposedPaymentsAMImpl.initDetails(ReviewProposedPaymentsAMImpl.java:114)
    2 frames
  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:762)
    3 frames
  10. oracle.apps.iby
    ReviewProposedPaymentsCO.processRequest
    1. oracle.apps.iby.disbursement.transaction.payment.webui.ReviewProposedPaymentsCO.processRequest(ReviewProposedPaymentsCO.java:76)
    1 frame
  11. oracle.apps.fnd
    OAPageBean.preparePage
    1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596)
    2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
    3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
    4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
    5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
    6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
    7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
    8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
    9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
    10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
    11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
    12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
    13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
    14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
    15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513)
    16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1751)
    17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538)
    18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)
    18 frames