Chapter 14. Oracle XML Publisher

In Chapter 11 we generated a PDF report using the Apache FOP API, and in Chapter 12 we generated an Excel spreadsheet using the Apache POI API. Oracle also provides a reporting tool to generate reports. Oracle provides the Oracle XML Publisher to generate AWR, Excel spreadsheet, HTML, PDF, RTF, and UIX reports. Oracle XML Publisher is available as a GUI tool as well as a set of core API components. The Oracle XML Publisher has many advantages over the Apache FOP/Apache POI APIs, some of which are discussed as follows:

• Reports may be generated from multiple input XML files

• XML documents are not required to be parsed using the JAXP/XPath API

• PDF documents may be merged

• XML Publisher supports other formats such as HTML and RTF in addition to PDF and Excel spreadsheet

The following core APIs may be integrated with Oracle JDeveloper 11g to generate PDF, Excel, HTML, or RTF reports:

• PDF Form Processing Engine API: This merges a PDF template with XML data to generate...