Oracle XML Publisher Enterprise Reporting and Delivery Salim

Oracle XML Publisher Enterprise Reporting and Delivery Salim Odero Principal Sales Consultant, E-Business Suite Technology Oracle Corporation

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

XML Publisher Reduces Costs

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

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

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

A New Look For Your Business

Customer Productivity Flexible Customization

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

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

XML Publisher Advantage Separate data / layout / UI translation Data Logic Layout XML Publisher Translation üFlexibility üReduced maintenance Report output

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 Multiple Data Sources üRapid Deployment Report Output

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

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

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

Deli vered Report Output Screenshot

Concurrent Program Definition

XML Output File

XML Publisher Template Manager Screenshot

Oracle Applications Standardizing on XML Publisher

Apps Products Utilizing XML Publisher Ÿ Ÿ Ÿ Ÿ Ÿ HRMS/HCM DBI/PMV Purchasing Contracts Sourcing Quoting FSG e. Records Loans Ÿ Financials Consolidation Hub Ÿ AP / AR / FA Ÿ EPB Ÿ Ÿ Ÿ Ÿ Order Management i. Store Project Contracts Marketing Student Services Discrete Manufacturing Process Manufacturing Bill Presentment Internal Controls Manager Global Financials Sub Ledger Accounting SCM Projects

Human Resources Oracle 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)

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

Sourcing Oracle 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

Financials Oracle 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

DBI Oracle Daily Business Intelligence 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

Customer Implementations

Customers

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 Ÿ e. Text Templates Ÿ Template Builder

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

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

Oracle XML Publisher Thank You for Your Interest