BI Publisher format problems with CLOB
QUESTION
When we use a CLOB data type as part of the SQL select in an XML data template the matching RTF template does not respect certain formatting,
for example: group headers get attached to every line in the output instead of just being above the first line in the output.
We are running E-Business suite 12.1.3, using version 5.6.3 of the XML publisher
Steps to Reproduce
SQL in the XML data template includes a function call that returns a CLOB data type. This particular report is for printing a custom Quote so there is the typical header and detail type data one might expect for a sales quote. The resulting CLOB data which contains terms and conditions prints after the detail line group. When the output of the terms function is a CLOB the detail lines each get the column headers, when the output is a varchar2 the line headers only print once at the start of the detail lines.