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 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

 On : 11.1.11.1.0 version, Technology Management - Reports/Analytics

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

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

STEPS
-----------------------
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>]]>

Cause

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