Report with all text fields double quoted and double quotes escaped

Uma Scherer · Dec 13, 2024 2:54AM

We have a requirement to extract data with all string/text fields double quoted and double quotes escaped. How can we best accomplish it? May be in the e-text template?

Uma Scherer · Dec 13, 2024 2:55AM

This is in Oracle Fusion Application - BI Publisher

Dimple-Nagesh-Support-Oracle · Dec 13, 2024 3:31AM

Hi @User_0ONK7,
Here is the documentation for Creating eText Templates:
Introduction : An eText template is an RTF-based template that is used to generate text output for Electronic Funds Transfer (EFT) and Electronic Data Interchange (EDI). At runtime, BI Publisher applies this template to an input XML data file to create an output text file that can be transmitted to a bank or other customer. Because the output is intended for electronic communication, the eText templates must follow very specific format instructions for exact placement of data.

More details on : https://docs.oracle.com/cd/E21764_01/bi.1111/e13881/T421739T481436.htm

Thanks,
Dimple N