2 Replies Latest reply on Jul 5, 2010 11:08 AM by user11334254

    Getting error while sending PunchoutSetupResponse to Orace iProcurement

    767168
      Hi,

      we are working with Oracle iProcurement and configured Supplier website. we are able to Validate the PunchoutSetupRequest in .Net application with out any fail. After validating the PucnhoutSetupRequest, trying to send PunchoutSetupResponse to the same iProcurement server. but we are getting the below error in application track trace:

      Response:
      _____________________________________________________________________________________

      <div CLASS="errorText">


      <html lang="en-US">
      <head>
      <script>
      function ignoreWarnAboutChanges(url)
      {
      document.location.href = url;
      }
      </script>
      <title>Error Page</title>
      <link rel="stylesheet" charset="UTF-8" type="text/css" href="/OA_HTML/cabo/styles/blaf.css">
      <META name="fwk-error" content="Error occured while processing the request">


      <META name="fwk-error-detail" content="oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_URL_HAS_NO_ICX_SESSION_ID. (Could not lookup message because there is no database connection)
           at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1227)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1960)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
           at _oa__html._OA._jspService(_OA.java:88)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at _oa__html._OA._jspService(_OA.java:98)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      ## Detail 0 ##
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_URL_HAS_NO_ICX_SESSION_ID. (Could not lookup message because there is no database connection)
           at oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookie(OAJSPHelper.java:303)
           at oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookie(OAJSPHelper.java:240)
           at oracle.apps.fnd.framework.webui.OAPageBean.createRFURL(OAPageBean.java:5921)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:712)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
           at _oa__html._OA._jspService(_OA.java:88)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at _oa__html._OA._jspService(_OA.java:98)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_URL_HAS_NO_ICX_SESSION_ID. (Could not lookup message because there is no database connection)
           at oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookie(OAJSPHelper.java:303)
           at oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookie(OAJSPHelper.java:240)
           at oracle.apps.fnd.framework.webui.OAPageBean.createRFURL(OAPageBean.java:5921)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:712)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:497)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:418)
           at _oa__html._OA._jspService(_OA.java:88)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at _oa__html._OA._jspService(_OA.java:98)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:534)
      ">


      </head>
      <body>



      <table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr> <td><img src="/OA_MEDIA/FNDSSCORP.gif" alt=""> </td></tr>
      <tr> <td> </td>

      <td> Logout</td>

      </tr>
      <tr> <td width="100%" nowrap class="OraBGColorDark" >  </td> </tr>
      </table>
      <p>




      <center>
      <table width="95%" border="0" cellspacing="0" class="OraBGAccentDark" cellpadding="0">

      <tr> <td>   </td> </tr>
      <!-- <tr> <td class="OraErrorHeader"> <img src=/OA_HTML/cabo/images/errorl.gif> Error Page </td> </tr> -->
      <tr> <td class="OraErrorHeader"> <center> Error Page </center> </td> </tr>
      <tr> <td colspan=2 class="OraBGColorDark"> </td> </tr>
      <tr> <td>   </td> </tr>
      <tr> <td colspan=2 class="OraErrorText" >You have encountered an unexpected error. Please
      contact the System Administrator for assistance. </td> </tr>

      <tr> <td colspan=2 class="OraErrorText"> Click here for exception details.
      </td> </tr>

      </table>
      </center>

      </div>
      </body>
      </html>
      ________________________________________________________________________________________

      we are getting(capturing) the BrowserFormPost from PunchoutSetupRequest. and sending PuchoutSetupResponse to the same captured browserFormPost. but we are getting the above mentioned error in application track trace(.Net application). and in the Oracle iProcurement we are getting below error:

      ---------------------------------------------------------------------------------------------------------------------------
      Error Code: 701 Misc Login Failures
      Login failed : unable to get supplier login url from login response
      Return Code: null
      Return Message: null

      ---------------------------------------------------------------------------------------------------------------------------

      can you please help us on this issue.

      we appreciate your help in advance.

      Thank you.

      Regards,
      Raghuveer