oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT C.INVENTORY_ITEM_ID, to_char(C.SEGMENT1) SEGMENT1, C.DESCRIPTION, c.primary_uom_code, K.concatenated_segments, B.CATEGORY_ID, c.organization_id, eme_all_pkg.eme_demand_toe_qty('143','155',to_char(C.INVENTORY_ITEM_ID),:1) qty FROM MTL_CATEGORY_SETS_B A, MTL_ITEM_CATEGORIES B, MTL_SYSTEM_ITEMS_B C , MTL_CATEGORIES_B_KFV K WHERE A.CATEGORY_SET_ID = B.CATEGORY_SET_ID and c.internal_order_flag='Y' and c.internal_order_enabled_flag='Y' AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = C.ORGANIZATION_ID AND A.CATEGORY_SET_ID = 1 AND K.category_id = B.CATEGORY_ID AND C.INVENTORY_ITEM_STATUS_CODE='Active' and c.organization_id=:2) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER(:1) AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))

Oracle Community | HaroonAfridi | 6 years ago
  1. 0

    How to Handle oracle.jbo.SQLStmtException Exception

    Oracle Community | 6 years ago | HaroonAfridi
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT C.INVENTORY_ITEM_ID, to_char(C.SEGMENT1) SEGMENT1, C.DESCRIPTION, c.primary_uom_code, K.concatenated_segments, B.CATEGORY_ID, c.organization_id, eme_all_pkg.eme_demand_toe_qty('143','155',to_char(C.INVENTORY_ITEM_ID),:1) qty FROM MTL_CATEGORY_SETS_B A, MTL_ITEM_CATEGORIES B, MTL_SYSTEM_ITEMS_B C , MTL_CATEGORIES_B_KFV K WHERE A.CATEGORY_SET_ID = B.CATEGORY_SET_ID and c.internal_order_flag='Y' and c.internal_order_enabled_flag='Y' AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = C.ORGANIZATION_ID AND A.CATEGORY_SET_ID = 1 AND K.category_id = B.CATEGORY_ID AND C.INVENTORY_ITEM_STATUS_CODE='Active' and c.organization_id=:2) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER(:1) AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))
  2. 0

    LOV query with bind variable

    Oracle Community | 9 years ago | 574833
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select comp_plan_id,name,org_id from cn_comp_plans_all where sysdate between start_date and nvl(end_date,sysdate+1) and org_id = :1) QRSLT WHERE (( UPPER(NAME) like :2 AND (NAME like :3 OR NAME like :4 OR NAME like :5 OR NAME like :6)))
  3. 0

    Problem with table in table implementation

    Oracle Community | 9 years ago | 554101
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem with messageLovChoice

    Oracle Community | 8 years ago | 605963
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  6. 0

    Help needed in Table in Table Approach using OAF

    Oracle Community | 8 years ago | 669809
    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 C.INVENTORY_ITEM_ID, to_char(C.SEGMENT1) SEGMENT1, C.DESCRIPTION, c.primary_uom_code, K.concatenated_segments, B.CATEGORY_ID, c.organization_id, eme_all_pkg.eme_demand_toe_qty('143','155',to_char(C.INVENTORY_ITEM_ID),:1) qty FROM MTL_CATEGORY_SETS_B A, MTL_ITEM_CATEGORIES B, MTL_SYSTEM_ITEMS_B C , MTL_CATEGORIES_B_KFV K WHERE A.CATEGORY_SET_ID = B.CATEGORY_SET_ID and c.internal_order_flag='Y' and c.internal_order_enabled_flag='Y' AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = C.ORGANIZATION_ID AND A.CATEGORY_SET_ID = 1 AND K.category_id = B.CATEGORY_ID AND C.INVENTORY_ITEM_STATUS_CODE='Active' and c.organization_id=:2) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER(:1) AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7 frames