Easy Operational Reporting for R 12 with OBI

Easy Operational Reporting for R 12 with OBI EE, Cognos, and Business Objects Joe Dahl Product Specialist Noetix Corporation

Agenda • Release 12 Overview • Report Migration – Key Reporting Issues • Noetix

R 12 Functional Enhancements • 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 © 2003 -2009 Noetix Corporation. All rights reserved.

R 12 Functional Enhancements (Cont) • 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 10 g and some components of Oracle Fusion Middleware • Accelerated Implementation – Oracle accelerators can significantly reduce Release 12 implementation time © 2003 -2009 Noetix Corporation. All rights reserved.

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 © 2003 -2009 Noetix Corporation. All rights reserved.

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 © 2003 -2009 Noetix Corporation. All rights reserved.

Reports Will Break Report integrity a constant, costly challenge R 12 V 11. 5.

Reporting from Both 11 i and Rel. 12 • Re-implementing to address configuration imperfections V 11. 5. 10 R 12 © 2003 -2009 Noetix Corporation. All rights reserved. – Some data may not migrate • Global consolidation – Multi-instance environments no longer needed

How big is the problem?

What did it take for Noetix to Upgrade? • Analyze the Oracle R 12 documentation per • • module to identify any significant changes. Functionally test all views in R 12 to identify all affected views. Design and implement required functional updates – – Create new views Obsolete views add/modify columns add/modify profile options © 2003 -2009 Noetix Corporation. All rights reserved.

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

Total Effort ~ 10 person years • Validated and modified nearly 750 views –

Upgrade Protection V 11. 5. 10 R 12 [ reports written against database tables

Upgrade Protection R 12 [ reports written against database tables ] © 2003 -2009

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 11 i Payables “Accounting Events” © 2003 -2009 Noetix Corporation. All rights reserved.

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 © 2003 -2009 Noetix Corporation. All rights reserved.

Subledger Accounting – Report Migration Example • How do I reconcile my AP Invoices

View Changes 11 i GL_Je_AP_Inv_Dist_Details Release 12 GL_Je_SLA_AP_Inv_Dist GL_Sets_Of_Books GL_Ledgers PO_Vendors AP_Suppliers PO_Vendor_Sites_All AP_Supplier_Sites_All AP_AE_Headers_All XLA_AE_Headers AP_AE_Lines_All XLA_AE_Lines AP_Accounting_Events_All Various shown below: XLA_Events XLA_Event_Classes_TL XLA_Event_Types_TL XLA_Transaction_Entities XLA_Distribution_Links © 2003 -2009 Noetix Corporation. All rights reserved.

The Impact? • Some 11 i queries will easily migrate to Rel. 12 – Some with no changes at all – Some will need table name changes • Some 11 i 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 11 i queries won’t migrate 1: 1 to Rel. 12 – SLA may require new reports, queries & ETL routines © 2003 -2009 Noetix Corporation. All rights reserved.

How does Noetix address the problem?

BI Content Generation Experts Oracle E-Business Suite Siebel CRM People. Soft Noetix. Views Oracle Discoverer Noetix. Answers Noetix Platform Noetix Analytics Cognos BI Business Objects Oracle Business Intelligence EE ETL © 2003 -2009 Noetix Corporation. All rights reserved.

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

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

Noetix. Views leverages existing investments Noetix Web. Query Oracle Discoverer Noetix Dashboard Oracle BI Suite EE Virtual tables Business areas Business models Cognos 8 BI Models / Packages Data Access Layer Oracle E-Business Suite Noetix. Views © 2003 -2009 Noetix Corporation. All rights reserved. Business. Objects XI Business. Objects Edge Series Universe Other Third-party BI Tools Other data models

How BI Tools Ship – No Content © 2003 -2009 Noetix Corporation. All rights

Noetix Provides a Reporting Application With Any Front End Tool NOETIX HELP FILE OBI

Noetix. Views Coverage © 2003 -2009 Noetix Corporation. All rights reserved.

Noetix Generator for Oracle BI Generate object definitions Oracle E-Business Suite UDML Export UDML Convert UDML to RPD Noetix. Views Noetix. Answers RPD (Repository Model) Oracle BI Server © 2003 -2009 Noetix Corporation. All rights reserved. Generate Oracle BI Answers

Noetix Generator for Oracle BI • Any product / tool that works with the Oracle BI Server will work with generated RPD file – – – Supports Current Shipping Version © 2003 -2009 Noetix Corporation. All rights reserved. Oracle BI Answers Oracle Interactive Dashboards Oracle BI Publisher Oracle BI Delivers Oracle Briefing Books

Noetix Generator for Cognos Oracle E-Business Suite XML Generate query subjects Publish packages Noetix. Views Cognos Content Store © 2003 -2009 Noetix Corporation. All rights reserved. Generates Noetix. Views Roles

Noetix Generator for Cognos • Framework Manager • Report Studio • Query Studio • Content is published into the Cognos Content Store Supports Cognos 8 BI environment © 2003 -2009 Noetix Corporation. All rights reserved.

Noetix Generator for Business Objects Oracle E-Business Suite UNV Generate object definitions Export universes Noetix. Views Business Objects CMS © 2003 -2009 Noetix Corporation. All rights reserved. Generate security groups

Noetix Generator for Business Objects • • • Support for Business. Objects XI R 2 and Edge Series Standard (formerly Crystal Decisions Standard) © 2003 -2009 Noetix Corporation. All rights reserved. Universe Designer Info. View Web Intelligence Desktop Intelligence Crystal Reports

What’s In It for You? • Cost effective and faster time to market •

Questions & Answers