oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct mc.SEGMENT1||'.'||mc.SEGMENT2 "Comodity" ,poe.SEGMENT_VALUE "Major Account" ,poe.RULE_VALUE_ID ,poe2.segment_value "CC" from po.PO_RULE_EXPENSE_ACCOUNTS poe, po.PO_RULE_EXPENSE_ACCOUNTS poe2, inv.mtl_categories_b mc, apps.fnd_flex_values fv, apps.fnd_flex_values_tl tl where poe.ORG_ID = 170 and poe.RULE_VALUE_ID = mc.CATEGORY_ID and poe.segment_num = 'SEGMENT3' and poe2.RULE_VALUE_ID (+) = mc.CATEGORY_ID and poe2.segment_num (+) = 'SEGMENT2' and fv.flex_value = poe.segment_value and fv.flex_value_set_id = 1004670 and fv.flex_value_id = tl.flex_value_id and fv.enabled_flag = 'Y') QRSLT WHERE (( UPPER(Comodity) like :1 AND (Comodity like :2 OR Comodity like :3 OR Comodity like :4 OR Comodity like :5)))

Oracle Community | 680096 | 6 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

    problem in shared LOV

    Oracle Community | 6 years ago | 680096
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct mc.SEGMENT1||'.'||mc.SEGMENT2 "Comodity" ,poe.SEGMENT_VALUE "Major Account" ,poe.RULE_VALUE_ID ,poe2.segment_value "CC" from po.PO_RULE_EXPENSE_ACCOUNTS poe, po.PO_RULE_EXPENSE_ACCOUNTS poe2, inv.mtl_categories_b mc, apps.fnd_flex_values fv, apps.fnd_flex_values_tl tl where poe.ORG_ID = 170 and poe.RULE_VALUE_ID = mc.CATEGORY_ID and poe.segment_num = 'SEGMENT3' and poe2.RULE_VALUE_ID (+) = mc.CATEGORY_ID and poe2.segment_num (+) = 'SEGMENT2' and fv.flex_value = poe.segment_value and fv.flex_value_set_id = 1004670 and fv.flex_value_id = tl.flex_value_id and fv.enabled_flag = 'Y') QRSLT WHERE (( UPPER(Comodity) like :1 AND (Comodity like :2 OR Comodity like :3 OR Comodity like :4 OR Comodity like :5)))
  2. 0

    Mukul's Oracle Technology Blog: Implementing Export Button Functionality Programatically

    blogspot.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  3. 0

    Getting RequisitionAMImpl in controller gives java.lang.ClassCastException

    Oracle Community | 10 years ago | 521069
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Using XML Publisher

    Oracle Community | 10 years ago | 331283
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: oracle.jdbc.driver.OracleConnection
  6. 0

    Dynamically changing image of personalized item

    Oracle Community | 10 years ago | 454278
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    11 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 mc.SEGMENT1||'.'||mc.SEGMENT2 "Comodity" ,poe.SEGMENT_VALUE "Major Account" ,poe.RULE_VALUE_ID ,poe2.segment_value "CC" from po.PO_RULE_EXPENSE_ACCOUNTS poe, po.PO_RULE_EXPENSE_ACCOUNTS poe2, inv.mtl_categories_b mc, apps.fnd_flex_values fv, apps.fnd_flex_values_tl tl where poe.ORG_ID = 170 and poe.RULE_VALUE_ID = mc.CATEGORY_ID and poe.segment_num = 'SEGMENT3' and poe2.RULE_VALUE_ID (+) = mc.CATEGORY_ID and poe2.segment_num (+) = 'SEGMENT2' and fv.flex_value = poe.segment_value and fv.flex_value_set_id = 1004670 and fv.flex_value_id = tl.flex_value_id and fv.enabled_flag = 'Y') QRSLT WHERE (( UPPER(Comodity) like :1 AND (Comodity like :2 OR Comodity like :3 OR Comodity like :4 OR Comodity like :5)))

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      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.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2662)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1665)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:502)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:423)
      7 frames