Oracle Analytics Cloud and Server

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

Displaying special characters in XML Publisher

Received Response
226
Views
1
Comments

Summary

Displaying special characters in XML Publisher

Content

Hello!

We are using the XML Publisher in EBS 11.5.10.2. The requirement is to be able to display special characters, like '&',' " ', in reports, pdf output.

I have tried using CDATA, but it isn't working.

    This is the entry in the XML output of the report: <COL_3_2><![CDATA[BEMETA DESIGN & s.r.o.]]></COL_3_2>

    When loading the xml in word (BI Publisher Template Builder for Word 10.1.3.2.1 build 87) as data source and previewing in PDF format, the result is displayed correctly as BEMETA DESIGN & s.r.o.

    When running the report in EBS, the result is displayed as <![CDATA[BEMETA DESIGN & s.r.o.]]>

Any suggestions what i might be doing wrong, do I need to do put  something else in the form field in the RTF template other than <?COLUMN_NAME?> ?

Are there any other options for implementing the requirement?

Thank you!

Tagged:

Answers