XML Publisher

1
XML Publisher

• How Does It Work
• And
• What Can You Do With It

Paul Whitehouse
2
XML Publisher

• Oracle Applications
• eBusiness Suite
• Peoplesoft
• JDE EnterpriseOne
• Enterprise Edition
• XMLP Embedded

3
Agenda

• What is XML?
• Where can you get it from?
• What can you do with it once youve got it?

4
What is XML?

• eXtensible Markup Language

Self Describing Data
On 12th December 2006 there is a User Group
Meeting in Wellington
The User Group Conference is in Auckland on
22nd/23rd March 2007
On ltdategt12th December 2006lt/dategt there is a
ltactivitygtUser Group Meetinglt/activitygt in
ltplacegtWellingtonlt/placegt
The ltactivitygtUser Group Conferencelt/activitygt is
in ltplacegtAucklandlt/placegt on ltdategt22nd/23rd
March 2007lt/dategt
5
What does XML do?

• Not a great deal

• Why?
• Not technically a language
• Only has syntax constraints (eg markups are made
  with lt gt)
• No formatting
• Not a programming language

6
What can you use XML for?

• Store and Retrieve Data
• Produce Formatted Documents

Ensuring Data Integrity Multiple Language Support
7
Data Storage and Retrieval

• On ltdategt12th December 2006lt/dategt there is a
  ltactivitygtUser Group Meetinglt/activitygt in
  ltplacegtWellingtonlt/placegt
• The ltactivitygtUser Group Conferencelt/activitygt is
  in ltplacegtAucklandlt/placegt on ltdategt22nd/23rd
  March 2007lt/dategt

ltdategt ltactivitygt ltplacegt 12th December
2006 User Group Meeting Wellington 22nd/23rd
March 2007 User Group Conference Auckland
8
Formatting with a Stylesheet

• On 12th December 2006 there is a User Group
  Meeting in Wellington
• The User Group Conference is in Auckland on
  22nd/23rd March 2007

On 12th December 2006 there is a User Group
Meeting in Wellington The User Group
Conference is in Auckland on 22nd/23rd March
2007
9
Formatting with XSL-FO

• eXtensible Stylesheet Language Formatting
  Objects
• Which means
• A language for describing Document Formats
• For Example
• Margins
• Page Layout
• Page Breaks
• Font, Line Spacing etc

10
So where does XML Publisher Fit in?

• XML Publisher implements the concept of splitting
  the data and the formatting

Build Output Template
RTF, PDF
XSL-FO
XML Publisher
Report Output
Data
11
Where do I get my XML from?
12
How do I get my XML data?

• eBusiness Suite
• Oracle Reports
• A concurrent program designed to generate XML
• DataTemplate
• Peoplesoft (PeopleTools 8.48)
• PS Query
• PeopleCode XML Doc
• Web Services
• JDE (EnterpriseOne 8.96)
• EnterpriseOne Reports

13
How do I get my XML data?

• Enterprise Edition
• HTTP XML Feed (RSS)
• Web Service
• Any data source accessible via a JDBC connection
• SQL Query
• Data Template

14
What are Data Templates?

• Data Query Tool that Supports
• Multiple Queries
• Formula / Summary Columns
• Before and After Report Triggers
• Specifying the XML Elements and Grouping
• Data Template itself is actually an XML file

15
Why Data Templates?

• No other XML generation tool (eg Oracle Reports /
  PL/SQL) met the required specifications
• Oracle Reports will be phased out
• Data Templates performance is better than Oracle
  Reports

16
What can I do with it once Ive got it?
17
XML Publisher 5.6.2 Supports

• Headers and Footers
• Tables
• Sections
• Last Page Content
• Running Totals
• Variables
• Fonts (incl MICR and Barcodes)
• Word Art, jpg, gif, png
• Graphs (up to 70 types)
• Conditional Formatting

• Watermarks
• Sub-Templates
• PDF Bookmarks
• PDF Security
• And more advanced features
• XML Regrouping
• Dynamic Data Columns
• Most XSL and XSL-FO, XPath Commands
• Some SQL Commands

18
XML Publisher
Build Output Template
RTF, PDF
XSL-FO
XML Publisher
Report Output
Data
19
Output Formats
XML Data
EFT
Banking
EFT
Excel
HTML
PDF
XML
Government
20
Document Delivery

• Document Splitting via Bursting Engine
• Email
• Fax
• Print
• FTP
• HTTP

21
Examples

• Currently in Use in New Zealand

22
New Zealand Examples

• Receivables
• Invoices
• Statements
• Direct Debit Remittances
• Deposit Slip Report (DataTemplate)
• Payables
• EFT Remittances
• General Ledger
• Financial Statement Generator (FSG)
• Transaction Listing
• Purchasing
• Purchase Order Format

23
The Future?

• XML Publisher is a core part of Fusion Middleware
• XMLP 5.6.3 due for release shortly
• Excel Templates
• Oracle Reports to Data Template Conversion
• 90 of eBusiness Suite Reports will be Data
  Templates in Release 12

24
Useful Links

• Oracle Technology Network XML Publisher Page
• http//www.oracle.com/technology/products/xml-publ
  isher/index.html
• XML Publisher Forum
• http//forums.oracle.com/forums/forum.jspa?forumID
  245
• XML Publisher Blog
• http//blogs.oracle.com/xmlpublisher