java.sql.SQLSyntaxErrorException: ORA-00904: "POREQUISITIONLINEEO"."REQUISITION_HEADER_ID": invalid identifier

Oracle Community | 1977211 | 3 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Vo extension error in iprocurement

    Oracle Community | 3 years ago | 1977211
    java.sql.SQLSyntaxErrorException: ORA-00904: "POREQUISITIONLINEEO"."REQUISITION_HEADER_ID": invalid identifier
  2. 0

    Oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation - webnetta.com

    webnetta.com | 6 months ago
    java.sql.SQLSyntaxErrorException: ORA-00904: "POREQUISITIONLINEEO"."REQUISITION_HEADER_ID": invalid identifier
  3. 0

    Error While extending PoRequisitionLinesVO

    Oracle Community | 5 years ago | Hanimi
    java.sql.SQLSyntaxErrorException: ORA-00904: "POREQUISITIONLINEEO"."REQUISITION_HEADER_ID": invalid identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation

    Oracle Community | 3 years ago | 1048039
    java.sql.SQLSyntaxErrorException: ORA-00904: "POREQUISITIONLINEEO"."REQUISITION_HEADER_ID": invalid identifier
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.SQLSyntaxErrorException

    ORA-00904: "POREQUISITIONLINEEO"."REQUISITION_HEADER_ID": invalid identifier

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 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:4560)
    1 frame
  5. oracle.apps.icx
    PoRequisitionLinesVOImpl.executeQueryForCollection
    1. oracle.apps.icx.por.req.server.PoRequisitionLinesVOImpl.executeQueryForCollection(PoRequisitionLinesVOImpl.java:65)
    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.icx
    PorBaseAMImpl.executeServerCommand
    1. oracle.apps.icx.por.req.server.ReqSubActionSvrCmd.loadCurrentReqInternal(ReqSubActionSvrCmd.java:1099)
    2. oracle.apps.icx.por.req.server.RequisitionSvrCmd.loadCurrentReq(RequisitionSvrCmd.java:1234)
    3. oracle.apps.icx.por.req.server.RequisitionAMImpl.loadCurrentReq(RequisitionAMImpl.java:1165)
    4. oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.prepareForDisplay(CheckoutSummarySvrCmd.java:182)
    5. oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.executeMethodByName(CheckoutSummarySvrCmd.java:83)
    6. oracle.apps.icx.por.req.server.CheckoutInfoBaseSvrCmd.execute(CheckoutInfoBaseSvrCmd.java:118)
    7. oracle.apps.icx.por.common.server.PorBaseAMImpl.executeServerCommand(PorBaseAMImpl.java:122)
    7 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.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
    2 frames
  10. oracle.apps.icx
    CheckoutSummaryCO.processRequest
    1. oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:972)
    2. oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:232)
    3. oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:150)
    4. oracle.apps.icx.por.req.webui.CheckoutSummaryCO.executePrepareForDisplay(CheckoutSummaryCO.java:175)
    5. oracle.apps.icx.por.req.webui.CheckoutSummaryCO.processRequest(CheckoutSummaryCO.java:109)
    5 frames
  11. xxinc.oracle.apps
    XXINCCheckoutSummaryCO.processRequest
    1. xxinc.oracle.apps.xxinc.icx.por.req.webui.XXINCCheckoutSummaryCO.processRequest(XXINCCheckoutSummaryCO.java:42)
    1 frame
  12. 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
  13. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:212)
    1 frame
  14. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  15. 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
  16. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  17. com.evermind.server
    ServletRequestDispatcher$2.oc4jRun
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
    3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
    4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
    5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
    5 frames
  18. oracle.oc4j.security
    OC4JSecurity.doPrivileged
    1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    1 frame
  19. com.evermind.server
    EvermindPageContext.forward
    1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
    2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
    2 frames
  20. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:221)
    1 frame
  21. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  22. 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
  23. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  24. com.evermind.server
    ServletRequestDispatcher$2.oc4jRun
    1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)
    2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
    3. com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
    4. com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
    5. com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
    5 frames
  25. oracle.oc4j.security
    OC4JSecurity.doPrivileged
    1. oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
    1 frame
  26. com.evermind.server
    EvermindPageContext.forward
    1. com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
    2. com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
    2 frames
  27. Unknown
    _OA._jspService
    1. _OA._jspService(_OA.java:221)
    1 frame
  28. com.orionserver.http
    OrionHttpJspPage.service
    1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
    1 frame
  29. 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
  30. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    1 frame
  31. com.evermind.server
    ResourceFilterChain.doFilter
    1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
    1 frame
  32. oracle.apps.jtf
    ReleaseResFilter.doFilter
    1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
    1 frame
  33. com.evermind.server
    EvermindFilterChain.doFilter
    1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
    1 frame
  34. oracle.apps.fnd
    AppsServletFilter.doFilter
    1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
    1 frame
  35. 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
  36. oracle.oc4j.network
    ServerSocketReadHandler$SafeRunnable.run
    1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
    1 frame
  37. com.evermind.util
    ReleasableResourcePooledExecutor$MyWorker.run
    1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
    1 frame
  38. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:619)
    1 frame