Purchasing

Get Involved. Join the Conversation.

Topic

    Minna Muikku
    Unable to navigate to PO from report, link not working
    Topic posted February 1, 2019 by Minna MuikkuSilver Medal: 2,000+ Points, last edited February 1, 2019, tagged Business Intelligence, How-To 
    106 Views, 3 Comments
    Title:
    Unable to navigate to PO from report, link not working
    Summary:
    I tried to create a link as per Doc ID 2444555.1 but the link takes me to a blank "View Order" page
    Content:

    Hi all,

    In 18C a new feature was introduced where you can set up a link in OTBI analysis to navigate to purchase order straight from the report ("Navigate to Purchasing Transactions from Reports") I tried to create a link as instructed, but all I got is a blank "View" page. 

    Here's a link to the release note 18c where the feature is described; https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/r13-2018-procurement-wn.htm#F3686

    Here's the note that gives the steps in detail: Navigate to Purchasing Transactions from Reports (Doc ID 2444555.1)

    Here's what I did:

    1. I have a report that has attributes 'Order Number' and 'PO Header Id' (from subject area Procurement - Purchasing Real Time)

    2. I changed the data format of the 'PO Header Id' attribute to not have any decimals (because this usually creates issues in deep links)

    3. For attribute 'Order Number', I changed the column formula to (xxxx is hostname) '<a href= https://xxxx/fndSetup/faces/deeplink?objType=PURCHASE_ORDER&objKey=poH eaderId='|| CAST("Purchase Order Header Detail"."PO Header Id" AS char)||'>'||"Purchase Order Header Detail"."Order"||'</a>'  and changed the data format to 'Treat text as HTML' (as advised on the note). 

    After this, when I click the PO number on the report, the link should  take me to the View Order page of the certain order, but all I get is blank view order page (see screenshot attached)

    I must have gotten some steps wrong. I believe this cannot be a role/data access issue. Any tips?

     

     

     

     

     

    Comment

     

    • Niamath Jeddy

      Minna,

      I tried the link as per oracle document and it worked for me.

      In your case, i notice a space in your url 'poH eaderId'. Possible that the it is not working for you due to this space .

      Please remove the space in this text 'poH eaderId' and try.

      regards,

      Niamath

    • Minna Muikku

      Thanks Niamath! How didn't I spot that! surprise

      I tested and now it works. Do you have any tips how I could make the link open to separate window/tab, instead of opening to the same window?

       

      Br,

       

      Minna

    • Niamath Jeddy

      Minna,

      you will have to include the target="_blank" text in the href tag. for example:

      <a href="https://www.w3schools.com" target="_blank">Visit W3Schools</a>

       

       '<a href= https://xxxx/fndSetup/faces/deeplink?objType=PURCHASE_ORDER&objKey=poH eaderId='|| CAST("Purchase Order Header Detail"."PO Header Id" AS char)||'target="_blank">'||"Purchase Order Header Detail"."Order"||'</a>' 

      Try it out.

       

      regards,

      Niamath