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
  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 | 8 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