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)

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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.