Oracle XML Publisher Enterprise Reporting and Delivery

1. Oracle XML PublisherEnterprise Reporting and Delivery Salim Odero Principal Sales Consultant, E-Business Suite Technology Oracle Corporation

2. …Or this one? This one? Which Report Would You Rather Have?

3. XML Publisher ReducesCosts

4. Checks Reports Labels Destinations Document Management Requirements • Rich Formatted Reports • Partner Reports • Financial Statements • Government forms • Marketing materials • Contracts • Checks, Labels • XML • EFT / EDI • Multiple destinations Invoices XML / EFT / EDI

5. Checks Invoices Reports Destinations High Maintenance Costs • 3rd party software and custom solutions are required to satisfy business requirements • Highly-skilled engineers required to maintain the 3rd party software servers • Costly • Time consuming • Complex systems • Expensive maintenance • Labor intensive Check Print Server Invoice Server Label Manager Report Formatter Labels Delivery Server Payment Server XML / EFT / EDI

6. Checks XML Publisher Reports Labels Destinations XML Publisher: Reduce Complexity & Costs • Oracle XML Publisher • Authoring • Managing • Delivering Your Business Documents • Meet Business Requirements • Remove Complexity • Reduce Maintenance Cost • Reduce Total Cost Invoices XML / EFT / EDI

7. A New Look For Your Business

8. Customer ProductivityFlexible Customization

9. Using Classic Reporting Tools Add another field Requirements Updates… Font size change Reflect all changes Margin change Report files Report Output Maintenance forever…

10. Classic Reporting Tools Issues Data logic Layout Report file Translation High development cost High customization cost Difficult upgrade

11. XML Publisher Advantage Separate data / layout / UI translation Data Logic Layout XML Publisher Reportoutput Translation • Flexibility • Reduced maintenance

12. XML Publisher Development • Business consultants use familiar desktop tools for layout customization • Support for Multiple Data Sources XSL Report Templates XSL-FO XML Formatting Engine Report Output Multiple Data Sources • Rapid Deployment

13. From Data to Destination PDF Email Oracle, SQL Server RTF Printer HTML Oracle PeopleSoft, Siebel Excel XML Publisher Fax XML XSL Java, C++, Pearl, etc WebDAV Templates EDI • Word • Excel • Acrobat EFT • XML Spy • JDeveloper • Scriptura e-Commerce Web Services Data Source Layout Tools Output Destinations

14. Controller XML Publisher Government XML B2B Inbound Document Capture EFT Banking EFT Excel MSWord Supplier PDF Application Data XML Inbound documents converted to XML and fed back to database

15. Set Up • Create MS Word or Adobe Acrobat Template • Register Template with XML Publisher • Run Concurrent Request Output with XML Publisher template as output option

16. Deli vered Report Output Screenshot

17. Concurrent Program Definition

18. XML Output File

20. XML Publisher TemplateManager Screenshot

23. Oracle ApplicationsStandardizing onXML Publisher

24. HRMS/HCM DBI/PMV Purchasing Contracts Sourcing Quoting FSG eRecords Loans Financials Consolidation Hub AP / AR / FA EPB Apps Products UtilizingXML Publisher • Order Management • iStore • Project Contracts • Marketing • Student Services • Discrete Manufacturing • Process Manufacturing • Bill Presentment • Internal Controls Manager • Global Financials • Sub Ledger Accounting • SCM • Projects

25. Oracle Human Resources Human Resources Business Requirements • Generate Employee tax forms • Support multiple states and continuation pages • Single and Batch processing • Access from Self Service Implementation • PDF Form Templates • XMLP Common Regions • XML APIs (Batch)

26. Oracle Payments Payments Business Requirements • Generate Electronic Funds Transfer files • Support 160 formats • Very large data input support • Deliver via FTP, HTTP Implementation • eText Templates • Delivery Manager

27. Oracle Sourcing Sourcing Business Requirements • Generate integrated output with Contract info • Advanced formatting • Self service interaction Implementation • RTF/XSLFO Templates • Multiple data sources /templates • Integrated into self service application

28. Oracle Financials Financials Business Requirements • Generate High Fidelity Output • Allow end user customization • 10000+ page output • No change for report consumers Implementation • RTF Templates • Scalable transformation • Concurrent Manager Integration

29. Oracle Daily Business Intelligence DBI Business Requirements • Generate High Fidelity Output from HTML • User level customization • Support Images/ Charts • Support dynamic links Implementation • RTF Templates • Charting support • Advanced layout features

30. Customer Implementations

31. Customers

32. Qualcomm Inc Business Requirements • Generate Customer Facing Output • 18 Invoice formats • Multiple output formats • EFT Output • Empower functional users to build layouts Implementation • RTF Templates • eText Templates • Template Builder

33. Dell Inc Business Requirements • Generate Customer Facing Output • Multiple Data Sources • Translation support • Multiple Delivery Channels • High Volume ~10000 docs/hr • Keep database load to a minimum Implementation • RTF Templates • Delivery Manager • Watermarking support • Install XMLP on separate server

34. Patches and Papers • XML Publisher 4.5 - 3554613 • XML Publisher 5.0 – 3822219 • XML Publisher 5.0.1 - 4236958 (Core bug fixes) • Template Builder Plugin - 4239263 incl user guide, demos, etc • Conc Manager Integration – 3435480 Please check the associated About Documents for these patches prior to application • Check Printing Paper – Note:312353.1 • Single Step Reporting Paper - Note:295409.1 • Public Site http://www.oracle.com/technology/products/applications/publishing/index.html

35. Oracle XML PublisherThank You for Your Interest