oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT concatenated_segments , msi.description , msi.organization_id , primary_uom_code , location_control_code , restrict_locators_code , restrict_subinventories_code , lot_control_code , serial_number_control_code , revision_qty_control_code , eam_item_type , msi.inventory_item_id , msi.padded_concatenated_segments item_code_segment1 , msi.description item_description , mOH.LOCATOR_ID , cst.item_cost , moh.subinventory_code sub_inventory_name , mil.segment1 LOCATOR , mcr.cross_reference , xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_id) Available_to_transact , sum(moh.primary_transaction_quantity) total_qoh FROM mtl_system_items_kfv msi, mtl_onhand_quantities_detail moh, apps.mtl_item_locations mil, apps.mtl_cross_references mcr, apps.cst_item_costs cst WHERE stock_enabled_flag = 'Y' AND bom_item_type = 4 AND (eam_item_type IS NULL OR eam_item_type = 3) AND moh.inventory_item_id(+) = msi.inventory_item_id AND moh.organization_id(+) = msi.organization_id AND moh.locator_id = mil.inventory_location_id(+) AND moh.organization_id = mcr.organization_id(+) AND mcr.cross_reference_type(+) = 'SFI_MRO_OLD_PART_NUM' AND moh.inventory_item_id = mcr.inventory_item_id(+) AND msi.inventory_item_status_code != 'Inactive' AND msi.item_type != 'AG' AND msi.item_type != 'AA' AND msi.item_type != 'OP' AND moh.inventory_item_id = cst.inventory_item_id AND moh.organization_id = cst.organization_id --and moh.organization_id =3159 -- and moh.INVENTORY_ITEM_ID = 8073 group by moh.subinventory_code ,concatenated_segments, msi.description, msi.organization_id, primary_uom_code, location_control_code, restrict_locators_code, restrict_subinventories_code, msi.inventory_item_id, lot_control_code, serial_number_control_code, revision_qty_control_code, eam_item_type, msi.inventory_item_id , msi.padded_concatenated_segments , msi.description , MOH.LOCATOR_ID, mil.segment1 , mcr.cross_reference, cst.item_cost, xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_id) order by total_qoh desc) QRSLT WHERE (organization_id = (select distinct organization_id from wip_discrete_jobs where wip_entity_id = :1))

Oracle Community | PVF | 4 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

    OAF not recognising package.function

    Oracle Community | 4 years ago | PVF
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT concatenated_segments , msi.description , msi.organization_id , primary_uom_code , location_control_code , restrict_locators_code , restrict_subinventories_code , lot_control_code , serial_number_control_code , revision_qty_control_code , eam_item_type , msi.inventory_item_id , msi.padded_concatenated_segments item_code_segment1 , msi.description item_description , mOH.LOCATOR_ID , cst.item_cost , moh.subinventory_code sub_inventory_name , mil.segment1 LOCATOR , mcr.cross_reference , xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_id) Available_to_transact , sum(moh.primary_transaction_quantity) total_qoh FROM mtl_system_items_kfv msi, mtl_onhand_quantities_detail moh, apps.mtl_item_locations mil, apps.mtl_cross_references mcr, apps.cst_item_costs cst WHERE stock_enabled_flag = 'Y' AND bom_item_type = 4 AND (eam_item_type IS NULL OR eam_item_type = 3) AND moh.inventory_item_id(+) = msi.inventory_item_id AND moh.organization_id(+) = msi.organization_id AND moh.locator_id = mil.inventory_location_id(+) AND moh.organization_id = mcr.organization_id(+) AND mcr.cross_reference_type(+) = 'SFI_MRO_OLD_PART_NUM' AND moh.inventory_item_id = mcr.inventory_item_id(+) AND msi.inventory_item_status_code != 'Inactive' AND msi.item_type != 'AG' AND msi.item_type != 'AA' AND msi.item_type != 'OP' AND moh.inventory_item_id = cst.inventory_item_id AND moh.organization_id = cst.organization_id --and moh.organization_id =3159 -- and moh.INVENTORY_ITEM_ID = 8073 group by moh.subinventory_code ,concatenated_segments, msi.description, msi.organization_id, primary_uom_code, location_control_code, restrict_locators_code, restrict_subinventories_code, msi.inventory_item_id, lot_control_code, serial_number_control_code, revision_qty_control_code, eam_item_type, msi.inventory_item_id , msi.padded_concatenated_segments , msi.description , MOH.LOCATOR_ID, mil.segment1 , mcr.cross_reference, cst.item_cost, xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_id) order by total_qoh desc) QRSLT WHERE (organization_id = (select distinct organization_id from wip_discrete_jobs where wip_entity_id = :1))
  2. 0

    AJVOAF:Issue :exception     variable not in select list

    Oracle Community | 4 years ago | PVF
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT concatenated_segments ,msi.description ,msi.organization_id ,primary_uom_code ,location_control_code ,restrict_locators_code ,restrict_subinventories_code ,msi.inventory_item_id ,lot_control_code, serial_number_control_code ,revision_qty_control_code ,eam_item_type ,msi.inventory_item_id as InventoryItem ,msi.padded_concatenated_segments item_code_segment1 ,msi.description item_description ,moh.subinventory_code sub_inventory_name ,moh.primary_transaction_quantity total_qoh ,SFI_EAM_tranqty(moh.organization_id,msi.inventory_item_id) Available_to_transact ,mil.segment1 LOCATOR ,mcr.cross_reference ,cst.item_cost FROM mtl_system_items_kfv msi, mtl_onhand_quantities_detail moh, apps.mtl_item_locations mil, apps.mtl_cross_references mcr, apps.cst_item_costs cst WHERE stock_enabled_flag = 'Y' AND bom_item_type = 4 AND (eam_item_type IS NULL OR eam_item_type = 3) AND moh.inventory_item_id(+) = msi.inventory_item_id AND moh.organization_id(+) = msi.organization_id AND moh.locator_id = mil.inventory_location_id(+) AND moh.organization_id = mcr.organization_id(+) AND mcr.cross_reference_type(+) = 'SFI_MRO_OLD_PART_NUM' AND moh.inventory_item_id = mcr.inventory_item_id(+) AND msi.inventory_item_status_code != 'Inactive' AND msi.item_type != 'AG' AND msi.item_type != 'AA' AND msi.item_type != 'OP' AND moh.inventory_item_id = cst.inventory_item_id AND moh.organization_id = cst.organization_id order by total_qoh desc) QRSLT WHERE (organization_id = (select distinct organization_id from wip_discrete_jobs where wip_entity_id = :1))
  3. 0

    SEPL and VO Extension

    Oracle Community | 9 years ago | 567494
    oracle.apps.fnd.framework.OAException: Message not found. Application: FND, Message Name: FND_VIEWOBJECT_NOT_FOUND. Tokens: VONAME = xxEYReqSummaryVO; APPLICATION_MODULE = oracle.apps.icx.por.req.server.RequisitionAM;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Tycast error in Extension

    Oracle Community | 8 years ago | 568541
    oracle.apps.fnd.framework.OAException: The application id or shortname (abc) you entered does not exist.
  6. 0

    db:: 3.55::FND_MESSAGE.PUT 1c

    hivmr.com | 10 months ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = null; (Could not lookup message because there is no database connection)

    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 concatenated_segments , msi.description , msi.organization_id , primary_uom_code , location_control_code , restrict_locators_code , restrict_subinventories_code , lot_control_code , serial_number_control_code , revision_qty_control_code , eam_item_type , msi.inventory_item_id , msi.padded_concatenated_segments item_code_segment1 , msi.description item_description , mOH.LOCATOR_ID , cst.item_cost , moh.subinventory_code sub_inventory_name , mil.segment1 LOCATOR , mcr.cross_reference , xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_id) Available_to_transact , sum(moh.primary_transaction_quantity) total_qoh FROM mtl_system_items_kfv msi, mtl_onhand_quantities_detail moh, apps.mtl_item_locations mil, apps.mtl_cross_references mcr, apps.cst_item_costs cst WHERE stock_enabled_flag = 'Y' AND bom_item_type = 4 AND (eam_item_type IS NULL OR eam_item_type = 3) AND moh.inventory_item_id(+) = msi.inventory_item_id AND moh.organization_id(+) = msi.organization_id AND moh.locator_id = mil.inventory_location_id(+) AND moh.organization_id = mcr.organization_id(+) AND mcr.cross_reference_type(+) = 'SFI_MRO_OLD_PART_NUM' AND moh.inventory_item_id = mcr.inventory_item_id(+) AND msi.inventory_item_status_code != 'Inactive' AND msi.item_type != 'AG' AND msi.item_type != 'AA' AND msi.item_type != 'OP' AND moh.inventory_item_id = cst.inventory_item_id AND moh.organization_id = cst.organization_id --and moh.organization_id =3159 -- and moh.INVENTORY_ITEM_ID = 8073 group by moh.subinventory_code ,concatenated_segments, msi.description, msi.organization_id, primary_uom_code, location_control_code, restrict_locators_code, restrict_subinventories_code, msi.inventory_item_id, lot_control_code, serial_number_control_code, revision_qty_control_code, eam_item_type, msi.inventory_item_id , msi.padded_concatenated_segments , msi.description , MOH.LOCATOR_ID, mil.segment1 , mcr.cross_reference, cst.item_cost, xxsfipackagevoext.SFI_EAM_tranqty(moh.organization_id,moh.subinventory_code ,moh.LOCATOR_ID,msi.inventory_item_id) order by total_qoh desc) QRSLT WHERE (organization_id = (select distinct organization_id from wip_discrete_jobs where wip_entity_id = :1))

      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:2704)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
      7 frames
    3. oa_html
      _OA._jspService
      1. oa_html._OA._jspService(_OA.java:84)
      1 frame
    4. oracle.jsp.runtime
      HttpJsp.service
      1. oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
      1 frame
    5. oracle.jsp.app
      JspApplication.dispatchRequest
      1. oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
      1 frame
    6. oracle.jsp
      JspServlet.service
      1. oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
      2. oracle.jsp.JspServlet.internalService(JspServlet.java:186)
      3. oracle.jsp.JspServlet.service(JspServlet.java:156)
      3 frames
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      1 frame
    8. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame