E1: XMLP: How To Make A UBE Generate XML With CDATA Strings For BIP (Doc ID 2100259.1)

Last updated on APRIL 04, 2025

Applies to:

Goal

How to make a UBE generate XML with CDATA strings for BIP

Is it possible for a UBE to generate string data that will be enclosed within a CDATA tag when the XML is generated for an embedded BIP job?

Customer wants to use the <?html2fo:?> RTF template function in BI Publisher to display the formatted contents of text attachments. They  have already tested the function and it works. It requires the strings to be CDATA strings.

They set up to use the Rich Text Editor for HTML text attachments in E1.

They have a custom BSFN that retrieves the raw text data from F00165.

When they store the raw text data in a Report Variable, the XML generator (that processes the UBE output to generate the XML for BIP) replaces the XML reserved characters with the equivalent entity reference strings - "<" gets replaced with "&lt;", etc.

This is expected for XML strings. Also, that is the reason why the <?html2fo:?> function requires a CDATA string - so that the enclosed string can contain XML reserved characters.

If they are able to generate CDATA delimited strings, they can leverage the <?html2fo:?> function in their BIP templates. For example, instead of just storing AR Statement Letter text, they could store formatted text, e.g. text with bold, underlined, italic segments; and print the same formatted text using BIP.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.