05 May 2012

Steps to Convert RDF file into BI Report/XML Publisher report

There is no single step method where you can converting RDF file into XML Publisher/BI reprot. BI Publisher developer guide has complete details. For the benifit of everyone i am publishing these steps.

Approach 1, Here you still need RDF file to generate XML outpu : Convert the output format of Standard report to XML, create a new RTF template and register a Data Definition and Template with XML Publisher.

Approach 2 : Convert the RDF report into XML Report and use this XML as a Data Template. Create a new XML Publisher report Data Definition with this XML as Data Template and create a new Template.

The problem with Approach 2 is that Oracle provides no tool to convert Reports 6i into XML Report and any other supporting APIs to handle associated PL/SQL logic embedded into RDF.


Enter Reports 9i (or higher) and XML Publisher 5.6.3. These two combinations of Oracle products provide tools to first convert RDF report into XML report and associated XML Publisher API to handle PL/SQL logic.

This is how it works.
-----------------------------

Oracle Reports contains both Data Model (logic) and Layout (presentation) in a single file. In XML Publisher they are stored separately. Therefore migration involves a 2 step process.

Step 1 RDF to XML format report : Oracle Reports 9i (or higher) comes with utility "rwconverter.exe". Use either Reports Designer or "rwconverter.exe" command line to convert RDF into XML format report.

From the Designer :

The following command executes “rwconverter.exe” utility, taking the source report,

XXTEST.rdf and converting it to an RDF-XML format that can be consumed by the

XML Publisher conversion utility.

Note the dtype must be specified as "xmlfile".

\BIN>rwconverter batch=yes source= c:\XXTEST.rdf

dest= c:\XXTEST.xml dtype=xmlfile overwrite=yes

This would create an RDF-XML file, with all the PL/SQL logic and presentation logic.

Step 2.1 Data Model Migration :

XML Publisher 5.6.3 provides a Java API Package "oracle.apps.xdo.rdfparser". This package has "DataTemplateGenerator" class that creates a DataTemplate from the XML report file. If report has triggers this will generate '.pks' and '.pkb' file for that trigger which needs to be compiled into the Database

Example

javaw.exe oracle.apps.xdo.rdfparser.DataTemplateGenerator c:\XXTEST.xml

Output Files:

PL/SQL Package : XXTESTS.pls

PL/SQL Body : XXTESTB.pls

DataTemplate : XXTEST_template.xml

Step 2.2 Data Model Migration :

XML Publisher 5.6.3 API Package "oracle.apps.xdo.rdfparser" has "RTFTemplateGenerator" class to migrate the Oracle Reports layout to an XML Publisher RTF template. Because there is no support for PL/SQL in an RTF Template, the generator writes all Oracle Report format trigger code to the log file. This must later be implemented as XSL code


Example

javaw.exe oracle.apps.xdo.rdfparser.RTFTemplateGenerator c:\XXTEST.xml

Output Files:

RTF Template : C:\XXTEST.rtf

Log File : C:\XXTEST.log

That’s it we are done with the conversion.

Now that we have converted the RDF into XML publisher report, we simply need to use the Data Template and RTF to register with the XML Publisher.

Step 3 : Register a new Data Definition with XML Publisher Responsibility, with XML file generated as part of Step 2.2 as Data Template. Register the RTF template for the DD.

Step 4 : Create a Concurrent Report Program with Report output as XML and executable as "XDODTEXE". XDODTEXE is XML Publisher Data Template Executable Engine, which is a Java Concurrent Program.

More information refer,
http://docs.oracle.com/cd/E10415_01/doc/bi.1013/e10416/convertrpts.htm#CIHIHICD
http://apps2fusion.com/at/kr/346-bi-publisher-report-migration-utility

7 comments:

oraclefusion said...

Thanks for sharing for more information visit

Oracle Fusion

oraclefusion said...

very good information is here.about packages you explained very well.
so useful this content for the users.

oracle fusion all modules tutoriles said...

nice blog good information about a blog This listing is virtually very useful.
Thank you for sharing the ones most important weblog submission net web sites.
For more about information please check the internet site oracle all modules trainings

Unknown said...

Oracle fusion Financials Training from CALFRE.COM gives you the best results to learn your dream course and maintains sufficient knowledge on oracle. It provides training by self-paced videos which are very helpful for the users to watch at any time according to their schedule. It is globally accepted and having many users undergoing training every day.



Oracle fusion Financials Online Training in Ameerpet

Oracle Fusion Financials Training in Ameerpet

Unknown said...

A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training

Anonymous said...

Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
Oracle Fusion Financials Online Training
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training

Aditya said...

Nice blog and good information shared here.