oracle.apps.fnd.framework.OAException: 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 msi.inventory_item_id from Bom_structures_b bbm , Bom_components_b bic , mtl_system_items msi where bbm.bill_Sequence_id = bic.bill_sequence_id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbm.organization_id and ( msi.description like '%Inplan%' or msi.description like '%Overage%') and bbm.organization_id = 1406 start with bbm.assembly_item_id = :1 connect by prior bic.component_item_id = bbm.assembly_item_id minus select INVENTORY_ITEM_ID from CL_ADD_PROD_CONT where chr_id = :2 ) c where a.inventory_item_id = c.inventory_item_id and to_char(a.inventory_item_id) = b.PRODUCT_ATTR_VALUE and b.list_header_id =7007) QRSLT WHERE (( UPPER(SEGMENT1) like :1 AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))

Oracle Community | user633859 | 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

    How to bind the variables to LOV which is in Advanced table

    Oracle Community | 4 years ago | user633859
    oracle.apps.fnd.framework.OAException: 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 msi.inventory_item_id from Bom_structures_b bbm , Bom_components_b bic , mtl_system_items msi where bbm.bill_Sequence_id = bic.bill_sequence_id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbm.organization_id and ( msi.description like '%Inplan%' or msi.description like '%Overage%') and bbm.organization_id = 1406 start with bbm.assembly_item_id = :1 connect by prior bic.component_item_id = bbm.assembly_item_id minus select INVENTORY_ITEM_ID from CL_ADD_PROD_CONT where chr_id = :2 ) c where a.inventory_item_id = c.inventory_item_id and to_char(a.inventory_item_id) = b.PRODUCT_ATTR_VALUE and b.list_header_id =7007) QRSLT WHERE (( UPPER(SEGMENT1) like :1 AND (SEGMENT1 like :2 OR SEGMENT1 like :3 OR SEGMENT1 like :4 OR SEGMENT1 like :5)))
  2. 0

    OAF Help - validation on iprocurnment Page

    Oracle Community | 6 years ago | user12167189
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  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 a.inventory_item_id,a.segment1,a.description ,b.OPERAND unit_price from mtl_system_items_b a, qp_list_lines_v b, (select msi.inventory_item_id from Bom_structures_b bbm , Bom_components_b bic , mtl_system_items msi where bbm.bill_Sequence_id = bic.bill_sequence_id and msi.inventory_item_id = bic.component_item_id and msi.organization_id = bbm.organization_id and ( msi.description like '%Inplan%' or msi.description like '%Overage%') and bbm.organization_id = 1406 start with bbm.assembly_item_id = :1 connect by prior bic.component_item_id = bbm.assembly_item_id minus select INVENTORY_ITEM_ID from CL_ADD_PROD_CONT where chr_id = :2 ) c where a.inventory_item_id = c.inventory_item_id and to_char(a.inventory_item_id) = b.PRODUCT_ATTR_VALUE and b.list_header_id =7007) QRSLT WHERE (( UPPER(SEGMENT1) like :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(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:2680)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1683)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430)
      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:619)
      1 frame