Easy Operational Reporting for R12 with OBI EE, Cognos, and Business Objects
Joe DahlProduct Specialist
Noetix Corporation
©2003-2009 Noetix Corporation. All rights reserved.
Agenda
• Release 12 Overview
• Report Migration
– Key Reporting Issues
• Noetix Solution - The Alternative
• Q & A
©2003-2009 Noetix Corporation. All rights reserved.
R12 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.
R12 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 10g 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
V11.5.10R12
©2003-2009 Noetix Corporation. All rights reserved.
Reporting from Both 11i and Rel. 12
V11.5.10
R12
• Re-implementing to address configuration imperfections
– Some data may not migrate
• Global consolidation– Multi-instance
environments no longer needed
How big is the problem?
©2003-2009 Noetix Corporation. All rights reserved.
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
©2003-2009 Noetix Corporation. All rights reserved.
34
14
3
Accounts Payable
56
32
8
Accounts Receivable
58
7
6
Fixed Assets
58
48
10
General Ledger
60
9
0
Purchasing
View Count
Modified
New
What did it take for Noetix to Upgrade?
©2003-2009 Noetix Corporation. All rights reserved.
Total Effort ~ 10 person years
• Validated and modified nearly 750 views– Across 24 modules
©2003-2009 Noetix Corporation. All rights reserved.
R12 R12V11.5.10
Upgrade Protection
[ reports written against database tables ]
[ reports written against database tables ]
[ reports written against Noetix views ]
[ reports written against Noetix views ]
V11.5.10
©2003-2009 Noetix Corporation. All rights reserved.
Upgrade Protection
R12
[ reports written against database tables ]
[ reports written against database tables ]
[ reports written against Noetix views ]
[ reports written against Noetix views ]
V11.5.10R12
©2003-2009 Noetix Corporation. All rights reserved.
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”
©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 to the GL Journal Entries and distributions?
©2003-2009 Noetix Corporation. All rights reserved.
View Changes
11i 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 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
How does Noetix address the problem?
©2003-2009 Noetix Corporation. All rights reserved.
BI Content Generation Experts
Oracle E-Business Suite
Siebel CRM
PeopleSoft
NoetixViews
NoetixAnswers
Noetix Analytics
Oracle Discoverer
Noetix Platform
Cognos BI
Business Objects
Oracle Business Intelligence EE
ETL
©2003-2009 Noetix Corporation. All rights reserved.
MTL_SYSTEM_ITEMS_B
HZ_CUSTOMERS
OE_ORDER_LINES_ALL
OE_ORDER_HEADERS_ALL
MTL_SYSTEM_ITEMS_TL
PA_PROJECTS_ALL
PA_TASKS
What is a Noetix view?
Oracle database tables Noetix view of the database
Order Lines
ATO Flag
Booked Date
Customer
Customer No.
Item
Item Desc.
Line Status
Open Quant.
Order No.
Order Quant.
Project
Quantity
Organization
[remaps view] [doesn’t break][Oracle EBS upgrade]
Cust. Status
ATTRIBUTE1: “Customer Status”
Flexfield column in the table
Your report
CustomerCustomer
Selling Org.Selling Org.
Cust. StatusCust. Status
Open Quant.Open Quant.
Order Quant.Order Quant.
Booked DateBooked Date
Order No.Order No.
Orders
Customer No.Customer No.
Flexfield column in the view
HZ_CUST_ACCOUNTS
OE_ORDER_LINES_ALL
HZ_PARTIES
PA_TASKS
©2003-2009 Noetix Corporation. All rights reserved.
Combine your set up with our subject matter expertise
Business Views Reports
[Configuration-specific Views]
[Configuration-specific Answers]
Object Definition
Information about your enterprise application
User Interfaces
SecurityBusiness
Rules
Financials
Business Best Practices
Supply Chain
Mfg.Human
Resources
[Interrogated] [Handcrafted]
Business Glossary
[Configuration-specific Help]
Generated data
©2003-2009 Noetix Corporation. All rights reserved.
NoetixViews leverages existing investments
Cognos8 BI
BusinessObjects XI
BusinessObjects Edge Series
Oracle E-Business Suite
NoetixViews
NoetixWebQuery
Noetix Dashboard
OtherThird-party
BI Tools
OracleDiscoverer
OracleBI Suite EE
Data Access Layer
Virtualtables
Models /Packages
UniverseOther data
modelsBusiness areas
Business models
©2003-2009 Noetix Corporation. All rights reserved.
How BI Tools Ship – No Content
©2003-2009 Noetix Corporation. All rights reserved.
Noetix Provides a Reporting Application With Any Front End Tool
NOETIX HELP FILE
OBI EE
COGNOS
DISCOVERER
©2003-2009 Noetix Corporation. All rights reserved.
NoetixViews Coverage
Oracle E-Business Suite 11i & 12.0
Financials Discrete Manufacturing Asset Lifecycle Management General Ledger Bill of Materials Enterprise Asset Management Payables Work in Process Receivables Inventory Service Assets Master Scheduling/MRP TeleService
Cost Management Install BaseProcurement Quality Depot Repair
Purchasing Field ServiceProcess Manufacturing Service Contracts (LA)
Order Management Product Development Order Management Process Planning Projects
Process Execution Project CostingHuman Resources OPM Financials Project Billing
Human Resources OPM Inventory Advanced Benefits Grants Payroll (US, UK, CAN, & AUS legislations) Project Manufacturing Grants Proposal Time and Labor Project Manufacturing (LA) Grants Accounting
EBS Administration Advanced Planning and Scheduling Industry Verticals Application Object Library Advanced Supply Chain Planning US Federal Financials Finanicals Interface Tables
PeopleSoft Enterprise 8.9 Siebel CRM 6.0 - 8.0
Human Capital Management Customer Releationship Management Human Resources Sales Payroll North America Service Time and Labor Call Center
Marketing Horizontal Applications Vertical Applications
©2003-2009 Noetix Corporation. All rights reserved.
Oracle E-Business Suite
NoetixViews
OracleBI ServerOracle
BI Server
Generate object definitions
Export UDML
Convert UDML to RPD
UDMLUDML
RPD(Repository
Model)
RPD(Repository
Model)
Generate Oracle BI AnswersNoetixAnswers
Noetix Generator for Oracle BI
©2003-2009 Noetix Corporation. All rights reserved.
Supports Current Shipping Version
Noetix Generator for Oracle BI
• Any product / tool that works with the Oracle BI Server will work with generated RPD file
– Oracle BI Answers
– Oracle Interactive Dashboards
– Oracle BI Publisher
– Oracle BI Delivers
– Oracle Briefing Books
©2003-2009 Noetix Corporation. All rights reserved.
Noetix Generator for Cognos
Oracle E-Business Suite
NoetixViews
Generates NoetixViews Roles
Generate query subjects
Publish packages
CognosContent Store
CognosContent Store
XMLXML
©2003-2009 Noetix Corporation. All rights reserved.
• Framework Manager
• Report Studio
• Query Studio
• Content is publishedinto the Cognos Content Store
Supports Cognos 8 BI environment
Noetix Generator for Cognos
©2003-2009 Noetix Corporation. All rights reserved.
Noetix Generator for Business Objects
Oracle E-Business Suite
NoetixViews
Generate security groups
BusinessObjects CMS
BusinessObjects CMS
Generate object definitions
Export universesUNVUNV
©2003-2009 Noetix Corporation. All rights reserved.
• Universe Designer
• InfoView
• Web Intelligence
• Desktop Intelligence
• Crystal Reports
Support for BusinessObjects XI R2 and Edge Series Standard (formerly Crystal Decisions Standard)
Noetix Generator for Business Objects
©2003-2009 Noetix Corporation. All rights reserved.
What’s In It for You?
• Cost effective and faster time to market
• Successfully meet project goals
• Proven, tested and patented
Questions & Answers