Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Trying to add a telephone number hyperlink like "tel:###" to an RTF template for BI email bursting

Received Response
41
Views
4
Comments
Jbgood
Jbgood Rank 3 - Community Apprentice
in Oracle Analytics Publisher

I'm trying to add a clickable telephone number hyperlink like "tel:###" to an RTF template used for BI-Publisher email bursting.
According to this, it should be possible:
https://answers.microsoft.com/en-us/msoffice/forum/all/clickable-phone-numbers-in-word-documents/3ed057a0-789a-47c3-bdbc-f6592e848c4e
But when I try this, the link is mutes to:
\u01\APPLTOP\instance\domains\fa.oracleoutsourcing.com\FADomain\tel:####
instead.
The phone number in the email should become clickable, so the phone number is dialed when clicked.
How can I create a tel:### link in RTF where "###" is the phone number?

I tried entering "tel://########/" into the hyperlink

Answers

  • Sandeep S. Chauhan-Oracle
    Sandeep S. Chauhan-Oracle Mod

    Hi, You can try below XSL_FO element in RTF form field-

    <fo:basic-link external-destination="tel:{/DATA_DS/G_1/MOBILE_NUMBER}">call <?/DATA_DS/G_1/MOBILE_NUMBER?></fo:basic-link>

    XML:
    <DATA_DS><G_1><MOBILE_NUMBER>+13011234567</MOBILE_NUMBER></G_1></DATA_DS>

    Reference:

    Supported XSL-FO Elements

  • TaniaT-Oracle
    TaniaT-Oracle Rank 1 - Community Starter

    I've tried your approach Sandeep, but BI Pub still adds to the beginning…in my case (x's and n's replacing real values):

    file://u01/app/oracle/product/xxx-xxx-3/ps_cfg_home/appserv/XXXXX/tel:nnnn

    Any other ideas?

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    Windows adds the file reference to a hyperlink.

    Do not use a hyperlink, put the code from Sandeep above into form fields.

    Rgds,

    Kevin

  • Jbgood
    Jbgood Rank 3 - Community Apprentice
    edited Mar 19, 2025 8:54AM

    Hello Kevin and Tania,
    I added the recommended to the RTF form field - if I understand correctly:

    phone.png

    This will create a link looking like standard text (no underline or different color like with other links).
    Creating RTF test documents from within Word using data.xml will result in a link like:
    file:///C:\Users\..xxxx\local path..\tel:+861#######

    When it is sent per email through bursting, the link changes in my case (HCM cloud) to:

    file:///\\u01\APPLTOP\instance\domains\fa.oracleoutsourcing.com\FADomain\tel:91###

    Neither result in the desired bare link like "tel:1234.." - just the same like what the Microsoft hint did above.
    Regards,

    JBgood.