Fusion Applications - BI Publisher (BIP) - Excel Report Output Has Merged Rows + URL Hyperlink Not Display In BIP Report Output After Removing HTML Tags

(Doc ID 2285634.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Fusion Application Toolkit Cloud Service - Version and later
Information in this document applies to any platform.


 On : version, Technology Management - Reports/Analytics

Export the RTF template report output in an excel format. The rows are being merged.

The data in the database contains HTML tags and this is the cause of this behavior.

The issue can be reproduced at will with the following steps:
1. Build Data Model to get the data from HRG_GOALS.SUCCESS_CRITERIA
2. Build RTF Template
3. Export to Excel and check the output


Data shown in HRG_GOALS.SUCCESS_CRITERIA shows as below

<![CDATA[<p><a href="http://www.abc.com">www.abc.com</a> </p><p><font face="Arial,Helvetica,sans-serif">Arial <font face="Courier New,Courier,Monaco,monospace">Courier New <font face="Comic Sans MS,Comic Sans,cursive">Comic Sans <font face="Times New Roman,Times,serif" size="5">Font 5</font></font></font></font></p><p><font face="Courier New"><br/></font></p>]]>


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms