Quick and Easy Access to your Oracle Apps

Quick and Easy Access to your Oracle Apps Data Stan Choflet Jaros Technologies 3 -7 -05 Jaros Confidential

Proposed Agenda • Current Reporting Environment • Alternative Solutions: the Market • Best Practices – – The Data Warehouse Packaged Approach Value Proposition Best Practices Architecture, Functionality Customer Examples • Technology Demonstration Jaros Confidential

Range of Approaches Corporate Portals Plumtree, BEA, Oracle, IBM BI Tools Jaros Excelerator Abstraction Micro. Strategy Jaros Cubes ODS Views Metadata Data Marts Transactional Systems Jaros Confidential Jaros ODS Jaros Insulation Views

ERP/BI Evolution Data Warehouse Standard Reports Effort ERP Rollout ROI Custom Reports Data Marts Views Excel Key Sites BI Focus Smaller Sites Time Jaros Confidential Customer Satisfaction

Data Growth/Performance Relationship Performance History Open Transactions Source: Outer. Bay Technologies Jaros Confidential

Customer Example – Run Times Total Daily Run Time for Manufacturing Release Space Allocated for SO_LINES_ALL (including indexes) Purge Jaros Confidential Purge Source: Customer Study, Outer. Bay Technologies

Typical Scenario Executive wants to know revenue and backlog (relative to forecast) and margin by reporting product line, by customer, month to date, quarter to date, year to date Sources of Data: Jaros Confidential

Typical Reporting Process AR PL/SQL Staging Reports OE FND INV CST Forecast Product Reporting Line Jaros Confidential Most significant portion of the effort is in writing PL/SQL

Reporting Simplified Extraction, Transformation, and Load (ETL) AR Legacy Forecast, Reporting Product Line Jaros Confidential CST INV FND OE

Star Schema - Reporting Simplified Time Dimension Reporting Product Line Dimension Revenue Fact Product Dimension Customer Dimension Jaros Confidential

Gartner’s Best Practice BI Foundation Key Concepts: • Single source of the truth • Don’t report on transaction sys • DW/ODS: Optimized reporting • Foundation for analytic apps • Multiple data sources • Lowest level of detail Jaros Confidential

Jaros Company Overview Background / Experience • Oracle Applications, Database • Custom Data Warehouse Development • Manufacturing, Distribution Industry Experience Jaros Analytics Coverage • GL, AP, AR • Purchasing • Orders, Shipments • Inventory, Costing • BOM, WIP, Master Scheduling/MRP • HR, Payroll (Beta) • Service & Contracts (Beta) • Planned: Fixed Assets, Projects, Advanced Security Model, MFG PRO Jaros Confidential Jaros Analytics Customers

Packaged Analytics Value Prop • EDW: Enterprise Visibility, Enterprise Efficiency • Dramatically TCO, Time, Risk – 2 day install, 6 -8 week base implementation – Buy vs. Build: emerging market • Pre-built, Focused Content – 70 -80% out of the box (Oracle Fin, OM, PO, Mfg, Inv) • Unique, Modern Approach – Architecture and Tools for Enterprise Integration – Near Real-Time Tactical Reporting – Extensibility of Architecture • Account Segments, Flexfields, Hierarchies, Business Rules • Custom, Legacy Integration “Jaros customers get what they want” Jaros Confidential

Best Practices Architecture Any BI Tool AR Aging Financials Working Capital Vendor On. Time Inventory/ Costing Purchasing Customer Performance Material Consumption Orders Shipping Mfg HR/Payroll Data Marts & Analysis Areas Jaros ETL Operational Data Store (ODS) Near Real Time Tactical Reporting Generic ERP API Legacy/ Spreadsheets Jaros Confidential Views / Change Tracking Oracle Apps 10. 7 Oracle Apps 11 i Jaros ETL Generic ERP API MFG PRO Other ERP, CRM

Data Marts: Analysis Areas • Financials – Account Margins • Costs, margins by COGS, revenue, and receivables accounts – – – AP Invoices Summary AR Aging Detail with configurable buckets AR DSO Snapshot AR Sales (Summary with YTD, QTD, MTD growth vs. Goal, Plan) GL, Drill to AP, AR subledgers • Purchasing – Variance Analysis (PPV. IPV) at PO receipt time • To sub element cost level by vendor, inventory org, account segment, etc. – PO Vendor On-Time Performance Summary • By request date and promise date – PO Vendor Outstanding Balances Summary – PO Vendor Payment History Summary Jaros Confidential

Analysis Areas (Con’t) • Sales, Shipments, Customers – – – – Net Bookings Customer, Sales Rep, Product Analysis List Price, Selling Price, COGS, Gross Margin, Discount Analysis Open Orders including costing, margins OM Customer Service Summary (on-time % by customer, item) OM Lead Times Summary Outstanding Work Orders (ability to deliver on time) • • Production and Efficiency – – – • Supports ATO, PTO, kits, standard items; Flow and Discrete INV On-hand Snapshot (units w/ sub element costs) INV Item Turns Snapshot with configurable Turns calculation INV Obsolete Inventory Analysis Summary MFG Usage (WIP, Sales Demand) MFG Forecast vs. Actual Summary WIP Analysis, Operational Variance Analysis, std vs. actual BOM with Cost – Detailed BOM Analysis with Cost – Unit, Elemental, Sub-Element Cost Jaros Confidential

Features • Multi-Currency Support – Global, Transacted, and Set of Books Currencies throughout – Ex: Drill from consolidated set of books to detail in USD • Cross Functional Analysis – Filter by 30+ conformed dimension tables – Drill Across Subject Areas • Near Real Time Updates • Historical Trending and Snapshots Jaros Confidential

Best Practices % of user population: Static Docs 85% 15% Dashboards, Reports, Ad-hoc Query, Drill Down ROLAP or MOLAP DW/ODS – “Single Source of the Truth” Multiple Data Sources Jaros Confidential

Enterprise Visibility Jaros Global DW Sales Finance Procurement Manufacturing Inventory Oracle – US MFG PRO - US Jaros EUR DW Cullinet - US Oracle 1 – EUR Oracle 2 – EUR Jaros So AM DW Oracle Brazil Jaros Confidential MFG PRO - EUR

Enterprise Sales Visibility - 13 ERP Systems Jaros Global Sales DW Oracle 1 MAPICS Legacy MAN-MAN 4 th Shift Oracle 2 Legacy 2 Jaros Confidential

Jaros: Fastest Time to Results ü Single Repository for Management Information ü Company-wide, comprehensive ü Integrate Oracle and non-Oracle data ü Fin, OM, Mfg, Inv, PO out of the box ü Easily Integrate non Oracle data ü Portal for docs, pubs, links ü Near real time and daily updates ü Enterprise Portal/Dashboard ü ü Tables, graphs, metrics, trends, drill down Role-based security Web, intra/extranet access User friendly, customizable ü Enterprise-class system ü Highly available, high performance ü User documentation for Oracle, extendable to others Jaros Confidential

Jaros Demo Environment IE 6. 0 Jaros Dashboard Discoverer 9 i. R 2 Jaros EUL BEA Web. Logic Server Oracle 9 i, Jaros Data Marts Oracle – 11. 5. 8 Vision Data Jaros Confidential ETL