HTML link/hyperlink in BI publisher

Nicklas Bergström - Oracle-Oracle · May 30, 2017 7:00AM

Summary

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 · May 30, 2017 7:00AM

Thank you Sherry. That works as expected.

Sherry George · May 30, 2017 7:00AM

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

Nicklas Bergström - Oracle-Oracle · May 30, 2017 7:00AM

Hi Sherry,

Sample XML:

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

<DATA_DS>

<DOCUMENTTYPE>Purchase Order</DOCUMENTTYPE>

<DOCUMENTSTYLE>Purchase Order</DOCUMENTSTYLE>

<BUYERNAME>Firstname Lastname</BUYERNAME>

<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 · May 30, 2017 7:00AM

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

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

HTML link/hyperlink in BI publisher

Summary

Content

Answers