160 likes | 577 Views
Corsair R12 Upgrade Upgrade from 11i (11.5.10) to R12 (12.1.3). Ramesh Potta Manager Business Applications. Agenda. Company Profile Business Challenges Key Factors Driving Upgrade Approach Lessons Learned Benefits. Company Profile - About Corsair.
E N D
Corsair R12 UpgradeUpgrade from 11i (11.5.10) to R12 (12.1.3) Ramesh Potta Manager Business Applications
Agenda • Company Profile • Business Challenges • Key Factors Driving Upgrade • Approach • Lessons Learned • Benefits CORSAIR CONFIDENTIAL
Company Profile - About Corsair • Corsair is a global company bringing innovative, high-performance components to the PC gaming market. Specializing in very high performance memory, ultra-efficient power supplies, and other key system components, our products are the choice of overclockers, enthusiasts, and gamers everywhere. • Business Locations : 60 Countries CORSAIR CONFIDENTIAL
Our Environment • What We Have • Oracle Modules • Core Financials (GL, AP, AR, FA, CE, Payments, EBTax) • Supply Chain (OM, PO, Mobile and Advance Pricing) • Manufacturing (Inventory, BOM and WIP) • Agile • AME • Custom Applications & Integrations • Web Store Integration (Online Store) • EDI • Freight Forwarder • Extensions & Customizations (Heavy) • Few Custom Forms • Lot of Forms Personalization • Materialized views and Views for reporting system. (Over 300 reports) • Automations for internal processes • Automations for external data to interface into Oracle • More…. • Cont… CORSAIR CONFIDENTIAL
Our Environment • Number of Users (Applications, Reporting) : 250 • Number of Legal Entities : 8 • Number of Operating Units : 8 • Number of Inventory Warehouses : 5 • Number of Consolidation Ledgers(Books) : 2 CORSAIR CONFIDENTIAL
Business Challenges • Stay on a supported release • Cut down financial period close process time • Use standard functionality for deferred COGS • Start to use Advanced Global Intercompany System • Performance (Processes, Reports) • Avoid financial reports customization • Short Implementation window of less than 4 months • Internal Team (with less than 3 resources) CORSAIR CONFIDENTIAL
Key Factors Driving Upgrade • Cost Savings • Hardware & Database Benefits • New Functionality/Modules CORSAIR CONFIDENTIAL
Upgrade Summary • Upgraded Applications from 11i (11.5.10) to R12 (12.1.3) • Upgraded database from 9i to 11g • Upgraded OS from 32 bit to 64 bit CORSAIR CONFIDENTIAL
Approach • Upgraded to Release 12.1.3 • Project scope and timelines established • Identified features that can be implemented prior to R12 • Internal Team for upgrade (2 FTE and part-time DBA) • Upgraded test instance for dry run testing by IT team • 2 CRP’s and UAT instances • Used Oracle UPK for test scripts, document business process and training • Full month end close process done in test system CORSAIR CONFIDENTIAL
Approach • UAT 1 – First dry run functionality - Feb -2011 • CRP1 – Mar 1st – Mar 31st 2011 • CRP2 – Apr 1st – Apr 30th 2011 • UAT – May 4th – May 20th 2011 • Go Live Cut Over – May 27th (Eob) - May 31st 2011 • Go Live June 1st 2011 CORSAIR CONFIDENTIAL
Implementation Statistics • Duration : 3.5 Months • Project Status : Completed • Go Live : On Schedule • Production Down Time : Less than 72 hrs • Production Upgrade DBA Hrs : 30 – 40 hrs • Process : 1 Test, 2 CRP’s, 1 UAT and Production • UPK’s Developed : Over 250 topics • Implementation Team : Internal • No. IT Staff : 2.5 • FTE : 2 • Applications DBA : 1 (Part-time) • No. of tasks identified : 1284 • Show stopper after Go Live : 0 • No. Issues after Go Live : Less than 6 CORSAIR CONFIDENTIAL
NewFunctionality(Used for our Environment) • Multi Org Access Control • SLA – To have better view of multiple ledgers/ Consolidation data for business decisions • Implemented deferred COGS • Improved Processing efficiency for General Ledger • Improved existing business processes • Avoided desktop tools by using WEB ADI • FSG Repository • AGIS – Advanced Global Intercompany System (Which replaces our custom Inter Company Process) • E -Business Tax Engine • Costing Hook & More… CORSAIR CONFIDENTIAL
Lessons Learned • Take advantage of new functionality in latest version of EBS to remove customizations • Make sure users allocate sufficient time to understand new and obsolete programs in R12 • Make sure all custom triggers exist and are attached to the correct tables. • Update all custom concurrent requests to be “single-mode” for operating units • You don’t have to cancel or complete workflows prior to the upgrade in order for those to be upgraded. • Implementation with internal team has greater advantage over external vendor CORSAIR CONFIDENTIAL
Benefits • Period close process achieved in less than 3 hrs • SLA Functionality • Minimized/Avoided customizations • WEB ADI • Improved reporting capabilities • Deferred COGS standard functionality • Advantages of Multi Org Access Control • Improved Processing efficiency for General Ledger • Improved existing business processes • Advanced database capabilities, better integration, newer extensions and personalization, and improved security for enterprise applications. CORSAIR CONFIDENTIAL
Q & A Thank You! Ramesh Potta rameshp@corsair.com rameshpotta@gmail.com CORSAIR CONFIDENTIAL