oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT MS.SEGMENT1 FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MS WHERE CII.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID And cii.LAST_VLD_ORGANIZATION_ID = :1) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER( :1) ))

Oracle Community | MAHA REDDY | 3 years ago
  1. 0

    lov values not populated

    Oracle Community | 3 years ago | MAHA REDDY
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT MS.SEGMENT1 FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MS WHERE CII.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID And cii.LAST_VLD_ORGANIZATION_ID = :1) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER( :1) ))
  2. 0

    advanced table table action buttons are giving issue

    Oracle Community | 3 years ago | san-717
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: java.lang.Integer
  3. 0

    oracle.classloader.util.AnnotatedClassNotFoundException:  while running a custom page in local machine through Jdev

    Oracle Community | 3 years ago | Hemant Garg
    oracle.apps.fnd.framework.OAException: oracle.jbo.CustomClassNotFoundException: JBO-26022: Could not find and load the custom class who.oracle.apps.xxtrl.travelrequest.lov.server.XXTRL_TRTravellerLOVVOImpl
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OAF Page error after running the page

    Oracle Community | 2 years ago | 2718604
    oracle.apps.fnd.framework.OAException: oracle.jbo.RowCreateException: JBO-25017: Error while creating a new entity row for InsertEO.
  6. 0

    java.lang.NullPointerException

    Oracle Community | 1 year ago | Shahzad.H.Magsi
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    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 DISTINCT MS.SEGMENT1 FROM CSI_ITEM_INSTANCES CII, MTL_SYSTEM_ITEMS MS WHERE CII.INVENTORY_ITEM_ID = MS.INVENTORY_ITEM_ID And cii.LAST_VLD_ORGANIZATION_ID = :1) QRSLT WHERE (( UPPER(SEGMENT1) like UPPER( :1) ))

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormData(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7 frames
    3. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:71)
      1 frame
    4. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    5. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    7. com.evermind.server
      HttpRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
      5. com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221)
      6. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122)
      7. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111)
      7 frames
    8. oracle.oc4j.network
      ServerSocketAcceptHandler$AcceptHandlerHorse.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      2. oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
      3. oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
      4. oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
      4 frames
    9. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame