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