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)

Oracle Community | 755555 | 6 years ago
  1. 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)
  2. 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))
  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 | 1 year 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 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)

      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