overview oracle applications 1515588

7/30/2019 Overview Oracle Applications 1515588

http://slidepdf.com/reader/full/overview-oracle-applications-1515588 1/31

5 Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Insert Information Protection Policy Classification from Slide 8

An Overview of Oracle's Use of Oracle

Applications

Dave Stephens, GVP, Oracle Applications Labs




We run the applications that run Oracle

We drive enhancements based on our experienceWe share best practices with our customers




Primary Oracle Internal Systems

CRM

• Sales Force Automation

• Marketing

Financials & Core ERP

• GL, AR, AP

• Quoting, Ordering, Contracts

• Service Contracts & Install Base

• Expenses and Procurement

HR• Core HR & Payroll

• Recruitment

System: Siebel

Support

• Incident Reporting

• Triage and Resolution

System: Siebel + Custom

System: E-Business Suite

Reporting

• Bookings & Forecasts

• Customer 360

• Support Contracts Backlog

• Actuals Reporting

Systems: OBIA & OBIEE




Mission Impossible: The Story You Know...




Enabling Efficiency: Finance SSC’s

• Controllers• Order Entry

• AR / Cash Apps• Exp Reporting

• Purchasing• Fixed Assets• Project Acct• Credit &

Collections• Customer Data




And Then

• Over 1000 enterprise application systems

• Regional and global ERP’s, CRM’s, fractured BI




Mission Impossible: The Sequel

• Deliver $1.5B in operational value

• Combine all major systems – Within 12 months of acquisition

– Implementing only global solutions

– Without impacting ongoing sales & support

In a business we’d never been in before




Timeline




Step 1 – HR & Payroll

• Within 13 days of US LEC

– We migrated all 12,000 Sun employees into Oracle’s global HR systems

– We successfully ran payroll using Oracle’s central Payroll systems




Step 1 – HR & Payroll

• Before

– Fragmented HR systems, combination of outsourced HR & internal systems

• After

– Single global HR system running R12 E-Business Suite

– Better reporting on retention, performance, and overall HR trends

• How

– Standard HR employee conversion template for M&A

– Automate employee data uploads

– Automated payroll processing




Step 2 – Service Contracts

• Within 6 months

– We migrated Sun’s entire 20M record install base

– And over 250K Support Contracts representing $ billions




Step 2 – Service Contracts

• Before

– Standalone 11i install base and service contracts system – Insecure, unreliable install base data (accessible by 15,000 employees)

– No standard structure for representing an asset’s topology

• After

– OM-integrated R12 install base and service contracts systems

• Hardware and software renewals run out of a single, global system for all of Oracle – Secure, reliable, install base data across hardware and software assets

– Defined standard structure for hardware asset topologies

• How

– Massively parallel data migration approach

– Data cleansing and enrichment tools – Central policy controls around user access (75 employees)




Step 3 – Global Trade Management

• Within 7 months

– Decommissioned SAP GTS system for hardware export compliance

– Became 1st live customer of Oracle GTM




Step 3 – Global Trade Management

• Before

– Over 1M manual screenings for export compliance per year

– Overly complex compliance checking scheme involving 69 custom systems

– Missing compliance checks for spares transactions

• After

– 100% automated screening for hardware export compliance without any gaps

– Out-of-the-box integration with E-Business Suite (no more custom interfaces)

• How

– Upgraded from SAP to Oracle

– Defined export screening policy around central TCA customer record




Step 4 – M9K Upgrade

• Within 8 months

– Migrated E-Business Suite from Sun E10K Machines to triple-nodeM9000




Step 4 – M9K Upgrade

• Before

– Central E-Business Suite running at or near capacity on software business alone – Sun hardware business adds 40% additional load

• After

– Hit target of CPU load < 20%, IOPS < 40%, Memory <40% for combined business

– Completed upgrade in less than 1 hour outage window

• How

– Database replay for true application load testing

– Oracle Application Testing Suite (OATS)

– SQL Performance Analyzer (SPA)

– Dataguard switchover (primary / standby)




Step 5 – Agile PLM

• Within 8 months

– Implemented a single PLM system across hardware engineering

– True “art to part”; Integrated PLM with Supply Chain for automatedpublication of ECO’s




Step 5 – Agile PLM

• Before

– Multiple standalone MatrixOne systems – No PLM, just PDM

– No single item or BOM standards, numbering, or attribution

– No integration with Manufacturing and Supply Chain systems, manual ECO’s

• After – Single global system for PLM, 25K Items, 4700 ECO’s to-date

– Standard item numbering, naming, and attribution

– Automated ECO’s to Manufacturing and Supply Chain

• How – Agile PLM + out-of-the-box interfaces




Step 6 – R12.1.3 Upgrade

• Within 9 months

– Upgraded 20TB Global E-Business Suite from R12.1.1 to R12.1.3

– Included all setups & code required for SCM go-live




Step 6 – R12.1.3 Upgrade

• Before

– E-Business Suite running Oracle’s software business only

• After

– Added SCM, including dedicated Value Chain Planning system

• How

– Took the first development build of R12.1.3 before even QA had a chance to runtheir regression testing

– Tuned 50,000 SQL scripts to complete upgrade across 20TB database in lessthan 9 hours total system downtime

– Contributed all performance tuning work back into standard product




Step 7 – Field Service

• Within 11 months

– Deployed new, web-based Support & Field Service solutions

– Centralized dispatch and implemented auto-scheduling to hit SLA’s




Step 7 – Field Service

• Before

– Disparate support systems with no install base access, resulting in 90% phonebased support delivery

– Regional field service systems and processes, manual FSE assignment

• After

– Single global web-based support system across software & hardware withcomplete and accurate install base record (90% phone 40% phone)

– Single global field service solution with central dispatch model worldwide

• How

– Oracle Field Service with Advanced Scheduler – Mobile client for daily schedule & FSE de-brief




Step 8 – Supply Chain Management

• Within 1 year

– Implemented brand new supply chain systems & processes

– Implemented brand new demand and supply chain planning systems

– Moved from pick-to-order to assemble-to-order supply chain




Step 8 – Supply Chain Management

• Before

– E-Business Suite running Oracle’s software business only

• After

– Added SCM, including dedicated Value Chain Planning system

• How

– Wind down of production on legacy system using roped-off inventory

– Dedicated Demantra and ASCP running daily and weekly schedules for demandand supply chain planning

– Integrated configurator embedded into Quote-to-order process with shared item

attribution across Ops, Engineering, and Ordering – Operational Data Store with cut data set using GoldenGate for real-time streaming




Mission Impossible: The Ending

• Delivered $1.5B in operational value

• Combined all major systems – Within 12 months of acquisition

– Implementing only global solutions

– Without impacting ongoing sales & support

And cut IT costs by over $50M




Now - Primary Oracle Internal Systems

CRM

• Sales Force Automation

• Marketing

Financials & Core ERP

HR

Value Chain Management

• Items, BOMs, Configurations

• Global Inventory

• Internal and External Mfg

• Field Service

• Planning

System: Siebel

Support

• Incident Reporting

• Triage and Resolution

System: Siebel + Custom

System: E-Business Suite

Reporting

• Bookings & Forecasts

• Customer 360

• Support Contracts Backlog

• Actuals Reporting

• SCM Operational Reports

Systems: OBIA, Hyperion,GoldenGate & OBIEE




What’s Next: 3 Things




Complete Sun Integration

• Global deployment of Service Logistics including ServiceParts Planning – September 25th: Americas Go-Live

• Replaced Servigistics with Service Parts Planning

• Single Value Chain Planning across SCM and Service Logistics• Global Single Inventory across Manufacturing & Spares

– Europe and APAC Go-Lives to follow within weeks

– Standard B2B Integration with Logistics provider




Deploy Oracle Fusion Applications

• We are aggressively implementing Fusion Applications – Fusion CRM

– Fusion HCM

– Fusion Accounting Hub

– Fusion ERP for select subsidiary• First go-live scheduled for end-of-year




Open a Conversation with You

• Show what an all-Oracle shop can do

– Pushing the boundaries on: Agility, Automation, Insight

• Be “Apps Scientists”

– Recording quantitative results on what

works and what doesn’t

• Share our findings with you!

– Producing running series of technicalwhitepapers by functional area

– Twitter: @OracleAppsLabs

can do

lity,

n what

hnical

overview oracle applications 1515588

Documents