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)

Solutions on the web1635

  • 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 797277, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT bp.vendor_site_id, (bp.vendor_site_code || ' - ' || ps.ADDRESS_LINE1 || DECODE (ps.ADDRESS_LINE1,NULL,NULL,', ') || ps.ADDRESS_LINE2 || DECODE
  • via Oracle Community by user11969884, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select * from omaxe_work_order_headers where work_order_number is not null) QRSLT WHERE (PROJECT_NAME =:1 AND CONTRACTOR_NAME=:2)
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates