Step by Step XML Publisher Reports || Data Model || Data Definition || Data Template || Oracle Applications R12
Oracle XML Publisher (XMLP) is Oracle Corporation’s latest reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. Osama Elkady from the Applications Technology Group and Tim Dexter from the Financials Group were the main drivers for the product. It was first released with Oracle E-Business Suite 11.5.10 in 2003. Since then it has been integrated into most of Oracle Products including JD Edwards EnterpriseOne application 8.12 and PeopleSoft Enterprise 9, and as a standalone version, XML Publisher Enterprise with no dependency on Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.
What you’ll learn
- Students can understand what is the use of XML Publisher Reports.
- Students can understand how to register a report in Oracle Apps R12.
- Students can understand how to create a Data Model in Oracle Apps R12.
- Students can understand how to create a Data Definition in Oracle Apps R12.
- Students can understand how to create a Data Template in Oracle Apps R12.
Course Content
- Introduction –> 5 lectures • 17min.
- Layout Models –> 3 lectures • 20min.
- XML Report in Oracle Apps R12 –> 5 lectures • 6min.
- Data Definition & Data Template –> 3 lectures • 14min.
- Develop the XML Publisher Report through Report Builder –> 1 lecture • 43min.
- Develop XML Publisher Report Through PLSQL Stored Procedure –> 1 lecture • 44min.
- Register XML Publisher Report in Oracle Apps R12 –> 1 lecture • 1hr.
Requirements
- Students need to have knowledge on Report Builder.
Oracle XML Publisher (XMLP) is Oracle Corporation’s latest reporting technology. It was originally developed to solve the reporting problems faced by Oracle Applications. Osama Elkady from the Applications Technology Group and Tim Dexter from the Financials Group were the main drivers for the product. It was first released with Oracle E-Business Suite 11.5.10 in 2003. Since then it has been integrated into most of Oracle Products including JD Edwards EnterpriseOne application 8.12 and PeopleSoft Enterprise 9, and as a standalone version, XML Publisher Enterprise with no dependency on Oracle Applications. When XML Publisher became part of the Oracle BI Enterprise Edition Suite it was re-branded as Oracle BI Publisher.
BI Publisher separates the creation of data from the process of formatting it for different uses. The engine can format any well-formed XML data, allowing integration with any system that can generate XML, including Web Services or any data source available through JDBC. BI Publisher can merge multiple data sources into a single output document.
BI Publisher report templates can be designed using Microsoft Word, Adobe Acrobat, Microsoft Excel (standalone only), and Adobe Flash (standalone only). Templates created using these tools contain embedded fields with properties that determine how the XML data will be merged into the template, using Extensible Stylesheet Language syntax to precisely match the server’s engine.