naresh edupuganti - · pdf file• the utility generates the bi publisher data template and...
TRANSCRIPT
Oracle Reports to BI/XML Publisher Migrator
- Naresh Edupuganti
Agenda
Company Overview
EBS Services
Tools and Technologies
Who am I
Introduction
Prerequisites
Converting RDF to XML
Concurrent Program
Limitations
Demo
Q & A
Who is Evoke
• Established in the year 2003
• Gold Partner with Oracle
• CMMI Level 3 appraised and ISO 27001 & ISO 9001 certified
• Successfully implemented Agile-Scrum Methodology from offshore
• Headquartered at Dayton, OH and ODC in Hyderabad, India
• 300+ people in offshore and 150 onsite, with average experience of 6 years
EBS Services
• Implementation Services
• Upgrade Services
• Maintenance & Support Services
• Testing Services
Tools and Technologies
Tools and Technologies
Who am I
• Project Manager
• 11+ Years of IT Experience in Oracle EBS 11i and R12
• Handling Implementation and Maintenance Projects
• Designing and Development of Value add Tools around Oracle EBS
Introduction
• BI Publisher is becoming more popular and becoming the standard for Reports Development
• Oracle Reports Vs. BI/XML Publisher
• Will it be good if we have a tool to convert Oracle Reports to BIP?
• The Utility generates the BI Publisher Data Template and Layout files that we will upload to the BI Publisher Repository
Introduction (Contd..)
• Overall flow for Conversion
Run the Migrator Utility
Load the PL/SQL Package into Database
Create the Concurrent Program
Upload the Data Template and Layout Template files in BI Publisher
Test the Report
Prerequisites
• Oracle Reports 9i and above
• Oracle BI/XML Publisher 5.6.3 and above
Converting RDF to XML…
• Run the Migrator Utility
Converting RDF to XML…(Contd)
• Migrator creates
• PL/SQL Package – This will contain Report triggers and Lexical Parameters code if any
• BI Publisher Data Template – Contains the Data model query from RDF in required format
• BI Publisher Layout Template – Contains the report output Layout
Concurrent Program
• Create the Concurrent Program with the Executable “XDODTEXE” and output type as XML with all the Parameters.
• Define the XML Data Definition and Template
• Upload the Data Template and RTF template files
• Attach the Concurrent Program to Request group
• Test the Report
Limitations
• Format Triggers
Demo
Demo . . .
