The good news is that existing custom RDF (oracle designer) reports can be converted into BI reports easily using utilities available online.
Below are the various steps listed for a custom report
1. From the web address: http://bipublisher.blogspot.com/, download and install the BIP conversion utility (link on the top right of the page) by clicking on the link under ‘Code’. After downloading, click on the Video link next to the code link to understand how to use this utility. To include the BLOB image, which is stored as LONG RAW in the database, make sure it’s location is selected in the report data group.
2. At the end of the conversion process you will have file like: .xml file and the .pls files for the triggers and such that you have in your report. This utility also converts the format/layout to a RDF/word format, which you may use as such or not. I needed a different format than the report layout, so I did not use it.
Listing of the files that will be created. You will need to execute the .pls and .plb files in the database.
3. Now you are going to register the data template and the layout file generated above, in the application. Give yourself the XML Publisher Administrator and system administrator responsibilities.
4. From the system administrator responsibility, query the concurrent program that you used to run the report earlier. Navigation:
Change the format to XML:
Remember the short name of the concurrent program since you will be needing it later. Save the changes.
5. Log into the XML Publisher Administrator responsibility. And click on Data Definitions. Click on the Create Data Definition button. Give it a name and the Code should be the same name as the concurrent program short name. Enter the rest of the values and click on apply. On the confirmation page, click on the Add file button next to the Data template button at the bottom of the page:
e04
Choose the data template file that was created in step2 above: xxxHREMPPRFTM_template.xml, and click on apply. At this point the data template is created. Remember the name and code for this data template as it will be needed later. You can modify this data template anytime and the file associated with it, but the code you cannot. At this point the data template is associated with the concurrent program.
6. Click on the Templates tab at the top of the page or from the home page, choose the Templates function. Click on Create a Template button. Enter the Name and Code, the data denfinition is name of the data definition that you created above in step5, under Type choose RTF. Under the template file, enter the layout template file that was created above (xxxHREMPPRFTM.rtf) or the one that you created. Review and click on apply to save the changes. At this point, template is connected to the data definition and hence to the concurrent program.
7. If you are using the layout template: xxxHREMPPRFTM.rtf, (if not see step8) then from the responsibility that the concurrent program was run from, run the concurrent program, enter any parameters, if any, as needed, click on options.
This is the template that you had created in step6. You can associate more than one layout template with a data definition. Change the format to RDF and run the report. Click on output to see the RTF/word document.
8. If you are not using the template created by the conversion utility, then download the oracle BI publisher desktop utility from metalink/oracle web site. This will enable you to create a layout template from your MS word application.
9. Query up the template that you created in step5 above and enter an end date to it that is after the start date and is before system date. At this point you are disabling the template from the concurrent progam. The reason for this is: if you are going to use a custom layout for your report, you will need a data xml file that has you will use to create the fields in word.
10. Run the concurrent program and click on output, you will get an XML file that you have to save to your local drive:
11. Open up a new word document, you should see the Oracle BI Publisher menu option at the top:
12. Select the BI Publisher menu and choose data->load sample xml data and choose the XML file created in step10. The file should load successfully, if not then the XML tags are not created properly or there is some other issue with the file. Choose insert field and give it a name, under Add Help text button enter text as shown below. Here we are creating a repeating group. Similarly create others groups/data fields. When done click on preview to make sure that the file works fine. Fix any issues. Associate this file with the template definition created in step6 and remove the end date from the template definition.
Steps for displaying dynamic BLOB Images:
Make sure that the images that you want to display, are stored in a dir in operating system. For UNIX, put them under $OA_MEDIA dir or any dir under that. Make sure that the original RDF report has this element queried from the database so that each image is connected to the right record in the database. See image url xml tag in step10 above. Once you have upload the data xml file as in step12 above, create a placeholder for your image/blob file by choosing Insert menu option in word and then choose Picture->From File and choose a dummy file. Insert a picture and size it as you want. Once you are done, double click on the image and under the web tab do this:
IMAGE_URL is the XML tag name in the data xml file. The image_url has to be a web address location that the server can access. It cannot be your c:\ or something like that. That won’t work.
This is the only way that I could get the BLOB to appear in my BI report. There are more details on this step in the XDOUSerGuide.pdf document that you downloaded with the BI Publisher desktop utility. Search for image/blob in the PDF.
Good Reference: http://www.google.com/search?q=site:apps2fusion.com+xml-publisher-concurrent-program-xmlp
|
|
Metalink docid: 551013.1 |
There is also Tim Dexter’s blog as well: http://blogs.oracle.com/xmlpublisher/
Apps2Fusion Articles 
Comments
any one can give the solution....
I have downloaded the utility and the video. I followed the instructions very carefully but i have not been able to even run the BIP conversion utility, can you please help? When i run the report_conversi on.bat file, the command prompt window opens and closes and no output files are created. Can you please help.....i am stuck at this for a long time now.....first i thought it was because of windows vista then i tried it on xp too but no success. I have to convert rdf report containing a blob column to xml and i have used the rwconverter utility to do that but the xml created is not right. on tim dexter's blog i looked at the sample xml of the blob column and it contained the extracted information.... .there is nothing like that in my case.
i would also try deleting the installed file and installing it again. try and few options and see what happens
try fixing the .xml file manually by hand if possible..
she ena
sheena_sidhu
in your example you've chosen an image as BLOB. Is it also possible using BLOBs like PDFs which can be integrated into the RTF-Template?
I used this example and it works perfect with an image, but by integrating a pdf or rtf into/as attachment to the RTF-Template doesn't work.
Is there any way to do this within the RTF-Template.
Thanks a lot and kind regards
Steve
Sheen a
I have a blob image which is stored as LONG RAW in the database. I have to display this image in my XML publisher report.
Can anyone please guide to to retrieve the image via peoplecode to display it in my XML publisher report?
Thank You
Ashvina
I want retrive image from database with oracle BI publisher , but in report dont display my image .
i use this code:
please help me
Fo r XML encoded characters you can use
http://pastebin.com/
This comment thing does not support cdata
Thanks,
Anil
http://apps2fusion.com/at/77-sidhu/416-bi-publisher-blob-image
it might help. this uses a master detail report. you just need to create groups the same way you do in oracle reports.
Thanks for the article, as per my requirement I need to show a word document in XML report, here the word document will be available in FND_LOBS, can you please throw some light on this, its little urgent.
Thanks in Advance
Sra1
I am not sure what exactly you need help with. If you can tell me where you are with your development effort, I could possibly help you more. As per your note, since the doc is in fnd_lobs, you just need to create a data group in your report and show it in the template. If the word doc is static, then you can simply embed it in the document...I used a word doc for my experiment, have not worked explictly with XML docs though..
ciezdzcvcxbnkes sgn
with your RSS. I don't understand the reason why I
can't subscribe to it. Is there anyone else getting the same RSS issues?
Anyone who knows the answer will you kindly respond? Thanx!!
this excellent blog! I guess for now i'll settle for bookmarking and
adding your RSS feed to my Google account. I look forward to new updates and will talk about this blog with my
Facebook group. Chat soon!
majority of your post's to be just what I'm looking for.
Would you offer guest writers to write content for you personally?
I wouldn't mind writing a post or elaborating on a few of the
subjects you write concerning here. Again, awesome web site!
that I have really enjoyed surfing around your blog
posts. After all I will be subscribing to your feed and I hope you write again very soon!
personally recommend to my friends. I'm confident they will be benefited from this site.
revisiting. I wonder how a lot effort you place to make this
type of wonderful informative website.
Does running a well-establishe d website like yours take a lot
of work? I'm brand new to writing a blog however I do write in my journal every day.
I'd like to start a blog so I will be able to share my
personal experience and views online. Please let me know if you have any kind of
recommendations or tips for brand new aspiring
bloggers. Appreciate it!
blog posts. In any case I will be subscribing to your
rss feed and I hope you write again very soon!
be on the web the easiest thing to be aware of. I say to you, I definitely get irked while people consider worries that
they plainly do not know about. You managed to hit the nail upon the top and defined out
the whole thing without having side effect , people could take a signal.
Will probably be back to get more. Thanks
like to write a little comment to support you.
also zealous of getting familiarity.
They're really convincing and can certainly
work. Nonetheless, the posts are too short for starters.
May you please lengthen them a little from subsequent time?
Thanks for the post.
found any interesting article like yours. It is pretty value sufficient for me.
In my view, if all web owners and bloggers made good content as you did, the net will likely be much more helpful than ever
before.
Is this a paid theme or did you customize it your self? Either way stay up the
nice quality writing, it's rare to look a nice weblog like this one today..
require a great deal of work? I have no understanding of coding but I was hoping to start my own blog
in the near future. Anyhow, should you have any suggestions
or techniques for new blog owners please share. I know this is off subject
nevertheless I simply had to ask. Kudos!
iphone during lunch break. I really like the info you provide here and can't wait to take a look when I
get home. I'm shocked at how fast your blog loaded on my phone ..
I'm not even using WIFI, just 3G .. Anyways, excellent
blog!
things out. I like what I see so i am just following you.
Look forward to looking at your web page again.
new web site or even a blog from start to end.
web site and in accession capital to assert that I get
in fact enjoyed account your blog posts. Anyway I'll
be subscribing to your augment and even I achievement you
access consistently quickly.
thus I am going to convey her.
and it has helped me out loads. I'm hoping to contribute
& aid different customers like its helped me. Great job.
RSS feed for comments to this post