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 828271, 1 year ago
CT_TEMP.internal_name = 'AUC_TAC' ) UNION SELECT NULL , AH.doctype_id FROM pon_auction_headers_all AH WHERE AH.auction_header_id = :2 AND NOT EXISTS (SELECT NULL FROM pon_contracts_tl CT_TL , pon_contracts CT WHERE CT_TL.contract_id = CT.contract_id AND CT.authoring_party_id = AH.org_id AND CT.internal_name = 'AUC_TAC' AND CT_TL.LANGUAGE = :1)
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 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 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
oracle.apps.fnd.framework.OAException: 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 AH.auction_header_id = :2
AND CT.authoring_party_id = AH.org_id
AND CT.internal_name = 'AUC_TAC'
AND CT_TL.contract_id = CT.contract_id
AND CT_TL.version_num IN (SELECT MAX(version_num)
FROM pon_contracts CT_TEMP
WHERE CT_TEMP.authoring_party_id = AH.org_id
AND CT_TEMP.internal_name = 'AUC_TAC'
)
UNION
SELECT NULL
, AH.doctype_id
FROM pon_auction_headers_all AH
WHERE AH.auction_header_id = :2
AND NOT EXISTS (SELECT NULL
FROM pon_contracts_tl CT_TL
, pon_contracts CT
WHERE CT_TL.contract_id = CT.contract_id
AND CT.authoring_party_id = AH.org_id
AND CT.internal_name = 'AUC_TAC'
AND CT_TL.LANGUAGE = :1)	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	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:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	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:2607)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)