9 Replies Latest reply: Jun 26, 2012 7:03 AM by 943606 RSS

    Clicking on LOV getting the error JBO-27122:

    943606
      Hi All

      I created on VO.

      VO's SQL
      select vendor_id,vendor_name
      from po_vendors
      in my page created
      1. LOV item (itemid: vendorName)
      2. form value (itemid: vendorId)
      Now defined mapping as below

      Mapping1:
      LOV Region Item : VendorNameLOV ( this is the LOV region's itemId)
      Return Item: vendorName (Base page itemId)
      Criteria Item: vendorName (Base page itemId)
      Mapping2:
      LOV Region Item : VendorIdLOV ( this is the LOV region's itemId)
      Return Item: vendorId (Base page itemId)
      Criteria Item: vendorName (Base page LOV Item's itemId)
      Issue is when i enter A% in my LOV item and tab out i am getting the below error :
      -------------------------------------------------------------------------------------------
      oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select vendor_id,vendor_name from po_vendors) QRSLT WHERE (( VENDOR_ID = :1 AND UPPER(VENDOR_NAME) like UPPER(:2) AND (VENDOR_NAME like :3 OR VENDOR_NAME like :4 OR VENDOR_NAME like :5 OR VENDOR_NAME like :6))) at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at OA.jspService(_OA.java:71) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595) ## Detail 0 ## java.sql.SQLException: ORA-01722: invalid number

      The issue is whatever search criteria i am entering it is taking that and comparing with vendorid and that is why it is erroring out. Ideally it should compare whatever i enter in LOV item against vendorname. Please note that if i change the mapping to :

      Mapping2:
      LOV Region Item : VendorIdLOV ( this is the LOV region's itemId)
      Return Item: vendorId (Base page itemId)
      ----------------------------------------------------------------------------------------
      Criteria Item: vendorName (Base page LOV Item's itemId)
      ----------------------------------------------------------------------------------------
      if i remove above property then all is working fine though i am getting developer mode exception saying LOV item should be querable criteria.......Please help.