This presentation is for informational purposes only and

“This presentation is for informational purposes only and may not be incorporated into a contract or agreement. ”

Oracle XML Publisher Enterprise Reporting and Delivery

A New Look For Your Business

Deployment Options

Flexible Deployment Options… XMLP for E Business Suite XMLP for Peoplesoft XMLP for J. D. Edwards XMLP Enterprise XMLP Embedded

XML Publisher for Applications Fusion Technology … Integrated Within Your Application Ÿ XMLP for Oracle E-Business Suite – – – All 11 i releases Integrated with Concurrent Manager Tightly integrated with all Applications Modules Central Repository for managing Data / Layout Translation & configuration management Ÿ XMLP for Peoplesoft Enterprise 2006 – – – Integrated with Process Scheduler / Report Manager Publish Peoplesoft Queries and Row Sets Report bursting Security join tables Template Manager with effective dates support Ÿ XMLP for J. D. Edwards Enterprise 2006 – – – Integrated with EOne Queries Support Queries save through data browser Row and business unit security

XML Publisher Standalone Many Options … One Powerful Engine! Ÿ XMLP Embedded: Custom Development – – – Powerful formatting engines High Performance data extraction engine Batch processing, and Bursting Delivery API for email, fax, printing, ftp, AS 2, etc… Based on Open Standards: Java, XML, XSL, FO, RTF, PDF Ÿ XMLP Enterprise v 1: Interactive Reporting – – – Easy and fast deployment Any J 2 EE container Configure Repository on XMLDB or File System Data from Multiple DBs in the same Report (Oracle, DB 2. . ) Multiple Output Formats / Multiple delivery options Ÿ XMLP Enterprise V 2: Advanced Reporting Solution 2006 – – – Fusion Architecture, Hot Pluggable Services Document Repository, Scheduling, Archiving Database and Application Server independent Very advance Security and Administrative options Integration: Java, Web Services, BPEL, Standard Portlets

XML Publisher Desktop Same tools for all deployment options Ÿ Functional Users Tools Functional user can create report layouts using familiar desktop applications – Template Builder for Microsoft Word – Template Builder for Microsoft EXCEL – Template Builder for Adobe Acrobat – Online Template Builder Ÿ Developers / Consultants / IT department Tools Create data sources, define data sets and reports using expert tools – XMLP Builder – XMLP Viewer / Debugger

XML Publisher Enterprise

Installation Ÿ Server side Install – Packaged with OC 4 J Ÿ Out of the box install with OC 4 J via OUI – WAR file for all J 2 EE containers Ÿ Available for install on any application server Ÿ Client Side Install – Template Builder for Word RTF template builder – – XML Publisher report definition wizard Template Viewer / Debugger

Security Ÿ Packaged with LDAP implementation (XML) – – Simple and Easy Deployment Demos, Evaluation, Development Ÿ Configure it to work with Company LDAP – – Oracle OID, Open. LDAP … Any other LDAP implementation Ÿ JNDI interface to any custom solution – Implement JNDI interface for any custom security solution Ÿ Configure to work with SSO

Reports & Folders Two solutions for customers to manage folders and reports – File System Ÿ Simple and Easy Deployment Ÿ Demos, Evaluation, Development – Oracle DB Ÿ Utilizing XML DB Repository Ÿ Webdav interface to manage content

Administration

Administration Ÿ Centralized Online Administration – Data Connections Ÿ Create connections to multiple databases Ÿ Oracle, MS SQL, DB 2… – Users and Roles Ÿ Create roles and assign reports – Delivery Configuration Ÿ Email, FAX, Print, Web. DAV – Scheduling Management Ÿ Manage jobs, schedules, etc

Administration - Users and Roles Ÿ Create role hierarchies and assign to users

Administration – Delivery Setup

Development

Development Ÿ Report Definitions – – Online Rich Client Development Environment Connect to Multiple databases in the same report Ÿ Oracle, DB 2, … Ÿ Query Builder – Multiple Data sources in a single report Ÿ Multiple DBs, Web Services, URL, Data template… Ÿ Layout Templates – Plug in to MSWord Ÿ Connectivity to server to deploy templates Ÿ Simple Report Builder Wizard – Adobe Acrobat Ÿ Desktop Template Viewer, Debugger

Development – Online Report Builder

Development – Layout Templates

Development – Layout and Report Wizards

End User

End Users Ÿ Folders / Reports Navigation Ÿ Schedule Reports & Deliver Ÿ Report History, Manage Jobs Ÿ Interactive Reports – – Multiple Templates Online Analysis Excel Analysis Personalized Templates

End User - Login Integration with LDAP User assigned roles

End User – Reports Access Folders are secured based on Roles Reports are organized in folders

End User – Interactive Execution

End User – Scheduled Execution Ÿ Parameter entry Ÿ Job completion notification Ÿ Schedule times Ÿ Multiple delivery destinations – – – Email Printer Fax Web Folder FTP HTTP

End User – Interactive Features Navigation Breadcrumbs • Change Template • Locale • Output Format Cascading parameters • View Report • Export report • Deliver Report • Online data Analysis • Excel Data Analysis • Schedule Report • Monitor report jobs

End User – Template, Locale and Format User can change – – – Layout Output formats Locale

End User – Online Analysis User can analyze data Ÿ Online Rich Client pivot table builder Ÿ Drag an Drop Ÿ On the fly – – Dimensions Measures Ÿ Smart Caching Ÿ Fast Results Ÿ No DB Load

End User – Excel Analysis User can analyze data from Excel Export to Excel – Parameters Toolbar – Offline Analysis – Connect to refresh – Share with others – Company Folders – Same Security – Auto Install – Live update –

XML Publisher Features Ÿ Built on Standards Ÿ Platform Independent Ÿ High performance reporting engine Ÿ High volume / advanced printing support Ÿ Advanced support for multiple languages Ÿ Communicate in multiple formats: PDF, XML, EDI Ÿ Report from multiple Databases (Oracle, DB 2, etc) Ÿ Familiar report design interface Ÿ Multiple delivery options

Q& A QUESTIONS ANSWERS

“This presentation is for informational purposes only and may not be incorporated into a contract or agreement. ”