0 Replies Latest reply on Jul 12, 2019 1:43 AM by user5108636

    MessageLOVInput and bind variables

    user5108636

      Is it possible to create a MessageLOVInput based on VO query with bind variables. The error stack is as below.

       

      oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (select account_number,

             bill_cust_name,

             bill_city,

             trx_type_name,

             trx_number, 

             trx_date,

             invoice_currency_code,

             term_due_date_from_ps,

             d_inv_all_amount,

             balance,

             (case sign(balance - :p_apply_amount) when -1 then 'N' else 'Y' end) apply_enabled

      from ACC_TRX

      where COMPLETE_FLAG = 'YES'

      and trx_class = 'INV'

      and balance > 0) QRSLT  WHERE (( UPPER(BILL_CUST_NAME)  like UPPER(:3) AND (BILL_CUST_NAME  like  :4 OR BILL_CUST_NAME  like  :5 OR BILL_CUST_NAME  like  :6 OR BILL_CUST_NAME  like  :7))) ORDER BY bill_cust_name,trx_number

          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.processFormRequest(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:73)

          at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)

          at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473)

          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:734)

          at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)

          at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)

          at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)

          at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:226)

          at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:127)

          at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:116)

          at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)

          at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)

          at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)

          at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)

          at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

          at java.lang.Thread.run(Thread.java:662)

      ## Detail 0 ##

      java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: 1

          at oracle.jdbc.driver.OraclePreparedStatement.setObjectAtName(OraclePreparedStatement.java:15805)

          at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObjectAtName(OraclePreparedStatementWrapper.java:907)

          at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3966)

          at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)

          at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:14008)

          at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)

          at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)