oracle.apps.fnd.framework.OAException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • OAF Help - validation on iprocurnment Page
    via by user12167189,
  • SEPL and VO Extension
    via by 567494,
  • Tycast error in Extension
    via by 568541,
  • db:: 3.55::FND_MESSAGE.PUT 1c
    via by Unknown author,
  • server.xml missing - can I still change the VO?
    via by Asmirnov-Oracle,
  • Changing VO with Substitution results in JBO-25002
    via by kevin.bouwmeester,
    • 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(OAException.java:891) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2680) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1683) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:509) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:430) at oa_html._OA._jspService(_OA.java:84) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119) at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267) at oracle.jsp.JspServlet.internalService(JspServlet.java:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnection.java:294) at java.lang.Thread.run(Thread.java:619)

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    14 more bugmates