Oracle Architecture & ERP Upgrade Program Reflection

1. NorCal OAUG Training Session 01/17/08Agilent Technologies retrospective: Oracle database (10g) and Oracle E-Business Suite (Release 11.5.10) upgrade January 17, 2008 Sreedhar Vaidyanathan, Viji Rathnagiri

2. Program Charter • Goals • The goals of this program were to simplify the Oracle Architecture through platform consolidation and application integration, and improve performance and supportability through an application and database upgrade. • Objectives • 1. Reduce the total cost of application ownership (Total Cost of Ownership) • 2. Resolve several outstanding application defects (Operational Stability) • 3. Maintain or improve system performance (Business Continuity) • Major Deliverables • Integrated Customer Logistics System Oracle ERP database and Global Oracle ERP database – process, data, organization structure. • Upgraded technology platform (application, middleware and database). • Merged Oracle ERP Planning and transaction databases.

3. World-wide impact… World-wide team Little Falls So Queensferry Barcelona Spokane Boeblingen Santa Rosa Chengdu Roseville Hachioji Palo Alto Gurgaon Santa Clara Hyderabad Loveland Bangalore Englewood Penang Col Springs Singapore Numerous NPI and FIC Sites worldwide

4. Deliverable #1: Integrated Logistics and Global ERP Databases Old Architecture 7 Legend (RED = obsolete after program): • Purchase order for parts not in stock. • Internal order acknowledgement. • Invoice Interface. • GL Interface. • Item Master publication. • Customer Master publication. • Asset and Warranty publication. • Customer Master publication. • Pricing. • Parts Availability. • Service or spare parts order. He1 Siebel CRM 4 Global Oracle ERP database 11 10 9 8 3 Customer Logistics System Oracle ERP database 1 2 5 6 New Architecture 7 8 Siebel CRM Global Oracle ERP database 9 10 11

5. Deliverable #2: Upgraded Technology Platform Oracle E-Business Suite 11i upgrade to release 11.5.10 • Oracle E-Business suite: Core technology foundation + Core modules in Order Management, Advanced Planning, Inventory, Manufacturing, Logistics, Shipping, Financials and Procurement + partial Sales suite. • Application extensions in Global ERP environment: Approximately 11000 technical objects were upgraded. • Integration of Customer Logistics System: integrated ~4200 technical objects; ~80 interfaces were reviewed and/or modified. • Boundary applications upgraded – Outerbay, Logical Apps, Taxware. Middleware upgrade TIBCO upgrade from 4.x to 5.2. Oracle Database upgrade Oracle database upgrade from 8i to 10gR2.

6. Deliverable #3: Merged Planning and Transaction Databases Old Architecture Planning Server OLTP Server Drivers for change: • Oracle Development recommended separate server for planning processes. • Reduction in database maintenance costs and release of 4 TB of disk space by eliminating 6 planning instances across various development, test and production environments. He1 64 CPUs @ 875MHz Mem - 128GB RAM • OLTP database 36 CPUS @ 750Mhz Mem – 96GB RAM • Planning Engine • Planning Database • OLTP Conc Mgr Data transfer between 2 databases New Architecture Planning Server OLTP Server 16 CPUs @ 900MHz Mem – 32GB RAM • Planning Engine 64 CPUs @ 875MHz Mem - 128GB RAM OLTP & Planning Merged Database Conc Mgr Server 16 CPUs @ 1GHz OLTP Conc Mgr

7. Upgrade Build & Test Deployment Key Activity BreakdownProgram Overview Integration Analysis & Design • Business and SOX Requirement Gathering • Fit Analysis • Gap Disposition (Design) • Org Structure Creation • Data Mapping • Data Migration • Data Validation and Reconciliation • Upgrade Analysis • Upgrade Design • Technical Object Build • Business System Testing • Data Testing • SOX Validation • Transition Testing • Training • Transition Activities • Cutover • Controlled Ramp • Stabilization

8. High Level Graphical Phase Plan

9. Test Strategy BCV CYCLE Test Cycle 0 Test Cycle 1 Test Cycle 2 Test Cycle 3 June 1 – July 7 July 17 – Aug 11 Sep 5 – Oct 20 Oct 30 – Dec 8 Dec 1 – Dec 14 Validate upgrade assumptions and perform limited CLS data migration Basic ERP functionality No Boundary systems # Tests Planned: 3500 % Completed: 90 % Pass: 80 Transaction test of all ERP processes. Validate CLS processes & applications CLS Processes & Data, ERP solutions, full mock Limited Boundary Systems # Tests Planned: 8700 % Completed: 85 % Pass: 70 End to end testing of all functional processes (both ERP and CLS) Performance, Integration, Usability of all ERP and CLS processes All Boundary systems # Tests Planned: 9859 % Completed: 76 % Pass: 63 End to end test of environment as it will exist in production 100% business processes verified functional All Boundary systems # Tests Planned: 13660 % Completed: 99 % Pass: 94 Demonstrate business continuity Final reconciliation process & contingency plans All Boundary systems APPROACH GOAL INFRA RESULTS

10. Oracle Corporation Engagement Highlights • Oracle Consulting participated in the Solutions, Testing, Deployment, Data and Transition tracks. • Oracle Consulting integrated with the Oracle On Demand team, who provide technical support for all of Agilent’s Oracle ERP test and production environments. This partnership was key to ensuring the development and test instances were upgraded and stable throughout the project. • Oracle Consulting actively participated in resolving product issues around functionality and performance, working closely with Oracle Product Management, Oracle Development and Oracle Support. This partnership extended across different levels of the project team and governance structure. • Examples of key wins from this tight partnership between Agilent and Oracle Corporation include: • Creative solutions to reduce the total time for applying database and application patches. • One off patches for Oracle Configurator issues “unique” to Agilent. • Incorporation of solutions requested by Agilent into Oracle Planning roll up patches. • Performance tuning of Oracle Quoting and Advanced Pricing. • Oracle Consulting collaborated effectively with Agilent’s other IT delivery partners on many technical deliverables for retrofitting applications and interfaces. • The bottom line – Oracle Corporation was a key partner in helping Agilent complete the database and applications upgrade on time!!

11. Results: Program by the numbers Records migrated for 21 data entities 24,309,475 Agilent IT hours logged (~320 person months) 54,834 Tests Executed (4 BSTs) 35,719 Issues Logged 7,770 Oracle Responsibilities created 7,000+ Technical Objects reviewed 15,000+ Hours of Command Center Coverage 4,800+ Tasks Triggered from the Command Center 3,900+ Hours of training delivered to Agilent personnel 2,651 Size of the Project Team 1,050+ Number of status reports generated 597 Design Documents (MD050s) delivered 198 Solution process areas assessed 139 CLS inventory organization setups 52 Number of Cutovers 1

12. Results: Benefits Delivered • Improved Oracle ERP platform stability and supportability. • Eliminated multiple Oracle application instances resulting in significant cost savings. • Enabled single instance visibility of transactions for the Product Sales and Services business groups. • Enabled a consistent “look and feel” of customer facing documents for the Product Sales and Services business groups. • Integrated Services business and factories into a seamless supply chain. • Eliminated several customizations and adopted standard Oracle functionality. • Eliminated dual maintenance of master level item data. • Reduced sources of customer data.

13. Results: Lessons Learned