oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT X.CL_LOOKUP_ID, X.CL_LOOKUP_ORDER, X.CL_LOOKUP_DETAIL_ID, (X.CL_LOOKUP_ORDER || ' - ' || X.CL_DESC) CODEDESC, ('RenderDisableSub') RENDER_ENABLED, XCS.VESSEL_ID, XCS.CL_SURVEY_TYPE_ID, XCS.CL_PERIOD_ID, XCS.SURVEY_REPORT_ID, XCS.SURVEY_ID, 'N' DETAIL_YES FROM XXDENIZ.XXDP_CL_LOOKUP_VALUES_DETAIL X, XXDENIZ.XXDP_CL_SURVEY XCS, XXDENIZ.XXDP_CL_SETUP XC WHERE X.ENABLED = 'Y' AND XC.CL_SETUP_ID = XCS.CL_SETUP_ID AND X.CL_LOOKUP_DETAIL_ID = XC.CL_LOOKUP_DETAIL_ID) QRSLT WHERE ((:1 = CL_LOOKUP_ID))

Oracle Community | AnilA | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    View Link Invalid Number

    Oracle Community | 5 years ago | AnilA
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT X.CL_LOOKUP_ID, X.CL_LOOKUP_ORDER, X.CL_LOOKUP_DETAIL_ID, (X.CL_LOOKUP_ORDER || ' - ' || X.CL_DESC) CODEDESC, ('RenderDisableSub') RENDER_ENABLED, XCS.VESSEL_ID, XCS.CL_SURVEY_TYPE_ID, XCS.CL_PERIOD_ID, XCS.SURVEY_REPORT_ID, XCS.SURVEY_ID, 'N' DETAIL_YES FROM XXDENIZ.XXDP_CL_LOOKUP_VALUES_DETAIL X, XXDENIZ.XXDP_CL_SURVEY XCS, XXDENIZ.XXDP_CL_SETUP XC WHERE X.ENABLED = 'Y' AND XC.CL_SETUP_ID = XCS.CL_SETUP_ID AND X.CL_LOOKUP_DETAIL_ID = XC.CL_LOOKUP_DETAIL_ID) QRSLT WHERE ((:1 = CL_LOOKUP_ID))
  2. 0

    Urgent !!! Master- Detail Search with Hide/Show option

    Oracle Community | 6 years ago | 755555
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT qfapa.list_line_id, qfapa.pricing_attribute_context, qfapa.pricing_attribute, qfapa.pricing_attr_value_from, qfapa.pricing_attr_value_to, qfapa.factor_list_id, qfapa.comparison_operator_code, qfapa.pricing_attribute_id, qfapa.creation_date, qfapa.created_by, qfapa.last_update_date, qfapa.last_updated_by, qfapa.orig_sys_header_ref, qfapa.orig_sys_line_ref, qfapa.orig_sys_pricing_attr_ref FROM qpfv_factor_asso_pricing_attrs qfapa WHERE qfapa.pricing_attribute = NVL (:2, qfapa.pricing_attribute) AND qfapa.comparison_operator_code = NVL (:3, qfapa.comparison_operator_code) AND NVL (qfapa.pricing_attr_value_from, 'xxxxx') = NVL (:4, NVL (qfapa.pricing_attr_value_from, 'xxxxx')) AND NVL (qfapa.pricing_attr_value_to, 'xxxxx') = NVL (:5, NVL (qfapa.pricing_attr_value_to, 'xxxxx'))) QRSLT WHERE (LIST_LINE_ID = :1)
  3. 0

    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002

    Oracle Community | 4 years ago | user12119208
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25002: Definition ReqLineNum of type Attribute not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLException: Missing IN or OUT parameter at index:: 1 - OA Framework

    developer-works.com | 1 year ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT e.template_id, p.template_name FROM gecm_otst_enable_templates e, gecm_otst_prompts_tl p WHERE e.template_id = p.template_id AND org_id = :1 AND LANGUAGE = :2 UNION SELECT t.template_id, p.template_name FROM gecm_otst_prompts_tl p, gecm_otst_addr_templates t WHERE t.template_id = p.template_id AND t.org_id = -1 AND p.LANGUAGE = :2 AND NOT EXISTS(SELECT e.template_id, p.template_name FROM gecm_otst_enable_templates e, gecm_otst_prompts_tl p WHERE e.template_id = p.template_id AND org_id = :1 AND LANGUAGE = :2)
  6. 0

    Unknown Macro: "Existsroute" (File: Drivers\Kinetis\Sdhc_Ldd.Rgi)

    wpthm.com | 2 years ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 0

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT X.CL_LOOKUP_ID, X.CL_LOOKUP_ORDER, X.CL_LOOKUP_DETAIL_ID, (X.CL_LOOKUP_ORDER || ' - ' || X.CL_DESC) CODEDESC, ('RenderDisableSub') RENDER_ENABLED, XCS.VESSEL_ID, XCS.CL_SURVEY_TYPE_ID, XCS.CL_PERIOD_ID, XCS.SURVEY_REPORT_ID, XCS.SURVEY_ID, 'N' DETAIL_YES FROM XXDENIZ.XXDP_CL_LOOKUP_VALUES_DETAIL X, XXDENIZ.XXDP_CL_SURVEY XCS, XXDENIZ.XXDP_CL_SETUP XC WHERE X.ENABLED = 'Y' AND XC.CL_SETUP_ID = XCS.CL_SETUP_ID AND X.CL_LOOKUP_DETAIL_ID = XC.CL_LOOKUP_DETAIL_ID) QRSLT WHERE ((:1 = CL_LOOKUP_ID))

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2970)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:2767)
      4 frames