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 Azadare M, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PoRequisitionLineEO.REQUISITION_LINE_ID, PoRequisitionLineEO.REQUISITION_HEADER_ID, PoRequisitionLineEO.LINE_NUM
via Oracle Community by Sandeep Oracle, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select (address1 || ',' ||city || ',' || Country ||','||postal_code)address from HZ_ORG_PROFILES_CPUI_V
via Oracle Community by 835862, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT PACKING_UNIT_NUM ,PACKING_UNIT_STATUS ,PO_NUM ,PO_LINE ,PROJECT_NUM ,VENDOR_NAME ,CUSTOMER_PLANT ,ITEM_NUMBER ,PARENT_ITEM ,SUPPLIER_REFERENCE
via Oracle Community by 868733, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select CONSOLIDATION_SUMMARY_ID ,CREATION_DATE ,CREATED_BY ,BATCH_ID ,PROCESS_FLAG ,ERROR_MESSAGE ,CUSTOMER_ID ,BILLING_FREQUENCY
via Oracle Community by 828271, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT CT_TL.body , AH.doctype_id FROM pon_contracts_tl CT_TL , pon_contracts CT , pon_auction_headers_all AH WHERE CT_TL.language = :1 AND
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT PoRequisitionLineEO.REQUISITION_LINE_ID,         PoRequisitionLineEO.REQUISITION_HEADER_ID,          PoRequisitionLineEO.LINE_NUM,         PoRequisitionLineEO.LAST_UPDATE_DATE,          PoRequisitionLineEO.LAST_UPDATED_BY,         PoRequisitionLineEO.LAST_UPDATE_LOGIN,          PoRequisitionLineEO.CREATION_DATE,         PoRequisitionLineEO.CREATED_BY,          PoRequisitionLineEO.DELIVER_TO_LOCATION_ID,         PoRequisitionLineEO.TO_PERSON_ID,          PoRequisitionLineEO.ITEM_DESCRIPTION,         PoRequisitionLineEO.CATEGORY_ID,          PoRequisitionLineEO.UNIT_MEAS_LOOKUP_CODE,         PoRequisitionLineEO.UNIT_PRICE,          PoRequisitionLineEO.QUANTITY,         PoRequisitionLineEO.LINE_TYPE_ID,          PoRequisitionLineEO.SOURCE_TYPE_CODE,         PoRequisitionLineEO.ITEM_ID,          PoRequisitionLineEO.ITEM_REVISION,         PoRequisitionLineEO.QUANTITY_DELIVERED,          PoRequisitionLineEO.SUGGESTED_BUYER_ID,         PoRequisitionLineEO.ENCUMBERED_FLAG,          PoRequisitionLineEO.RFQ_REQUIRED_FLAG,         PoRequisitionLineEO.NEED_BY_DATE,          PoRequisitionLineEO.LINE_LOCATION_ID,         PoRequisitionLineEO.MODIFIED_BY_AGENT_FLAG,          PoRequisitionLineEO.PARENT_REQ_LINE_ID,         PoRequisitionLineEO.JUSTIFICATION,          PoRequisitionLineEO.NOTE_TO_AGENT,         PoRequisitionLineEO.NOTE_TO_RECEIVER,          PoRequisitionLineEO.PURCHASING_AGENT_ID,         PoRequisitionLineEO.DOCUMENT_TYPE_CODE,          PoRequisitionLineEO.BLANKET_PO_HEADER_ID,         PoRequisitionLineEO.BLANKET_PO_LINE_NUM,          PoRequisitionLineEO.CURRENCY_CODE,         PoRequisitionLineEO.RATE_TYPE,          PoRequisitionLineEO.RATE_DATE,         PoRequisitionLineEO.RATE,          PoRequisitionLineEO.CURRENCY_UNIT_PRICE,         PoRequisitionLineEO.SUGGESTED_VENDOR_NAME,          PoRequisitionLineEO.SUGGESTED_VENDOR_LOCATION,          PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT,         PoRequisitionLineEO.SUGGESTED_VENDOR_PHONE,          PoRequisitionLineEO.SUGGESTED_VENDOR_PRODUCT_CODE,          PoRequisitionLineEO.UN_NUMBER_ID,         PoRequisitionLineEO.HAZARD_CLASS_ID,          PoRequisitionLineEO.MUST_USE_SUGG_VENDOR_FLAG,          PoRequisitionLineEO.REFERENCE_NUM,         PoRequisitionLineEO.ON_RFQ_FLAG,          PoRequisitionLineEO.URGENT_FLAG,         PoRequisitionLineEO.CANCEL_FLAG,          PoRequisitionLineEO.SOURCE_ORGANIZATION_ID,         PoRequisitionLineEO.SOURCE_SUBINVENTORY,          PoRequisitionLineEO.DESTINATION_TYPE_CODE,         PoRequisitionLineEO.DESTINATION_ORGANIZATION_ID,          PoRequisitionLineEO.DESTINATION_SUBINVENTORY,          PoRequisitionLineEO.QUANTITY_CANCELLED,         PoRequisitionLineEO.CANCEL_DATE,          PoRequisitionLineEO.CANCEL_REASON,         PoRequisitionLineEO.CLOSED_CODE,          PoRequisitionLineEO.AGENT_RETURN_NOTE,         PoRequisitionLineEO.CHANGED_AFTER_RESEARCH_FLAG,          PoRequisitionLineEO.VENDOR_ID,         PoRequisitionLineEO.VENDOR_SITE_ID,          PoRequisitionLineEO.VENDOR_CONTACT_ID,         PoRequisitionLineEO.RESEARCH_AGENT_ID,          PoRequisitionLineEO.ON_LINE_FLAG,         PoRequisitionLineEO.WIP_ENTITY_ID,          PoRequisitionLineEO.WIP_LINE_ID,         PoRequisitionLineEO.WIP_REPETITIVE_SCHEDULE_ID,          PoRequisitionLineEO.WIP_OPERATION_SEQ_NUM,         PoRequisitionLineEO.WIP_RESOURCE_SEQ_NUM,          PoRequisitionLineEO.ATTRIBUTE_CATEGORY,         PoRequisitionLineEO.DESTINATION_CONTEXT,          PoRequisitionLineEO.INVENTORY_SOURCE_CONTEXT,          PoRequisitionLineEO.VENDOR_SOURCE_CONTEXT,         PoRequisitionLineEO.BOM_RESOURCE_ID,          PoRequisitionLineEO.REQUEST_ID,         PoRequisitionLineEO.PROGRAM_APPLICATION_ID,          PoRequisitionLineEO.PROGRAM_ID,         PoRequisitionLineEO.PROGRAM_UPDATE_DATE,          PoRequisitionLineEO.USSGL_TRANSACTION_CODE,         PoRequisitionLineEO.GOVERNMENT_CONTEXT,          PoRequisitionLineEO.CLOSED_REASON,         PoRequisitionLineEO.CLOSED_DATE,          PoRequisitionLineEO.TRANSACTION_REASON_CODE,          PoRequisitionLineEO.QUANTITY_RECEIVED,         PoRequisitionLineEO.SOURCE_REQ_LINE_ID,          PoRequisitionLineEO.ORG_ID,         PoRequisitionLineEO.KANBAN_CARD_ID,          PoRequisitionLineEO.CATALOG_TYPE,         PoRequisitionLineEO.CATALOG_SOURCE,          PoRequisitionLineEO.MANUFACTURER_ID,         PoRequisitionLineEO.MANUFACTURER_NAME,          PoRequisitionLineEO.MANUFACTURER_PART_NUMBER,          PoRequisitionLineEO.REQUESTER_EMAIL,         PoRequisitionLineEO.REQUESTER_FAX,          PoRequisitionLineEO.REQUESTER_PHONE,         PoRequisitionLineEO.UNSPSC_CODE,          PoRequisitionLineEO.OTHER_CATEGORY_CODE,         PoRequisitionLineEO.SUPPLIER_DUNS,          PoRequisitionLineEO.TAX_STATUS_INDICATOR,         PoRequisitionLineEO.PCARD_FLAG,          PoRequisitionLineEO.NEW_SUPPLIER_FLAG,         PoRequisitionLineEO.AUTO_RECEIVE_FLAG,          PoRequisitionLineEO.TAX_USER_OVERRIDE_FLAG,         PoRequisitionLineEO.TAX_CODE_ID,          PoRequisitionLineEO.NOTE_TO_VENDOR,         PoRequisitionLineEO.OKE_CONTRACT_VERSION_ID,          PoRequisitionLineEO.OKE_CONTRACT_HEADER_ID,         PoRequisitionLineEO.ITEM_SOURCE_ID,          PoRequisitionLineEO.SUPPLIER_REF_NUMBER,         PoRequisitionLineEO.SECONDARY_UNIT_OF_MEASURE,          PoRequisitionLineEO.SECONDARY_QUANTITY,         PoRequisitionLineEO.PREFERRED_GRADE,          PoRequisitionLineEO.SECONDARY_QUANTITY_RECEIVED,          PoRequisitionLineEO.SECONDARY_QUANTITY_CANCELLED,          PoRequisitionLineEO.AUCTION_HEADER_ID,         PoRequisitionLineEO.AUCTION_DISPLAY_NUMBER,          PoRequisitionLineEO.AUCTION_LINE_NUMBER,         PoRequisitionLineEO.REQS_IN_POOL_FLAG,          PoRequisitionLineEO.VMI_FLAG,         PoRequisitionLineEO.ATTRIBUTE1,          PoRequisitionLineEO.ATTRIBUTE2,         PoRequisitionLineEO.ATTRIBUTE3,          PoRequisitionLineEO.ATTRIBUTE4,         PoRequisitionLineEO.ATTRIBUTE5,          PoRequisitionLineEO.ATTRIBUTE6,         PoRequisitionLineEO.ATTRIBUTE7,          PoRequisitionLineEO.ATTRIBUTE8,         PoRequisitionLineEO.ATTRIBUTE9,          PoRequisitionLineEO.ATTRIBUTE10,         PoRequisitionLineEO.ATTRIBUTE11,          PoRequisitionLineEO.ATTRIBUTE12,         PoRequisitionLineEO.ATTRIBUTE13,          PoRequisitionLineEO.ATTRIBUTE14,         PoRequisitionLineEO.ATTRIBUTE15,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE1,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE2,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE3,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE4,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE5,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE6,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE7,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE8,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE9,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE10,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE11,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE12,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE13,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE14,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE15,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE16,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE17,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE18,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE19,         PoRequisitionLineEO.GLOBAL_ATTRIBUTE20,          PoRequisitionLineEO.GLOBAL_ATTRIBUTE_CATEGORY,          PoRequisitionLineEO.BID_NUMBER,         PoRequisitionLineEO.BID_LINE_NUMBER,          PoRequisitionLineEO.AMOUNT,         PoRequisitionLineEO.CURRENCY_AMOUNT,          PoRequisitionLineEO.NONCAT_TEMPLATE_ID,         PoRequisitionLineEO.JOB_ID,          PoRequisitionLineEO.CONTACT_INFORMATION,         PoRequisitionLineEO.CANDIDATE_SCREENING_REQD_FLAG,          PoRequisitionLineEO.SUGGESTED_SUPPLIER_FLAG,          PoRequisitionLineEO.ASSIGNMENT_END_DATE,         PoRequisitionLineEO.OVERTIME_ALLOWED_FLAG,          PoRequisitionLineEO.CONTRACTOR_REQUISITION_FLAG,          PoRequisitionLineEO.LABOR_REQ_LINE_ID,         PoRequisitionLineEO.JOB_LONG_DESCRIPTION,          PoRequisitionLineEO.CONTRACTOR_STATUS,         PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_FAX,          PoRequisitionLineEO.SUGGESTED_VENDOR_CONTACT_EMAIL,          PoRequisitionLineEO.CANDIDATE_FIRST_NAME,         PoRequisitionLineEO.CANDIDATE_LAST_NAME,          PoRequisitionLineEO.ASSIGNMENT_START_DATE,         PoRequisitionLineEO.ORDER_TYPE_LOOKUP_CODE,          PoRequisitionLineEO.PURCHASE_BASIS,         PoRequisitionLineEO.MATCHING_BASIS,          PoRequisitionLineEO.NEGOTIATED_BY_PREPARER_FLAG,          PoRequisitionLineEO.BASE_UNIT_PRICE FROM PO_REQUISITION_LINES_ALL PoRequisitionLineEO WHERE (REQUISITION_HEADER_ID =3747730) AND PoRequisitionLineEO.REQUISITION_HEADER_ID = :1 ORDER BY PoRequisitionLineEO.LINE_NUM ASC	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:603)	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 org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)	at org.apache.jserv.JServConnection.run(JServConnection.java:294)	at java.lang.Thread.run(Thread.java:736)