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