BI Publisher (MOSC)

MOSC Banner

BI Publisher format problems with CLOB

edited Oct 11, 2011 1:00AM in BI Publisher (MOSC) 3 commentsAnswered
Hello Experts,

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center