Tuesday, January 31, 2012

RDF to BI publisher Conversion Utility

RDF to BI publisher Conversion Utility Tool

High level steps:

1. Down load jar files from BI Publisher server.
2. Convert .rdf to .xml file.
3. Convert .xml file into BI publisher files.
4. Register report in BI publisher.
5. Compile package specification and body.
6. Execute and see the output.

1. Down load following files from BI Publisher server. In my case I have downloaded from BI publisher 10.1.3.4 server.

File Names:
• aolj.jar
• Collections.jar
• versioninfo.jar
• xdocore.jar
• xdoparser.jar
• xmlparserv2.jar

Path from BI Suite Server:
$BIPUB_HOME/oc4j_bi/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib
































2. Convert .rdf file into .xml file. It can be done 2 ways.

A. Find rwconverter.exe command which is part of reports installation.
Following screen shot from Oracle Development suite 10g.
























B. Also it can be done using Report builder

Open Report builder -> Open the REP083.rdf report
Navigation to get the below screen shot: File -> Generate to File -> XML

















3. Convert .xml file into BI publisher files
Open DOS command prompt. Execute below command:

java.exe -classpath C:\XDO\xdocore.jar;C:\XDO\collections.jar;C:\XDO\aolj.jar;C:\XDO\xmlparserv2.jar oracle.apps.xdo.rdfparser.BIPBatchConversion -source C:\REP083 -target C:\REP083 –debug

Source - Where xml file exists
Target - Where converted files to be stored.

Class path is the path where you downloaded all the ‘Jar’ files.






















It created new folder ‘REP083’and open the folder to see BI publisher files.






















4. Next step is registering report into BI publisher.


Log into BI Publisher:





















Create a zip file and Upload the report: You can zip .rtf, .xdo and _template.xml files OR else you can zip all the files. Here I am doing all files zip.














Click on Upload a report


























































5. Compile repo083S.pls and REP083B.pls files at Data base.

a. Package specification compiled successfully.
b. Package but not compiled. There are some compilation errors





















c. Correct the package body errors and recompile the code.

Before correction:








After correction: Corrected the package, making sure that null in-between the ‘EXCEPTION’ and ‘END’.







Recompiled the package successfully.























6. Execute and see the output.

Click on ‘View’ to run the report. It will ask to enter the parameter values and click on View















Click on ‘Edit’ to modify the report:




















Overall migration utility provides the basic structure. On top of that fine tuning should be done. Below are my findings:

1. RDF Format triggers logic will not convert by tool. For Ex: ‘no data fond’ and ‘end of report’ format triggers logic needs to incorporate manually in template.
2. Conversion tool write all formula columns logic into a PL/SQL procedure. Sometimes it may require correcting syntax errors manually.
3. Layout format needs to be adjusted. I observed that during conversion Logo was missing.
4. Some of the parameter data types and labels to be corrected. Parameters validation logic has to be incorporated manually.
5. Additional careful required for ‘Date’ data type variables and conditions.

Also, please find the document RDF to BI Publisher Conversion - step-by-step process with screenshots in the below link :-

How to convert RDF(Oracle Report) to BI Publisher using Conversion Utility

8 comments:

  1. This is a very good detailed document with step-by-step process and screenshots on RDF report conversion to BI

    ReplyDelete
  2. This is very informative document. Helped me in a great way ! Thank you !

    ReplyDelete
  3. Hello, this is a great post!. because i followed all steps and in the step 3 the DOS prompt throw this message:
    "Exception in thread "main" java.lang.NoClassDefFoundError: oracle/apps/xdo/rdfparser/BIPBatchConversion" .
    do you know what i have problems?. i am using Oracle Report Developer 10.1.2.0, Bi Publisher 10.1.3.4.2 on windows 7 and with jre 1.7.0.51. thanks in advance!.
    Best regards.
    Joaquin Martinez Pucci

    ReplyDelete
  4. when I am trying to run this command
    java.exe -classpath xdocore.jar;collections.jar;aolj.jar;xmlparserv2.jar oracle.apps.xdo.rdfparser.BIPBatchConversion -source E:\rpt_frm_temp -target E:\rpt_frm_temp –debug
    it throws me this error:
    Could not find or load main class oracle.apps.xdo.rdfparser.BIPBatchConversion
    Please help me

    ReplyDelete
  5. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  6. Oracle apps and Fusion Self Paced Training Videos by Industry Experts. Please Check oracleappstechnical.com

    ReplyDelete
  7. Hi Please help to convert rdf to rtf conversion,Iam getting the error that Could not find or load main class oracle.apps.xdo.rdfparser.BIPBatchConversion.Please help on this.

    ReplyDelete
  8. Now it's part of xdo-server.jar. The class now is oracle.xdo.rdfparser.BIPBatchConversion. This worked for me: java.exe -classpath C:\OR2BIP\lib\xdo-server.jar;C:\OR2BIP\lib\xdo-core.jar;C:\OR2BIP\lib\collections.jar;C:\OR2BIP\lib\aolj.jar;C:\OR2BIP\lib\xmlparserv2.jar oracle.xdo.rdfparser.BIPBatchConversion –debug -source C:\OR2BIP\XML -target C:\OR2BIP\BIP

    ReplyDelete