- Business Needs
- Application Integrations
- Delivery Technology
- About STR Software
About STR Software
I thought Oracle Open World was whirlwind this year, then I arrived home… Wanted to thank those that took the time out of their packed schedules to come to my presentation on ‘The Many Faces of Oracle BI Publisher’. I was excited about the amount of attendees that came and I have received a number of questions since the show. I have uploaded my slides and associated paper (with more detail). You can find them at the links below.
One of the questions that came through today was regarding more information on how to convert Oracle Reports to BI Publisher Data Templates and Oracle Reports. This functionality currently exists as a series of calls to various utilities and is 3 step process.
Step 1: Convert your 9i Oracle Report to XML using rwconverter:
rwconverter batch=yes source=<report to convert> dest=<output file> dtype=xmlfile overwrite=yes
Step 2: Create the Data Template using the BI Publisher DataTemplateGenerator API
java oracle.apps.xdo.rdfparser.DataTemplateGenerator <Path to XML File created in Step 1>
Step 3: Create the RTF Layout using the the BI Publisher RTFTemplateGenerator API
java oracle.apps.xdo.rdfparser.RTFTemplateGenerator <Path to XML File created in Step 1>
Now there are some caveats and your results may vary, but rather than just repeat the documentation verbatim, take a look at Appendix D in the Oracle BI Publisher Administration and Developer’s Guide for your version of Oracle EBS.
Once I get caught up at work, I’ll also update the presentation and the blog with other questions and suggestions that I have received.
Once again, thanks for attending and if you have any other questions please feel free to contact me either through this blog or directly (See the About tab for contact info).