8 Replies Latest reply on Mar 21, 2011 5:54 PM by 849108

    Standard Class code fails if we extend the Class

    797277
      I have a standard class A. I have a need to extend Class A. I extendend class A and called super.processRequest. But when I call super.processRequest, the code in Class A executs. But here it is calling localObject1 = getParameters(paramOAPageContext, paramOAWebBean); and passing the object to another method where it passes these variables to a View Object using setWhereClauseParams and executes the ViewObject. Here I am getting the error.
      Below is the exact error message:

      JBO-27122: SQL error during statement preparation.

      java.sql.SQLException: Missing IN or OUT parameter at index:: 1

      The same code works good if we don't extend the Class. In Both Cases the standard class only getting called, then how the error is happening when we extend the class.

      Any help is appreciated.

      Thanks,
      HC.
        • 1. Re: Standard Class code fails if we extend the Class
          797277
          Here is the total error message

          oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT bp.vendor_site_id,
          (bp.vendor_site_code
          || ' - '
          || ps.ADDRESS_LINE1
          || DECODE (ps.ADDRESS_LINE1,NULL,NULL,', ')
          || ps.ADDRESS_LINE2
          || DECODE (ps.ADDRESS_LINE2,NULL,NULL,', ')
          || ps.ADDRESS_LINE3
          || DECODE (ps.ADDRESS_LINE3,NULL,NULL,', ')
          || ps.ADDRESS_LINE4
          || DECODE (ps.ADDRESS_LINE4,NULL,NULL,', ')
          || ps.CITY
          || DECODE (ps.CITY,NULL,NULL,', ')
          || ps.STATE
          || ' '
          || ps.ZIP
          || DECODE (ps.ZIP,NULL,NULL,DECODE (ps.STATE,NULL,NULL,', '))
          || DECODE(ps.COUNTRY, NULL, ps.PROVINCE, ps.COUNTRY)) vendor_site_code
          FROM pon_bidding_parties bp ,
          pon_auction_headers_all ah,
          po_vendor_sites_all ps
          WHERE bp.auction_header_id = :1
          AND ah.auction_header_id = bp.auction_header_id
          AND bp.trading_partner_id = :2
          AND ps.vendor_site_id = bp.vendor_site_id
          AND
          (
          (
          ah.bid_frequency_code='SINGLE_BID_ONLY'
          AND bp.vendor_site_id NOT IN ( NVL(
          (SELECT bh.vendor_site_id
          FROM pon_bid_headers bh
          WHERE bh.auction_header_id = :3
          AND bh.trading_partner_id = :4
          AND bh.bid_status ='ACTIVE'
          )
          , -1)
          ,
          -1)
          )
          OR
          (
          ah.bid_frequency_code!='SINGLE_BID_ONLY'
          AND bp.vendor_site_id NOT IN (-1)
          )
          )
          ORDER BY bp.vendor_site_code
               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.OAPageBean.renderDocument(OAPageBean.java:3247)
               at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)
               at OA.jspService(_OA.java:228)
               at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
               at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
               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.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
               at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
               at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
               at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
               at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
               at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
               at OA.jspService(_OA.java:221)
               at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
               at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
               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.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
               at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
               at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
               at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
               at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
               at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
               at OA.jspService(_OA.java:221)
               at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
               at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
               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: Missing IN or OUT parameter at index:: 1
               at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
               at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
               at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
               at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
               at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
               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.webui.OAWebBeanPickListHelper.createListDataObject(OAWebBeanPickListHelper.java:992)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getListDataObject(OAWebBeanPickListHelper.java:837)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(OAWebBeanPickListHelper.java:465)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(OAWebBeanPickListHelper.java:404)
               at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getList(OAMessageChoiceBean.java:762)
               at oracle.apps.fnd.framework.webui.OADataBoundValuePickListData.getValue(OADataBoundValuePickListData.java:86)
               at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809)
               at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(OAMessageChoiceBean.java:369)
               at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
               at oracle.apps.fnd.framework.webui.OADataBoundValuePickListSelectionIndex.getValue(OADataBoundValuePickListSelectionIndex.java:61)
               at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809)
               at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(OAMessageChoiceBean.java:369)
               at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
               at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source)
               at oracle.cabo.ui.collection.AttributeMapProxy.getAttribute(Unknown Source)
               at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source)
               at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
               at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source)
               at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source)
               at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
               at oracle.cabo.ui.laf.base.BaseLafUtils.getLocalAttribute(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.OptionContainerRenderer.getSelectedIndex(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.OptionContainerRenderer.populateOptionInfo(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.OptionContainerRenderer.createOptionInfo(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.OptionContainerRenderer.prerender(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.ChoiceRenderer.prerender(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.FormElementRenderer.render(Unknown Source)
               at oracle.apps.fnd.framework.webui.OARendererProxy.render(OARendererProxy.java:76)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListRendererProxy.render(OAWebBeanPickListRendererProxy.java:66)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderNamedChild(Unknown Source)
               at oracle.cabo.ui.laf.base.SwitcherRenderer._renderCase(Unknown Source)
               at oracle.cabo.ui.laf.base.SwitcherRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
               at oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source)
               at oracle.apps.fnd.framework.webui.OARendererProxy.render(OARendererProxy.java:76)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListRendererProxy.render(OAWebBeanPickListRendererProxy.java:66)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.RowLayoutRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.InlineMessageRenderer.render(Unknown Source)
               at oracle.apps.fnd.framework.webui.OARendererProxy.render(OARendererProxy.java:76)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListRendererProxy.render(OAWebBeanPickListRendererProxy.java:66)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer.renderColumn(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer._renderColumns(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.MessageComponentLayoutRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.RowLayoutRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.laf.swan.desktop.SubTabLayoutRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.composite.ContextPoppingUINode$ContextPoppingRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.BorderLayoutRenderer.renderIndexedChildren(Unknown Source)
               at oracle.cabo.ui.laf.swan.desktop.ContentRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.composite.UINodeRenderer.renderWithNode(Unknown Source)
               at oracle.cabo.ui.composite.UINodeRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.oracle.desktop.PageLayoutRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.XhtmlLafRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.BodyRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.apps.fnd.framework.webui.beans.OABodyBean.render(OABodyBean.java:403)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderIndexedChild(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.renderContent(Unknown Source)
               at oracle.cabo.ui.BaseRenderer.render(Unknown Source)
               at oracle.cabo.ui.laf.base.xhtml.DocumentRenderer.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.BaseUINode.render(Unknown Source)
               at oracle.cabo.ui.partial.PartialPageUtils.renderPartialPage(Unknown Source)
               at oracle.apps.fnd.framework.webui.OAPageBean.render(OAPageBean.java:3591)
               at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3237)
               at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)
               at OA.jspService(_OA.java:228)
               at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
               at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
               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.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
               at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
               at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
               at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
               at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
               at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
               at OA.jspService(_OA.java:221)
               at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
               at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
               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.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280)
               at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68)
               at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214)
               at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284)
               at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219)
               at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395)
               at OA.jspService(_OA.java:221)
               at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
               at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
               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: Missing IN or OUT parameter at index:: 1
               at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1752)
               at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3444)
               at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
               at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
               at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860)
               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.webui.OAWebBeanPickListHelper.createListDataObject(OAWebBeanPickListHelper.java:992)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getListDataObject(OAWebBeanPickListHelper.java:837)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(OAWebBeanPickListHelper.java:465)
               at oracle.apps.fnd.framework.webui.OAWebBeanPickListHelper.getList(OAWebBeanPickListHelper.java:404)
               at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getList(OAMessageChoiceBean.java:762)
               at oracle.apps.fnd.framework.webui.OADataBoundValuePickListData.getValue(OADataBoundValuePickListData.java:86)
               at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809)
               at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(OAMessageChoiceBean.java:369)
               at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
               at oracle.apps.fnd.framework.webui.OADataBoundValuePickListSelectionIndex.getValue(OADataBoundValuePickListSelectionIndex.java:61)
               at oracle.apps.fnd.framework.webui.OAWebBeanHelper.getAttributeValueImpl(OAWebBeanHelper.java:1809)
               at oracle.apps.fnd.framework.webui.beans.message.OAMessageChoiceBean.getAttributeValueImpl(OAMessageChoiceBean.java:369)
               at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
               at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source)
               at oracle.cabo.ui.collection.AttributeMapProxy.getAttribute(Unknown Source)
               at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source)
               at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
               at oracle.cabo.ui.collection.UINodeAttributeMap.getAttribute(Unknown Source)
               at oracle.cabo.ui.BaseUINode.getAttributeValueImpl(Unknown Source)
               at oracle.cabo.ui.BaseUINode.getAttributeValue(Unknown Source)
          • 2. Re: Standard Class code fails if we extend the Class
            797277
            the code where it is failing:
            parameHashMap is the object that we passed. The object is created by using getParameters....

            Number localNumber1 = (Number)paramHashMap.get("auctionHeaderId");
            Number localNumber2 = (Number)paramHashMap.get("tpId");


            OAViewObject localOAViewObject = (OAViewObject)localResponseAM.findViewObject("SiteValueForBiddingVO");
            if ((localOAViewObject != null) && (!localOAViewObject.isPreparedForExecution()))
            {
            localOAViewObject.clearCache();
            localOAViewObject.setWhereClauseParams(null);
            localOAViewObject.setWhereClauseParam(0, localNumber1);
            localOAViewObject.setWhereClauseParam(1, localNumber2);
            localOAViewObject.setWhereClauseParam(2, localNumber1);
            localOAViewObject.setWhereClauseParam(3, localNumber2);
            localOAViewObject.executeQuery();
            localOAViewObject.reset();
            }
            • 3. Re: Standard Class code fails if we extend the Class
              MeherIrk
              Hi,

              can u send extended co code..

              Regards
              Meher Irk
              • 4. Re: Standard Class code fails if we extend the Class
                MeherIrk
                Hi,

                ---Dont set the where class params to null

                Modify ur code:

                if(localNumber1 != null && localNumber2 && localNumber3 != null)
                {
                localOAViewObject.setWhereClauseParam(0, localNumber1);
                localOAViewObject.setWhereClauseParam(1, localNumber2);
                localOAViewObject.setWhereClauseParam(2, localNumber1);
                localOAViewObject.setWhereClauseParam(3, localNumber2);
                localOAViewObject.clearCache();

                localOAViewObject.executeQuery();
                }
                else
                {

                }

                Regards
                Meher Irk
                • 5. Re: Standard Class code fails if we extend the Class
                  797277
                  Hi Meher,

                  The code that I pasted is in standard class code. I can't modify that code.

                  Here is the extended CO Code.

                  public void processRequest(OAPageContext paramOAPageContext, OAWebBean paramOAWebBean)
                  {
                  super.processRequest(paramOAPageContext, paramOAWebBean);
                  OAMessageStyledTextBean shipTo =
                  (OAMessageStyledTextBean)paramOAWebBean.findChildRecursive("ShipToAddress");
                  shipTo.setRendered(false);

                  OAMessageStyledTextBean BidStartPrice =
                  (OAMessageStyledTextBean)paramOAWebBean.findChildRecursive("BidStartPrice");
                  BidStartPrice.setRendered(false);

                  }

                  Thanks,
                  HC
                  • 6. Re: Standard Class code fails if we extend the Class
                    844478
                    Same issue

                    Edited by: 841475 on Mar 9, 2011 8:23 AM
                    • 7. Re: Standard Class code fails if we extend the Class
                      844478
                      Hi Meher,

                      Iam also facing same issue please help me on this.

                      Jag
                      • 8. Re: Standard Class code fails if we extend the Class
                        849108
                        Hi,

                        Try adding process form request also in the extended controller. The issue should be resolved.


                        Regards,
                        kavya