java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Bind_ReportHeaderId

Oracle Community | 929077 | 4 years ago
  1. 0

    VO Extension Error

    Oracle Community | 4 years ago | 929077
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Bind_ReportHeaderId
  2. 0

    Bind Variable in oaf

    Oracle Community | 5 years ago | 839403
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  3. 0

    OAF

    Oracle Community | 5 years ago | 745071
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    VO Extension Error in modifying the query of XML Publisher Report Template

    Oracle Community | 5 years ago | 745071
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1
  6. 0

    Attempt to set a parameter name that does not occur in the SQL: 1

    Oracle Community | 4 years ago | 907823
    java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1

    2 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

      Attempt to set a parameter name that does not occur in the SQL: Bind_ReportHeaderId

      at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setObjectAtName
      1. oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:11915)
      2. oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:815)
      2 frames
    3. oracle.jbo.server
      OAJboViewObjectImpl.executeQueryForCollection
      1. oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3919)
      2. oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
      3. oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:13827)
      4. oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
      5. oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
      6. oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723)
      7. oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      7 frames
    4. oracle.apps.fnd
      OAViewObjectImpl.executeQueryForCollection
      1. oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
      1 frame
    5. oracle.apps.ap
      AuditReportLinesVOImpl.executeQueryForCollection
      1. oracle.apps.ap.oie.audit.server.AuditReportLinesVOImpl.executeQueryForCollection(AuditReportLinesVOImpl.java:99)
      1 frame
    6. oracle.jbo.server
      ViewObjectImpl.first
      1. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
      2. oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:688)
      3. oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2657)
      4. oracle.jbo.server.ViewRowSetIteratorImpl.refresh(ViewRowSetIteratorImpl.java:2915)
      5. oracle.jbo.server.ViewRowSetImpl.notifyRefresh(ViewRowSetImpl.java:2086)
      6. oracle.jbo.server.ViewRowSetImpl.refreshRowSet(ViewRowSetImpl.java:4886)
      7. oracle.jbo.server.ViewRowSetIteratorImpl.notifyDetailRowSets(ViewRowSetIteratorImpl.java:3408)
      8. oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigationToRow(ViewRowSetIteratorImpl.java:3549)
      9. oracle.jbo.server.ViewRowSetIteratorImpl.notifyNavigation(ViewRowSetIteratorImpl.java:3509)
      10. oracle.jbo.server.ViewRowSetIteratorImpl.internalSetCurrentRow(ViewRowSetIteratorImpl.java:3293)
      11. oracle.jbo.server.ViewRowSetIteratorImpl.first(ViewRowSetIteratorImpl.java:1481)
      12. oracle.jbo.server.ViewRowSetImpl.first(ViewRowSetImpl.java:2828)
      13. oracle.jbo.server.ViewObjectImpl.first(ViewObjectImpl.java:5792)
      13 frames
    7. oracle.apps.ap
      AuditAMImpl.initQuery
      1. oracle.apps.ap.oie.audit.server.ExpenseHeadersVOImpl.initAttributesAndTrxnValues(ExpenseHeadersVOImpl.java:67)
      2. oracle.apps.ap.oie.audit.server.ExpenseHeadersVOImpl.initVOAndChild(ExpenseHeadersVOImpl.java:49)
      3. oracle.apps.ap.oie.audit.server.AuditAMImpl.initQuery(AuditAMImpl.java:306)
      3 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.ap
      AuditPageCO.processRequest
      1. oracle.apps.ap.oie.audit.webui.AuditPageCO.processRequest(AuditPageCO.java:156)
      1 frame
    11. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      18 frames