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 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 bmn, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT , ( CASE WHEN pce.attribute1 = 'Y' THEN 1 ELSE 0 END ) is_yes FROM per_all_people_f ppf, per_competences pce WHERE ppf.person_id = pce.person_id (+) AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND NVL(ppf.effective_end_date, SYSDATE) AND ppf.person_id = :1
via Oracle Community by 907823, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT flv.lookup_code, flv.lookup_type, flv.meaning FROM fnd_lookup_values_vl flv WHERE lookup_type = 'INL_SHIP_TASKS' AND ENABLED_FLAG = 'Y
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 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 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
PACKING_UNIT_NUM
,PACKING_UNIT_STATUS
,PO_NUM
,PO_LINE
,PROJECT_NUM
,VENDOR_NAME
,CUSTOMER_PLANT
,ITEM_NUMBER
,PARENT_ITEM
,SUPPLIER_REFERENCE
,TERMS_OF_DELIVERY
,DELIVERY_STATUS
,READY_FOR_DISPATCH_ON
,TOTAL_GROSS_WEIGHT
,TOTAL_NET_WEIGHT
,COLLECTION_ADDRESS
,ZIP_CODE_CITY
,COUNTRY
,CONTACT_PERSON
,COUNTRY_OF_ORIGIN
,CARGO_SPEC_NUM
,SHIPMENT_NUM
,LOGISTIC_USER
,DEMAND_SOURCE
,EXPEDITOR_NAME
,BUYER_NAME
,SUPPLY_STATUS
,PO_QTY
,RECEIVED_QTY
FROM XXFLS_SWB_CPL FFPU
WHERE
UPPER(FFPU.PO_NUM)=(NVL(:1,FFPU.PO_NUM))
AND UPPER(FFPU.PACKING_UNIT_NUM)=(nvl(:2,FFPU.PACKING_UNIT_NUM))
AND UPPER(FFPU.VENDOR_NAME) LIKE UPPER(NVL(:3,FFPU.VENDOR_NAME))	at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)