Oracle BI Publisher for JD Edwards

1. Oracle BI Publisher for JD Edwards Greg Smith Oracle Principal Sales Consultant

2. Disclaimer The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It 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 for Oracle’s products remains at the sole discretion of Oracle.

3. 5 • Oracle Predictive Modeling Tools • Hyperion Essbase • Real Time Decisions Oracle’s EPM System 5 4 • Oracle Performance Mgmt Applications • Hyperion Planning and Budgeting • Hyperion Financial Management • more 4 3 • Oracle BI Applications • Financial Analytics • Supply Chain & Order Mgmt Analytics • Procurement & Spend Analytics • more 3 2 • JDE E1 Operational Consoles • Financial Mgmt & Compliance Console • Plant Manager Dashboard 2 JDE E1 1 1 • JDE E1 Standardized Reporting • JDE E1 UBE, QBE (Query By Example) • Oracle BI Publisher Business Intelligence Continuum for JDE E1 Strategic Dynamic Past Oriented Future Oriented Operational Static Roadmap subject to change without notice. The above is intended forinformation purposes and may not be incorporated into a contract.

4. JDE Reporting Strategy • Enable E1 & World customers the tools and mechanisms necessary to Extract, Transform, Publish, Distribute data without requiring dependence on third party applications. • At the same time to provide E1 & World (via JDBC adaptor) customers the services and mechanisms necessary to facilitate use of third party applications should they choose to use them. • To deliver this capability across the spectrum of reporting needs from batch processing through business intelligence and analytics

5. Oracle BI Publisher – What and Why • BI Publisher formerly called XML Publisher • BI Publisher is an Oracle Fusion Application • Design / maintenance of report layouts is simpler • Layout templates are designed in MS Word • Users can design & preview the reports themselves • using sample data from E1 and World • BI Publisher can be called from RDA/UBE, World Writer, Dream Writer, World Export • E1 and World’s database could be accessed from BI Publisher • JDBC driver for E1 and World

6. Design reports using E1 & World data

7. From Data to Destination PDF Email E1, World, Siebel, Hyperion, etc RTF Printer HTML Oracle, SQL Server Excel BIPublisher Fax XML XSL Java, C++, Pearl, etc WebDAV Templates EDI EFT • Word • Excel • Acrobat • JDeveloper • Government • PDF forms e-Commerce Web Services Data Source Layout Tools Output Destinations

8. Report EFT XML Three “moving parts” BI Publisher Desktop Word withPlug-In E1 UBE World DW, WW etc Batch or Interactive Export or JDBC Template Data Acrobat 2. 1. BI Publisher Engine 3. Email or Fax Web Site Printer

9. Controller CEO BI Publisher Government XML B2B Extract Once – Publish Multiple Times Data from E1 & World EFT Banking EFT Excel HTML PDF XML XSL Different Templates For different output layouts

10. Multi-Site, Multi-National Companies: • Create one report template that can be shared by all • Government forms (PDF) can be filled out with World data • Static text on the report (headings, etc) can be translated • BI Publisher contains a full set of Unicode Fonts • No need for language-specific printers • BI Publisher supports 185 languages

11. EMBEDDED An event in JDE E1 triggers the report. Need to update data in the database. Data manipulation. No user action. INTEACTIVE An event outside of JDE E1 triggers the report. Read only data. Minimal data manipulation. Ad-hoc or on-demand. When to use Embedded or Interactive Reports??

12. <Insert Picture Here> BI Publisher Template Creation

13. User Generates XML from E1/World • Use the Export feature from World Writer, DW • Save the output file on your IFS drive of the System I • Save the file as .XML </WW_DTL> <WW_DTL> <WW_AddressNumber>4006</WW_AddressNumber> <WW_A5AN801>A&amp;B Electric Motor Service</WW_A5AN801> <WW_A5AN806>Denver</WW_A5AN806> <WW_A5AN807>CO</WW_A5AN807> <WW_AmtInvoicedThisYr>5390.00</WW_AmtInvoicedThisYr> <WW_AmtInvoicedPriorYr>9870.00</WW_AmtInvoicedPriorYr> <WW_ReportCodeAddBook003>MDW</WW_ReportCodeAddBook003> <WW_ABAC0301>Midwestern</WW_ABAC0301> </WW_DTL>

14. A User-Designed Template in MS WordTable

15. A User-Designed Template in MS WordChart

16. Preview

17. <Insert Picture Here> BI Publisher Interactive

18. Defining the report in BI Publisher

19. BI Publisher Enterprise Edition

20. BI Publisher – Interactive Reports

21. BI Publisher – Interactive Reports

22. BI Publisher – Interactive Reports

23. BI Publisher – Interactive Reports

24. BI Publisher – Interactive Reports

25. <Insert Picture Here> BI Publisher Embedded – E1

26. OMW Integration - Report Definition Setup

27. Report Definition - Setup Default Output type: automatic choice Available Output types: can be chosen at submission Language Choice is driven by available templates Selected Languages: all those checked will print User Preference Language: prints if available

28. Report Definition - Setup This report will burst on address - A full set will be sent to Max - A full set will be sent to Curtis - An individual section will be sent to each email found

29. Report Definition - Runtime

30. BI Publisher High-Fidelity ReportingOne Solution for All Document Needs • Purchase Orders • Labels / Bar Codes • Collateral • Employee Forms • Government Forms • Order Forms • Invoices • Operational Reports • Correspondence • Financial Statements • Checks