1 / 31

Joe Dahl Product Specialist Noetix Corporation

Leveraging NoetixViews to Support Report Migration from EBS 11i to R12 with OBI EE, Cognos, and Business Objects. Joe Dahl Product Specialist Noetix Corporation. Agenda. Release 12 Overview Report Migration Key Reporting Issues Noetix Solution - The Alternative Q & A.

sandell
Télécharger la présentation

Joe Dahl Product Specialist Noetix Corporation

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. Leveraging NoetixViews to Support Report Migration from EBS 11i to R12 with OBI EE, Cognos, and Business Objects Joe Dahl Product Specialist Noetix Corporation

  2. Agenda • Release 12 Overview • Report Migration • Key Reporting Issues • Noetix Solution - The Alternative • Q & A

  3. R12 Functional Enhancements (Part 1) • Enhanced User Interface • Release 12 still relies heavily on Oracle Forms, but the interface has been streamlined and given a cleaner look • Single Accounting Engine • Shared subledger accounting engine stores accounting entries in subledger tables that are standard across all products creating a single version of the truth • Global Financial Management • Users can be assigned to multiple operating units and processes, and transactions can span operating units

  4. R12 Functional Enhancements (Part 2) • Converged Inventory Module • The data model for process manufacturing and discrete manufacturing has been converged in a single model • Infrastructure Upgrade • Most Release 12 users will upgrade at least to Oracle Database 10g and some components of Oracle Fusion Middleware • Accelerated Implementation • Oracle accelerators can significantly reduce Release 12 implementation time

  5. Overall Goal of Enhancements • The Goal • Real time, role-based information with a common data model as a foundation for a single source of truth across the enterprise • The Implications • Changes in the underlying data management infrastructure can have a significant impact on reporting

  6. Key Reporting Issues • More than a dozen changes have an impact on reporting • The conversion from “sets of books” to “ledgers” • Funds disbursement processing moving from Payables to the new Payments application • Tax calculations centralized in the new E-Business Tax application • Check and letter processing information now in Oracle BI Publisher tables • Bank and supplier information now in the Trading Community Architecture (TCA) • Bank setup moving from Receivables to the Cash Management application

  7. V11.5.10 R12 Reports Will Break Report integrity a constant, costly challenge

  8. Re-implementing to address configuration imperfections Some data may not migrate Global consolidation Multi-instance environments no longer needed V11.5.10 R12 Reporting from Both 11i and Rel. 12

  9. How big is the problem?

  10. BI Content Generation Experts

  11. Your report Noetix view of the database HZ_PARTIES HZ_CUST_ACCOUNTS HZ_CUSTOMERS Order Lines Orders ATO Flag Booked Date Customer Customer No. Item Item Desc. Line Status Open Quant. Order No. Order Quant. Project Quantity Organization Order No. OE_ORDER_HEADERS_ALL Customer Customer No. OE_ORDER_LINES_ALL PA_PROJECTS_ALL OE_ORDER_LINES_ALL Cust. Status Booked Date PA_TASKS PA_TASKS MTL_SYSTEM_ITEMS_B Order Quant. Open Quant. MTL_SYSTEM_ITEMS_TL Selling Org. What is a Noetix view? Oracle database tables Flexfield column in the table [Oracle EBS upgrade] [doesn’t break] [remaps view] ATTRIBUTE1: “Customer Status” Flexfield column in the view Cust. Status

  12. NoetixViews Coverage

  13. What did it take for Noetix to Upgrade? • Analyze the Oracle R12 documentation per module to identify any significant changes. • Functionally test all views in R12 to identify all affected views. • Design and implement required functional updates • Create new views • Obsolete views • add/modify columns • add/modify profile options

  14. What did it take for Noetix to Upgrade? View Count 58 34 56 Modified 48 14 32 10 3 8 New General Ledger Accounts Payable Accounts Receivable 58 60 7 9 6 0 Fixed Assets Purchasing

  15. Total Effort ~ 10 person years • Validated and modified nearly 750 views • Across 24 modules

  16. V11.5.10 R12 R12 Upgrade Protection V11.5.10 [ reports written against database tables ] [ reports written against Noetix views ]

  17. R12 R12 Upgrade Protection V11.5.10 [ reports written against database tables ] [ reports written against Noetix views ]

  18. Subledger Accounting • All accounting performed before transfer to the GL • User-definable accounting rules • At the data level, it’s a big change for all the subledgers, though there is a first generation in 11i Payables “Accounting Events”

  19. Tie It All Together • Data flows from distributions, thru distribution links and SLA tables, to GL • Three key stages • Distributions (before accounting applied) • SLA (in draft or final form) • GL • Three key views of the data • Distributions only • Tie distributions to SLA to GL • Tie GL back to distributions

  20. Subledger Accounting – Report Migration Example • How do I reconcile my AP Invoices to the GL Journal Entries and distributions?

  21. View Changes

  22. The Impact? • Some 11i queries will easily migrate to Rel. 12 • Some with no changes at all • Some will need table name changes • Some 11i queries will need moderate attention • Data moved to TCA will require query re-writes • Customer correspondence will require re-writes • Basic reports can remain the same • Some 11i queries won’t migrate 1:1 to Rel. 12 • SLA may require new reports, queries & ETL routines

  23. How does Noetix address the problem?

  24. Your report Noetix view of the database HZ_PARTIES HZ_CUST_ACCOUNTS HZ_CUSTOMERS Order Lines Orders ATO Flag Booked Date Customer Customer No. Item Item Desc. Line Status Open Quant. Order No. Order Quant. Project Quantity Organization Order No. OE_ORDER_HEADERS_ALL Customer Customer No. OE_ORDER_LINES_ALL PA_PROJECTS_ALL OE_ORDER_LINES_ALL Cust. Status Booked Date PA_TASKS PA_TASKS MTL_SYSTEM_ITEMS_B Order Quant. Open Quant. MTL_SYSTEM_ITEMS_TL Selling Org. What is a Noetix view? Oracle database tables Flexfield column in the table [Oracle EBS upgrade] [doesn’t break] [remaps view] ATTRIBUTE1: “Customer Status” Flexfield column in the view Cust. Status

  25. Combine your set up with our subject matter expertise Information about your enterprise application Business Best Practices Financials Supply Chain Object Definition User Interfaces Human Resources Mfg. Business Rules Security [Interrogated] [Handcrafted] Generated data Business Views Reports Business Glossary [Configuration-specific Views] [Configuration-specific Answers] [Configuration-specific Help]

  26. NoetixViews leverages existing investments Data Access Layer OracleDiscoverer OracleBI Suite EE OtherThird-partyBITools Cognos8 BI BusinessObjects XI BusinessObjects Edge Series NoetixWebQuery Noetix Dashboard Universe Other data models Virtualtables Business areasBusiness models Models /Packages Oracle E-Business Suite NoetixViews

  27. How BI Tools Ship – No Content

  28. Noetix Provides a Reporting Application With Any Front End Tool NOETIX HELP FILE OBI EE COGNOS DISCOVERER

  29. Reporting from both 11i and Rel. 12 Some Customers want both V11.5.10 • Legacy data • Validation R12 [ reports written against Noetix views ]

  30. What’s In It for You? • Cost effective and faster time to market • Successfully meet project goals • Proven, tested and patented

  31. Questions & Answers

More Related