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 ORA_USER1122, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select REQ_LINE_ID, null RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER
via Oracle Community by 594196, 1 year ago
UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv.order_type_code AND lookup.lookup_type
via orafaq.com by Unknown author, 1 year ago
UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (SELECT lookup.meaning FROM fnd_lookup_values_vl lookup WHERE lookup.lookup_code = rcv.order_type_code AND lookup.lookup_type
via Oracle Community by user5500620, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PrimeOffEO.PRIME_OFF_ID, PrimeOffEO.PRIME_ID, PrimeOffEO.PRIME_CMPSATOFF_NAME, PrimeOffEO.PRIME_CMPSATOFF_AMT, PrimeOffEO.CREATED_BY
via Oracle Community by 729849, 1 year ago
oracle.jbo.InvalidObjNameException: JBO-25005: Object name 4 for type Variable is invalid
via Oracle Community by 604446, 2 years ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PA.ASSESSMENT_ID, PA.BUSINESS_GROUP_ID, PA.OBJECT_VERSION_NUMBER, PA.PERSON_ID, PA.ASSESSMENT_TYPE_ID, PA.ASSESSOR_PERSON_ID, PA.ASSESSMENT_GROUP_ID
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select REQ_LINE_ID, null RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (select lookup.meaning from fnd_lookup_values_vl lookup where lookup.lookup_code = rcv.order_type_code and lookup.lookup_type ='POR_RCV_ORDER_TYPE') ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, to_number(NULL) ORDER_NUMBER, matching_basis, decode(req_distribution_id, to_number(null), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(null) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT, QUANTITY_INVOICED, GL_ENCUMBERED_DATE, (select hla.location_code from hr_locations_all hla where hla.location_id = rcv.deliver_to_location_id)DAI_LOCATION_CODE from por_rcv_my_purchase_items_v rcv UNION ALL select REQ_LINE_ID, null RCV_SHIPMENT_NUMBER, ORDER_TYPE_CODE, RECEIPT_DATE, REQUESTOR_ID, PO_HEADER_ID, TO_NUMBER(NULL) PO_RELEASE_ID, ORDER_ID, PO_NUMBER, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_RELEASE_NUMBER, PO_LINE_NUMBER, PO_SHIPMENT_NUMBER, TO_ORGANIZATION_ID, ITEM_ID, PRIMARY_UOM, PRIMARY_UOM_CLASS, QUANTITY_DELIVERED, EXPECTED_RECEIPT_QTY, ITEM_DESCRIPTION, SHIP_TO_LOCATION_ID, VENDOR_ID, SOURCE, VENDOR_SITE_ID, SUPPLIER_SITE, NEED_BY_DATE, PROMISED_DATE, EXPECTED_RECEIPT_DATE, ORDERED_QTY, ORDERED_UOM, PO_DISTRIBUTION_ID, PO_NUM_REL_NUM, PRIMARY_UOM UNIT, EXPECTED_RECEIPT_QTY RECEIPT_QUANTITY, REQ_DISTRIBUTION_ID, DELIVER_TO_LOCATION_ID, REQ_HEADER_ID, REQUISITION_NUMBER, (select lookup.meaning from fnd_lookup_values_vl lookup where lookup.lookup_code = rcv1.order_type_code and lookup.lookup_type ='POR_RCV_ORDER_TYPE') ORDER_TYPE, PO_DISTRIBUTION_NUM, VENDOR_PRODUCT_NUM, ORDER_NUMBER, NULL matching_basis, decode(req_distribution_id, to_number(null), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link, to_number(null) shipment_header_id, MANUFACTURER_PART_NUMBER, OPERATING_UNIT, QUANTITY_INVOICED, GL_ENCUMBERED_DATE, (select hla.location_code from hr_locations_all hla where hla.location_id = rcv1.deliver_to_location_id)DAI_LOCATION_CODE from por_rcv_internal_items_v rcv1) QRSLT WHERE (REQUESTOR_ID = :1 and expected_receipt_date >= trunc(sysdate - 8) and expected_receipt_date <= trunc(sysdate + 1))	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)	at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)	at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)	at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)	at oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:536)	at oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:90)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:604)	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:2629)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1949)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:549)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:437)	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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)	at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)	at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)	at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)	at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)	at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)	at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)	at _OA._jspService(_OA.java:221)	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.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734)	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)	at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)	at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)	at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)	at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)	at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)	at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)	at _OA._jspService(_OA.java:221)	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:662)