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(FND_PROFILE.VALUE('ORG_ID'),FND_PROFILE.VALUE('MFG_ORGANIZATION_ID'),to_char(C.INVENTORY_ITEM_ID), 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=:organization) QRSLT WHERE (INVENTORY_ITEM_ID in (select to_number(boi.component_item_id) from BOM_BILL_OF_MATERIALS BOM, MTL_SYSTEM_ITEMS MSI, BOM_INVENTORY_COMPONENTS boi WHERE BOM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID and bom.assembly_item_id=MSI.inventory_item_id and bom.organization_id=msi.organization_id and bom.bill_sequence_id=boi.bill_sequence_id and bom.assembly_item_id= ( select inventory_item_id from csi_item_instances where instance_id= 15475) and MSI.organization_id= 307 and MSI.ORGANIZATION_ID=bom.organization_id ) and organization_id=307 AND ( UPPER(SEGMENT1) like UPPER(:13) AND (SEGMENT1 like :14 OR SEGMENT1 like :15 OR SEGMENT1 like :16 OR SEGMENT1 like :17)))

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1166

  • via Oracle Community by HaroonAfridi, 11 months ago
    C.INVENTORY_ITEM_STATUS_CODE='Active' and c.organization_id=:organization) QRSLT WHERE (INVENTORY_ITEM_ID in (select to_number(boi.component_item_id) from BOM_BILL_OF_MATERIALS BOM, MTL_SYSTEM_ITEMS MSI, BOM_INVENTORY_COMPONENTS boi WHERE
  • via Oracle Community by HaroonAfridi, 11 months ago
    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
  • via Oracle Community by user633859, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select a.inventory_item_id,a.segment1,a.description ,b.OPERAND unit_price from mtl_system_items_b a, qp_list_lines_v b, (select
  • Stack trace

    • 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(FND_PROFILE.VALUE('ORG_ID'),FND_PROFILE.VALUE('MFG_ORGANIZATION_ID'),to_char(C.INVENTORY_ITEM_ID), 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=:organization) QRSLT WHERE (INVENTORY_ITEM_ID in (select to_number(boi.component_item_id) from BOM_BILL_OF_MATERIALS BOM, MTL_SYSTEM_ITEMS MSI, BOM_INVENTORY_COMPONENTS boi WHERE BOM.ASSEMBLY_ITEM_ID = MSI.INVENTORY_ITEM_ID and bom.assembly_item_id=MSI.inventory_item_id and bom.organization_id=msi.organization_id and bom.bill_sequence_id=boi.bill_sequence_id and bom.assembly_item_id= ( select inventory_item_id from csi_item_instances where instance_id= 15475) and MSI.organization_id= 307 and MSI.ORGANIZATION_ID=bom.organization_id ) and organization_id=307 AND ( UPPER(SEGMENT1) like UPPER(:13) AND (SEGMENT1 like :14 OR SEGMENT1 like :15 OR SEGMENT1 like :16 OR SEGMENT1 like :17))) at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    14 more bugmates