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 orafaq.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID
via Oracle Community by 594196, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID, QRSLT.RCV_SHIPMENT_NUMBER, QRSLT.ORDER_TYPE_CODE, QRSLT.RECEIPT_DATE, QRSLT.REQUESTOR_ID, QRSLT.PO_HEADER_ID
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 745071, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DECODE(ASO_QUOTES.RESOURCE_ID, null, sales.name, sales1.name) sales_rep_name, aso_quotes.quote_name, aso_quotes.contract_id, aso_quotes.quote_number
via Oracle Community by 745071, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DECODE(ASO_QUOTES.RESOURCE_ID, null, sales.name, sales1.name) sales_rep_name, aso_quotes.quote_name, aso_quotes.contract_id, aso_quotes.quote_number
via Oracle Community by Ashwin, 1 year ago
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NoSuchMethodError, msg=org.apache.soap.messaging.Message.receive()Lorg/apache/soap/Envelope;
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT QRSLT.REQ_LINE_ID,
QRSLT.RCV_SHIPMENT_NUMBER,
QRSLT.ORDER_TYPE_CODE,
QRSLT.RECEIPT_DATE,
QRSLT.REQUESTOR_ID,
QRSLT.PO_HEADER_ID,
QRSLT.PO_RELEASE_ID,
QRSLT.ORDER_ID,
QRSLT.PO_NUMBER,
QRSLT.PO_LINE_ID,
QRSLT.PO_LINE_LOCATION_ID,
QRSLT.PO_RELEASE_NUMBER,
QRSLT.PO_LINE_NUMBER,
QRSLT.PO_SHIPMENT_NUMBER,
QRSLT.TO_ORGANIZATION_ID,
QRSLT.ITEM_ID,
QRSLT.PRIMARY_UOM,
QRSLT.PRIMARY_UOM_CLASS,
QRSLT.QUANTITY_DELIVERED,
QRSLT.EXPECTED_RECEIPT_QTY,
QRSLT.ITEM_DESCRIPTION,
QRSLT.SHIP_TO_LOCATION_ID,
QRSLT.VENDOR_ID,
QRSLT.SOURCE,
QRSLT.VENDOR_SITE_ID,
QRSLT.SUPPLIER_SITE,
QRSLT.NEED_BY_DATE,
QRSLT.PROMISED_DATE,
QRSLT.EXPECTED_RECEIPT_DATE,
QRSLT.ORDERED_QTY,
QRSLT.ORDERED_UOM,
QRSLT.USSGL_TRANSACTION_CODE,
QRSLT.PO_DISTRIBUTION_ID,
QRSLT.PO_NUM_REL_NUM,
QRSLT.UNIT,
QRSLT.RECEIPT_QUANTITY,
QRSLT.REQ_DISTRIBUTION_ID,
QRSLT.DELIVER_TO_LOCATION_ID,
QRSLT.REQ_HEADER_ID,
QRSLT.REQUISITION_NUMBER,
QRSLT.ORDER_TYPE,
QRSLT.PO_DISTRIBUTION_NUM,
QRSLT.VENDOR_PRODUCT_NUM,
QRSLT.ORDER_NUMBER,
QRSLT.MATCHING_BASIS,
QRSLT.REQ_LINK,
QRSLT.SHIPMENT_HEADER_ID ,
QRSLT.MANUFACTURER_PART_NUMBER,
QRSLT.OPERATING_UNIT,
PORD.PROJECT_ID,
PAPA.SEGMENT1 PROJECT_NUMBER,
papa.name PROJECT_NAME,
PORL.LINE_NUM REQ_LINE_NUM,
PAT.TASK_NUMBER,
PAT.TASK_NAME,
pord.Expenditure_Type,
NVL(porl.currency_unit_price, porl.unit_price ) UNIT_PRICE
FROM
(SELECT REQ_LINE_ID,
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,
USSGL_TRANSACTION_CODE,
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
FROM por_rcv_my_purchase_items_v rcv
UNION ALL
SELECT REQ_LINE_ID,
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,
USSGL_TRANSACTION_CODE,
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,
matching_basis,
DECODE(req_distribution_id, to_number(NULL), 'ReqLinkDisabled', 'ReqLinkEnabled') req_link,
to_number(NULL) shipment_header_id,
MANUFACTURER_PART_NUMBER,
OPERATING_UNIT
FROM por_rcv_internal_items_v rcv1
) QRSLT 
,PO.PO_REQ_DISTRIBUTIONS_ALL pord
,PO.PO_REQUISITION_LINES_ALL porl
,PA.PA_PROJECTS_ALL PAPA
,PA.PA_TASKS PAT
WHERE
pord.distribution_id = QRSLT.REQ_DISTRIBUTION_ID
AND pord.requisition_line_id = porl.requisition_line_id
AND pord.PROJECT_ID = papa.PROJECT_ID
AND pord.task_id = pat.task_id) QRSLT WHERE (REQUESTOR_ID = :2) ORDER BY NEED_BY_DATE DESC,PO_NUMBER, PO_LINE_NUMBER	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:865)	at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:988)	at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)	at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:708)	at oracle.apps.icx.por.rcv.webui.RcvSrchCO.renderSearchResult(RcvSrchCO.java:458)	at oracle.apps.icx.por.rcv.webui.RcvSrchCO.processRequest(RcvSrchCO.java:67)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:587)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1136)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:959)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:926)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:646)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:247)	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2348)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1747)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)	at _oa__html._OA._jspService(_OA.java:84)	at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)	at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)	at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)	at oracle.jsp.JspServlet.internalService(JspServlet.java:186)	at oracle.jsp.JspServlet.service(JspServlet.java:156)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)	at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)	at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)	at _oa__html._OA._jspService(_OA.java:94)	at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)	at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)	at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)	at oracle.jsp.JspServlet.internalService(JspServlet.java:186)	at oracle.jsp.JspServlet.service(JspServlet.java:156)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)	at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)	at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)	at _oa__html._OA._jspService(_OA.java:94)	at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)	at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)	at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)	at oracle.jsp.JspServlet.internalService(JspServlet.java:186)	at oracle.jsp.JspServlet.service(JspServlet.java:156)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)	at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)	at org.apache.jserv.JServConnection.run(JServConnection.java:294)	at java.lang.Thread.run(Thread.java:534)