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
  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 | 12 months 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 | 9 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