Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 1022129, 1 year ago
Attempt to set a parameter name that does not occur in the SQL: INVOICE_ID
java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: INVOICE_ID	at oracle.jdbc.driver.OraclePreparedStatement.setNullAtName(OraclePreparedStatement.java:4563)	at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNullAtName(OraclePreparedStatementWrapper.java:1295)	at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3996)	at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)	at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:14008)	at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)	at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)	at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3754)	at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)	at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4566)	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:751)	at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:696)	at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2654)	at oracle.jbo.server.ViewRowSetIteratorImpl.ensureRefreshed(ViewRowSetIteratorImpl.java:2631)	at oracle.jbo.server.ViewRowSetIteratorImpl.getRowCountInRange(ViewRowSetIteratorImpl.java:697)	at oracle.jbo.server.ViewRowSetImpl.getRowCountInRange(ViewRowSetImpl.java:3203)	at oracle.jbo.server.ViewObjectImpl.getRowCountInRange(ViewObjectImpl.java:7066)	at oracle.apps.fnd.framework.server.OAViewObjectImpl.getRowCountInRange(OAViewObjectImpl.java:1981)	at oracle.apps.fnd.framework.webui.OAWebBeanBaseTableHelper.adjustViewRange(OAWebBeanBaseTableHelper.java:226)	at oracle.apps.fnd.framework.webui.OAAdvancedTableHelper.prepareNavigatorProperties(OAAdvancedTableHelper.java:1040)	at oracle.apps.fnd.framework.webui.OAAdvancedTableHelper.processRequestAfterController(OAAdvancedTableHelper.java:733)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:662)	at oracle.apps.fnd.framework.webui.OAWebBeanTableHelper.processRequest(OAWebBeanTableHelper.java:2144)	at oracle.apps.fnd.framework.webui.OAAdvancedTableHelper.processRequest(OAAdvancedTableHelper.java:678)	at oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean.processRequest(OAAdvancedTableBean.java:739)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.OAWebBeanHideShowHelper.processRequest(OAWebBeanHideShowHelper.java:104)	at oracle.apps.fnd.framework.webui.OADefaultHideShowHelper.processRequest(OADefaultHideShowHelper.java:131)	at oracle.apps.fnd.framework.webui.beans.layout.OADefaultHideShowBean.processRequest(OADefaultHideShowBean.java:488)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1183)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:976)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:943)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:663)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2630)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1950)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:550)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:438)	at _OA._jspService(_OA.java:212)	at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)	at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)	at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)	at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)	at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)	at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)	at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)	at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)	at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)	at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)	at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)	at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)	at java.lang.Thread.run(Thread.java:619)