2 Replies Latest reply on Jan 3, 2013 6:29 AM by Dharma_

    JBO-27122: SQL error during statement preparation. Statement: SELECT ibyprv

    Dharma_
      Dear all,

      Issue through at "Cash Management" Responsibility --> Bank Account Transfer --> Create --> General Information fill that mandatory fields -->Then click "Payment Details" -->Click Payment Reason --> It show LOV,we click Ok it through this below error....




      Exception Details.
      oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ibyprvl.PAYMENT_REASON_CODE,
      ibyprvl.MEANING,
           ibyprvl.DESCRIPTION,
           ibyprvl.territory_code,
      countries.territory_short_name
      FROM IBY_PAYMENT_REASONS_VL ibyprvl,
      fnd_territories_vl countries
      WHERE countries.territory_code(+)=ibyprvl.territory_code
      AND sysdate >= NVL(ibyprvl.INACTIVE_DATE,sysdate)
      /*and
      ((ibyprvl.territory_code is NULL) or
      (ibyprvl.territory_code in
      ( select hl.country from ap_supplier_sites_all assa, hz_party_sites hps, hz_locations hl
      where assa.vendor_site_id = :1
      and assa.party_site_id = hps.party_site_id
      and hps.location_id = hl.location_id)))*/
           at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
           at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
           at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
           at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
           at OA.jspService(_OA.java:204)
           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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
           at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
           at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
           at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
           at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
           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.AJPRequestHandler.run(AJPRequestHandler.java:313)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      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:619)
      ## Detail 0 ##
      java.sql.SQLException: Invalid column index
      at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5168)
      at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8098)
      at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
      at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)
      at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8748)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:230)
      at oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:1847)
      at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3893)
      at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
      at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:13827)
      at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
      at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
      at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723)
      at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
      at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
      at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
      at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
      at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
      at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
      at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
      at oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(OAViewObjectImpl.java:743)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(OAWebBeanHelper.java:2334)
      at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequestAfterController(OAListOfValuesHelper.java:1584)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:851)
      at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequest(OAListOfValuesHelper.java:1490)
      at oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processFormRequest(OAListOfValuesBean.java:423)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
      at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      at OA.jspService(_OA.java:204)
      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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
      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.AJPRequestHandler.run(AJPRequestHandler.java:313)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      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:619)
      java.sql.SQLException: Invalid column index
      at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5168)
      at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:8098)
      at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8034)
      at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8767)
      at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:8748)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:230)
      at oracle.jbo.server.BaseSQLBuilderImpl.bindParamValue(BaseSQLBuilderImpl.java:1847)
      at oracle.jbo.server.OracleSQLBuilderImpl.bindParamValue(OracleSQLBuilderImpl.java:3893)
      at oracle.jbo.server.BaseSQLBuilderImpl.bindParametersForStmt(BaseSQLBuilderImpl.java:3335)
      at oracle.jbo.server.ViewObjectImpl.bindParametersForCollection(ViewObjectImpl.java:13827)
      at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:804)
      at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669)
      at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723)
      at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source)
      at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560)
      at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743)
      at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892)
      at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806)
      at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800)
      at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643)
      at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439)
      at oracle.apps.fnd.framework.server.OAViewObjectImpl.initQuery(OAViewObjectImpl.java:743)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.setCriteriaOnVO(OAWebBeanHelper.java:2334)
      at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequestAfterController(OAListOfValuesHelper.java:1584)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:851)
      at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      at oracle.apps.fnd.framework.webui.OAListOfValuesHelper.processFormRequest(OAListOfValuesHelper.java:1490)
      at oracle.apps.fnd.framework.webui.beans.layout.OAListOfValuesBean.processFormRequest(OAListOfValuesBean.java:423)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
      at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
      at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      at oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      at OA.jspService(_OA.java:204)
      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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
      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.AJPRequestHandler.run(AJPRequestHandler.java:313)
      at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      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:619)


      Please gv solution for above issue

      Regards
      Dharma
        • 1. Re: JBO-27122: SQL error during statement preparation. Statement: SELECT ibyprv
          Sushant Sharma
          Hi,

          Is this a standard page ?
          If yes, then check if there are any customization done on this.
          If there are no customizations, then you should go for creating an SR for this.

          --Sushant                                                                                                                                                                                                                                                                                                                                                                                                   
          • 2. Re: JBO-27122: SQL error during statement preparation. Statement: SELECT ibyprv
            Dharma_
            Dear Sharma,

            Yes, this is Standard page. No,any customize done in this page.

            Regards
            Dharma