Raw Data

Im seeing more and more folks wanting to render their stored XHTML in their outputs using BIP. I have written about the 'how' to render in the past but much more recently I have had customers that could not get to the rendering part because the extract was not extracting the XHTML in its raw format.

By raw I mean

'<p>This is a paragraph</p>'.

The data template engine under EBS 11i and R12 was escaping all the angle braces so the above string was coming out as

'& lt;p & gt;This is a paragraph& lt/;p& gt;',

ignore the spaces after the ampersand, just trying to stop the blogging platform from formatting them. Anyhoo, the sub template that converts the XHTML to XSL-FO was not working, its looking for '<p>' not '& lt;p& gt;'

Good news everyone, the dev team have implemented an enhancement for this so that you can get the raw data out. Still not quite out in the wild but look out for patch 8660920 if you are stuck.

All you need to do is change the dataType attribute for the CLOB column to 'xdo:xml' e.g.

<element name="ARTICLE_TEXT" dataType="xdo:xml" value="ARTICLE_TEXT"  />

A tiny tiny prize for the person that spotted the Futurama reference?

Comments:

anyhoo

Posted by James on August 28, 2009 at 05:25 AM MDT #

Could you please help me: where can I download patch 8660920? It's very important for me. Thank you at advance.

Posted by Sofiya on February 03, 2010 at 06:01 PM MST #

Hi The patch was released to metalink last week and should be downloadable from there. If you can not get it let me know. regards Tim

Posted by Tim dexter on February 04, 2010 at 01:54 AM MST #

Is it the same patch for eBusiness R12 too? Thanks Srini

Posted by srini on May 11, 2010 at 09:06 AM MDT #

That's a first-rate write-up. I've another very much the same blog page myself for that reason I could keep coming back to read more. cheers for this sort of a fun time. Julie

Posted by Delcie Claton on July 29, 2010 at 12:13 AM MDT #

I am getting the same problem with Release12, Is this same patch works on R12? Please suggest

Posted by salahudeen on September 05, 2010 at 03:37 PM MDT #

I have 8660920 patch installed and I have changed the data type of node to dataType="xdo:xml" as well. But still, I am getting html tags only in my report output instead of formatted data. Can you please help ?

Posted by guest on July 25, 2011 at 06:22 PM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today