1 / 62

Oracle XML Publisher Enterprise Reporting and Delivery

morgans
Download Presentation

Oracle XML Publisher Enterprise Reporting and Delivery

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The presentations and other material provided to you at this event may include statements about Oracle's product development plans.  Many factors can materially affect Oracle's Product development plans and the nature and timing of future product releases.  Accordingly, this information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.  The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.  This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates.  Oracle specifically disclaims any liability with respect to this information.

  2. Oracle XML PublisherEnterprise Reporting and Delivery Tim Dexter & Klaus Fabian Applications Technology Oracle Corporation

  3. ReportingArchitectures

  4. Checks Reports Labels Destinations Business Document Requirements • High Fidelity 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 Complex Reporting Environments • Have to rely on multiple reporting solutions • Highly-skilled engineers required to maintain servers and report formats • 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 Reports Labels Destinations Single Solution Environment • Oracle XML Publisher • Authoring • Managing • Delivering Your Business Documents • Meet Business Requirements • Remove Complexity • Reduce Maintenance Cost • Reduce Total Cost Invoices XML Publisher XML / EFT / EDI

  7. ReportDevelopment

  8. Report Development Today Mimic Report Requirements Report Requirements Report Output Report files Must be same geometry, font, margin size, etc.

  9. Using Classic Reporting Tools More Requirements… Report files Report Output More resources…

  10. Classic Report Development Add another field End user enhancements … Font size change Reflect all changes Margin change Report files Report Output Maintenance forever…

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

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

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

  14. Applications

  15. One Solution for all Business Documents

  16. All Industry Requirements Higher Education • Letters • Grant applications • Exam scripts Government • Tax Forms • Grants • Procurement Every Industry • Marketing Material • Financial statements • Legal documents • Invoices • Checks • TAX reports • HR Reports Telecommunications • Dunning letters • Customer statements Manufacturing • Bill of lading • BOM Docs • Delivery notes Financial Services • Payment processing • Financial statements • Loan documentation Healthcare • Clinical trial reports • Patient letters

  17. DeploymentOptions

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

  19. XML Publisher for Applications … Standard … Integrated … Extensible XMLP for Oracle E-Business Suite • Integrated with Concurrent Manager • Tightly integrated with all Applications Modules • Central Repository for managing Data / Layout • Translation & configuration management XMLP for Peoplesoft EnterpriseNew! • 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 EnterpriseNew! • Integrated with EOne Queries • Support Queries save through data browser • Row and business unit security

  20. 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, AS2, etc… • Based on Open Standards: Java, XML, XSL, FO, RTF, PDF XMLP Enterprise • Easy and fast deployment • Any J2EE container • Configure Repository on XMLDB or File System • Data from Multiple DBs in the same Report (Oracle, DB2 ..) • Multiple Output Formats / Multiple delivery options • Document Repository, Scheduling, Archiving • Database and Application Server independent • Advanced Security and Administrative options • Pluggable Services, Web Service APIs

  21. XML Publisher Desktop Same tools for all deployment options Functional Users Tools Functional user can create reports using familiar desktop applications • XML Publisher for Microsoft Word • XML Publisher for Microsoft EXCEL • XML Publisher for Adobe Acrobat Consultants / IT department Tools Consultants create data sources and reports using expert tools • XMLP Builder • XMLP Viewer / Debugger

  22. Features

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

  24. XML Publisher Government Forms • Business Data • Human Resources • Procurement PDF Government • Human Resources • W2, W4 • 1099 • Procurement • sf26, sf33, sf1449 • OF347 Download PDF forms from Gov. Web Site Send back the exact form filled with data

  25. Controller CEO XML Publisher XML B2B Extract Once – Publish Multiple Times XML Data EFT Banking EFT Excel HTML PDF XML Government XSL Different Templates For different output formats

  26. XML Publisher Report Bursting Multiple Data, which templates, where to send…in one XML File EDI HTML PDF PDF XML Templates

  27. XML Publisher Consolidated Document Publishing • Generate consolidated documents • Briefing Books • Shipping Documents • Others • Either XML Publisher or 3rd party PDFs • Page numbering • Bookmarks • Start/ End Pages • Overlays

  28. Distributed Delivery Master delivery manager can dispatch the delivery requests to remote delivery servers via IPP and Web Services. Printer Supported Protocols IPP, HTTP, SMTP, WebDAV, FTP, AS2 Printer Linux / NT Server Email WebDAV Printer BI Publisher Delivery Manager Printer Linux / NT Server Fax Firewall

  29. No need for expensive language-specific printers BI Publisher ships with full set of Unicode Fonts Scalable font embedding, with CID mapping tables BI Publisher is alone in supporting CJK BiDi Unicode MLS Communicate with partners around the world Create a template for any language/territory Internationalization & Language Support

  30. Oracle Applications

  31. What's new? • Latest release is 5.6.1 • XML Publisher Data Engine and Data Template Enhancements • Distributed query support • Simple SQL>XML • Bursting Engine • Performance Improvements • RTF Template Enhancements • PDF bookmark support • Last page only support • Word Art/Org Charts • Inbound EFT support • Configuration Manager • Template Builder Wizard and other new features

  32. HRMS DBI/PMV Purchasing Contracts Sourcing Quoting FSG eRecords Loans Financials Consolidation Hub AP / AR / FA EBS 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

  33. 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

  34. Oracle Collections Collections Business Requirements • Generate dunning letters • User level customization • Generate operational reports • Deliver via multiple channels Implementation • RTF Templates • Conditional formatting • Delivery Manager

  35. Oracle Bill Presentment Bill Presentment Business Requirements • Generate invoices • User level customization • Integration with CM Implementation • RTF Templates • Conditional formatting • Single step reports

  36. 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

  37. 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

  38. Oracle Consolidation Hub FCH Business Requirements • Generate Excel & PDF output • Upload thru Excel • Report from Excel Implementation • RTF Templates • Excel Library • OA Framework integration

  39. Customers

  40. Customers

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

  42. NCR Business Requirements • Generate Bill of Lading • Barcode support • Multiple Delivery Channels • Supplemental Pages Implementation • RTF Templates • Conditional Formatting • External Font Mapping • Delivery Manager

  43. T3 Energy Services Business Requirements • Generate Checks • Signature Security • Multiple Delivery Channels Implementation • RTF Templates • External Font Mapping • Virtual Signature Images • Concurrent Manager Integration • Delivery Manager

  44. More Info • Demogrounds • Oracle.com http://www.oracle.com/technology/products/applications/publishing/index.html • XML Publisher Forum http://forums.oracle.com/forums/forum.jspa?forumID=245 • XML Publisher Blog http://blogs.oracle.com/xmlpublisher

  45. Q & A Q U E S T I O N S A N S W E R S

  46. Data Extraction • Any database or multiple databases • Distributed queries • XML Publisher Data Engine • Any ERP system • Any XML data server • Oracle Reports • DB Packages e.g. SQL XML • Any XML web services Oracle, SQL Server, DB2 PeopleSoft, SAP, Siebel Java, C++, Pearl, etc Web Services

  47. XML Publisher Data Engine • Fast, scalable extraction engine • Integrated into concurrent manager • Migration tools available from Oracle Reports • Offers all that Oracle Reports offers + 30-40% faster • Multiple queries + joins • Event triggers • Flexfield support • Formula/Summary columns • Java API layer for OAF support • Data Bursting(5.6.1) • Distributed Queries (5.6.1) Back

  48. Release 4.5 Features Installed with 11.5.10 • Templates • PDF • RTF • Outputs • PDF • XML • Template Manager • XML APIs • XML Report Publisher

More Related