4 Replies Latest reply on Apr 16, 2010 12:27 PM by 767168

    Requisitions Details Description Line HyperLink in iProcurement

    618075
      Greetings to all,

      We are in the process of upgrade our instance form 11.5.9 to 11.5.10.2.

      In our test environment we have run into this problem. When we create a requisition from a punchout. We shop for the item on the vendor store bring it back to iProcurement Cart.

      The item is there and the description is a hyperlink. We do not have any problems with the requisition process but with the hyperlink.

      Once we clink on the hyperlink the following we get the following message:

      Warning


      The supplier may allow you to edit the configuration details for this item on the supplier site; however, your edits will not be saved on your requisition. To avoid discrepancies between your requisition and the supplier site, do not edit the configuration details.



      There is a Yes or No button. Clicking on Yes leads to the following message:

      Error

      Corporate Express: The connection to the supplier website cannot be established.

      Click here to view additional technical details of this failure.



      Clicking on the "additional technical" gives the following message:

      Error Code: 701 Misc Login Failures
      Login failed : unable to get supplier login url from login response
      Return Code: 403
      Return Message: Unable to pre-create E-Way Session
      Supplier Login URL: https://ib2b.cexp.com/invoke/process/receive_punchOutSetupRequest?partner=Ariba
      Supplier ID : 25
      Supplier Name : Corporate Express
      Supplier Admin :
      Login Request XML:
      <?xml version = '1.0' encoding = 'UTF-8'?>

      <!DOCTYPE cXML SYSTEM "http://xml.cxml.org/schemas/cXML/1.1.007/cXML.dtd">

      <cXML version="1.1.007" xml:lang="en-US" payloadID="20081119020621.138044171.-122826@nvciebizappred.nvci.org" timestamp="2008-11-19T02:06:21-08:00">

      <Header>

      <From>

      <Credential domain="NetworkID">

      <Identity>

      <![CDATA[ there was data here...removed for confidential reason]]>

      </Identity>

      </Credential>

      </From>

      <To>

      <Credential domain="DUNS">

      <Identity>

      <![CDATA[170368430]]>

      </Identity>

      </Credential>

      </To>

      <Sender>

      <Credential domain="NetworkID">

      <Identity>

      <![CDATA[NEVADACANCERINSTITUT]]>

      </Identity>

      <SharedSecret>*************************************************</SharedSecret>

      </Credential>

      <UserAgent>

      <![CDATA[Oracle iProcurement]]>

      </UserAgent>

      </Sender>

      </Header>

      <Request>

      <PunchOutSetupRequest operation="inspect">

      <ItemOut quantity="1">

      <SupplierPartID>

      <![CDATA[EXP141200W]]>

      </SupplierPartID>

      <SupplierPartAuxID/>

      </ItemOut>

      <BuyerCookie>

      <![CDATA[01227132381372]]>

      </BuyerCookie>

      <Extrinsic name="User">

      <![CDATA[my name here]]>

      </Extrinsic>

      <BrowserFormPost>

      <URL>

      <![CDATA[http://our web address here:8000/OA_HTML/OA.jsp?OAFunc=ICX_CAT_PUNCHOUT_CALLBACK&OAHP=ICX_POR_HOMEPAGE_MENU&OASF=ICX_CAT_PUNCHOUT_CALLBACK&transactionid=770502760]]>

      </URL>

      </BrowserFormPost>

      <Contact>

      <Name xml:lang="en-US">

      <![CDATA[my name here]]>

      </Name>

      <Email>

      <![CDATA[my email address here]]>

      </Email>

      </Contact>

      <SupplierSetup>

      <URL>

      <![CDATA[https://ib2b.cexp.com/invoke/process/receive_punchOutSetupRequest?partner=Ariba]]>

      </URL>

      </SupplierSetup>

      </PunchOutSetupRequest>

      </Request>

      </cXML>


      Login Response XML:
      <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE cXML SYSTEM "http://xml.cxml.org/schemas/cXML/1.1.009/cXML.dtd">
      <cXML version="1.1" payloadID="20081119.150615_521289_uscobrmfa-ap-20" timestamp="2008-11-19T15:06:15-07:00">
      <Response>
      <Status code="403" text="Unable to pre-create E-Way Session"/>
      <PunchOutSetupResponse>
      <StartPage>
      <URL/>
      </StartPage>
      </PunchOutSetupResponse>
      </Response>
      </cXML>



      Looking for any guidance on how to disable the hyperlink via profile option or how to make the hyperlink work.

      Edited by: KDF on Nov 19, 2008 3:57 PM

      Edited by: KDF on Nov 19, 2008 3:59 PM
        • 1. Re: Requisitions Details Description Line HyperLink in iProcurement
          Mike F -Oracle
          Hello,

          Better late than never.

          You can try this - to turn off the 'Re-Punchout' functionality - which is what you are experiencing.
          It is based on your catalog - tied to your store that you see in iProcurement.

          Sql plus run this -

          SELECT ipis.*
          FROM icx_por_item_sources ipis,
          icx_por_item_sources_tl ipis_tl
          WHERE ipis_tl.item_source_id = ipis.item_source_id AND
          ipis_tl.language = userenv('LANG')
          and item_source_name like '&catalog_name';

          This is the catalog that you created that is tied to your store which is your punchout.
          Take note of the item_source_id.


          Now, run this -

          update icx_por_item_sources
          set operation_allowed = 'create'
          where item_source_id = &item_source_id;
          commit;


          You will need to bounce the Apache web server after the update, but after the bounce - no more hyperlinks on your descriptions.


          Take care,

          Mike
          • 2. Re: Requisitions Details Description Line HyperLink in iProcurement
            Niels LM.
            See https://metalink.oracle.com/CSP/main/article?cmd=show&type=NOT&id=429131.1

            /Niels LM
            • 3. Re: Requisitions Details Description Line HyperLink in iProcurement
              Mike F -Oracle
              Unfortunately, note 429131.1 just hides the description, not really a solution.

              The solution given above will be seen in note 759423.1.

              Take care,
              Mike
              • 4. Re: Requisitions Details Description Line HyperLink in iProcurement
                767168
                Hi,

                I am new to this technology, need to integrate with ASP.Net (.Net framework). I am maintaining the supplier site and given punch-out site url to our buyer.
                On the landing page, I have written code like below:


                AppendStatus("\n Request Started"); // write the log file

                // Create a Stream object to capture entire InputStream from browser.
                Stream str = Request.InputStream;

                // Find number of bytes in stream.
                int strLen = (int)str.Length;

                if (strLen > 0)
                {
                // code related to validation of From DUNS, To DUNS and Sharedsec
                // sending login response
                AppendStatus(“\n String length > 0”);
                }

                From our buyer site we have received request one time and we were able to see “Request Started” content only in the log file. But any other log like Request.InputStream are not captured from the request object from buyer server.

                here is error i am getting from Buyer server:

                Error Code: 701 Misc Login Failures
                Login failed : unable to get supplier login url from login response
                Return Code: null
                Return Message: null
                Supplier Login URL: http://humana.sprintshops.com/punchout/processcxmlrequest.aspx
                Supplier ID : 664
                Supplier Name : Sprint
                Supplier Admin :
                Login Request XML:
                <?xml version = '1.0' encoding = 'UTF-8'?>
                <!DOCTYPE cXML SYSTEM "http://xml.cxml.org/schemas/cXML/1.1.007/cXML.dtd">
                <cXML version="1.1.007" xml:lang="en-US" payloadID="20100415085517.735123017.2579@oaphrb.humana.com" timestamp="2010-04-15T08:55:17-05:00">
                <Header>
                <From>
                <Credential domain="DUNS">
                <Identity>dddddd</Identity>
                </Credential>
                </From>
                <To>
                <Credential domain="DUNS">
                <Identity>ddddd</Identity>
                </Credential>
                </To>
                <Sender>
                <Credential domain="DUNS">
                <Identity>ddddd</Identity>
                <SharedSecret>********</SharedSecret>
                </Credential>
                <UserAgent>Oracle iProcurement</UserAgent>
                </Sender>
                </Header>
                <Request>
                <PunchOutSetupRequest operation="create">
                <BuyerCookie>dddddddd</BuyerCookie>
                <Extrinsic name="User">dddd</Extrinsic>
                <BrowserFormPost>
                <URL>https://oaphrb.humana.com:443/OA_HTML/OA.jsp?OAFunc=ICX_CAT_PUNCHOUT_CALLBACK&OAHP=ICX_POR_HOMEPAGE_MENU&OASF=ICX_CAT_PUNCHOUT_CALLBACK&transactionid=732093066</URL>
                </BrowserFormPost>
                <Contact>
                <Name xml:lang="en-US">Raque, Mr. Bradley T. (Brad)</Name>
                <Email>braque@humana.com</Email>
                </Contact>
                <SupplierSetup>
                <URL>http://humana.sprintshops.com/punchout/processcxmlrequest.aspx</URL>
                </SupplierSetup>
                </PunchOutSetupRequest>
                </Request>
                </cXML>

                Login Response XML:
                <html><head><title>Object moved</title></head><body>

                <h2>Object moved to here.</h2>

                </body></html>


                Can you please let us know, how the request object will come to supplier site from Buyer server. do you have any specific code snippet to capture the request object?

                I will appreciate you help in advance.

                Thank you.

                Regards,
                Raghuveer