HTML link/hyperlink in BI publisher

Nicklas Bergström - Oracle-Oracle

Summary

HTML link/hyperlink in BI publisher

Content

Hi,

I want to include a hyperlink in my BI publisher template. The output should be HTML and be sent as an email.

What I want to achieve is to include a link from the XML used to render the report as a hyperlink. In other words, I do not want to entire URL to be displayed in the email, I just want a text like "Link" to include the URL and direct the user to the URL when clicking on "Link".

I have read , but as the person asking the question there I am having issues with the code below, since it directs me to my own C: drive instead of the external destination.

<fo:basic-link external-destination="{ELEMENT_NAME}"><br/><fo:inline text-decoration="underline">google Link</fo:inline><br/></fo:basic-link>

Can someone please give some hints on how to solve this?

Best regards

//Nicklas

Nicklas Bergström - Oracle-Oracle

Thank you Sherry. That works as expected.

Sherry George

Can you try using the complete path in the template like this {DATA_DS/PURCHASEDOCUMENTEMAILSET/URL}

Nicklas Bergström - Oracle-Oracle

Hi Sherry,

Sample XML:

<?xml version="1.0" encoding="UTF-8"?>

<!--Generated by Oracle BI Publisher 11.1.1.9.0 -Dataengine, datamodel:_Procurement_Purchasing_Data_Models_PurchaseDocumentEmailDm_xdm -->

<DATA_DS>

   <PURCHASEDOCUMENTEMAILSET>

      <DOCUMENTTYPE>Purchase Order</DOCUMENTTYPE>

      <DOCUMENTNUMBER>12345</DOCUMENTNUMBER>

      <DOCUMENTSTYLE>Purchase Order</DOCUMENTSTYLE>

      <CHANGEORDERNUMBER>0</CHANGEORDERNUMBER>

      <PROCUREMENTBUNAME>XXX BU</PROCUREMENTBUNAME>

      <REQUISITIONINGBUNAME>XXX BU</REQUISITIONINGBUNAME>

      <BUYERNAME>Firstname Lastname</BUYERNAME>

      <CANCELFLAG>N</CANCELFLAG>

      <REVISIONNUMBER>0</REVISIONNUMBER>

      <SHIPTOLOCATION>XXX LOCATION</SHIPTOLOCATION>

      <COMPANYNAME>Company XXX</COMPANYNAME>

      <BUYEREMAIL>email@email.email</BUYEREMAIL>

      <SUPPLIERNAME>Company ZZZ</SUPPLIERNAME>

      <NOTE_TO_SUPPLIER>NOTE</NOTE_TO_SUPPLIER>

      <SUPPLIER_ORGANIZATION_NUMBER>12345</SUPPLIER_ORGANIZATION_NUMBER>

      <COMPANY_ORGANIZATION_NUMBER>98765</COMPANY_ORGANIZATION_NUMBER>

      <BUYER_POSITION>Buyer</BUYER_POSITION>

      <DNU_SOLD_TO_LE>Company XXX</DNU_SOLD_TO_LE>

      <DNU_ENTERPRISE_NAME>XXX group</DNU_ENTERPRISE_NAME>

      <COMPANY_REGISTRATION_NUMBER>98765</COMPANY_REGISTRATION_NUMBER>

      <DNU_COMPANY_ADDRESS>Address 123</DNU_COMPANY_ADDRESS>

      <DNU_ORDER_TOTAL>100.00</DNU_ORDER_TOTAL>

      <E_MAIL_ADDRESS_BEFORE_OVERRIDE>N</E_MAIL_ADDRESS_BEFORE_OVERRIDE>

      <DNU_SUPPLIER_ADDRESS>Address 123</DNU_SUPPLIER_ADDRESS>

      <URL>https://google.com</URL>

   </PURCHASEDOCUMENTEMAILSET>

</DATA_DS>

The template is "Purchase Order E-mail Body Template" in Fusion R12.

It is the link in the URL I want to reference in the template. The link will be different for every PO, hence we cannot create a hyperlink directly in the template.

Best regards

//Nicklas

Sherry George

Can you provide a sample XML and what type of template are you using?