Best Practices at ATT.ppt

1、Best Practices at AT&T,Oracle Real Application Clusters (Oracle RAC) & Oracle E-Business Suite,Bryon Rickey Ravi KayarthodiSeptember 20th, 2010,Agenda,Welcome and Introductions Supply Chain Management (SCM) environment Overview/highlights Architecture Partnership with Oracle to transform our Busines

2、s Key project highlights Future initiatives Solution Support Center (SSC) and on-site support Q&A,About AT&T,AT&T is one of the worlds largest Telecommunications companies AT&T Global Headquarters is based in Dallas, TX AT&T has approximately 290,000 employees AT&T has more than 90 million wireless

3、customers AT&T has more than 16 million high speed internet subscribers AT&T has more than 2.5 million uverse subscribers Exclusive U.S. provider of iPhone 3G / 3GS / 4,AT&T SCM: Architecture highlights,Oracle E-Business Suite Centric Scale-up with cluster database on very large infrastructure High

4、availability with Oracle Data Guard, Oracle GoldenGate, and site level redundancy Central inventory/financial management; utilizes product hub, planning/forecast with ASCP/Demantra Order orchestration and brokering with in-house developed Oracle based application system Internet deployment for inter

5、action with external suppliers Management reporting/profitability analysis; procurement and spend analytics Industry leading warehouse/distribution management systems,AT&T SCM Platform: Financial Integration,Both Network and Retail SCM - financial counterparts are integrated in the same platform: Sh

6、ared AP, AR, PA, FA, and GL Supply Chain transactions leverage same referential data and accounting rules Financial integration of supply chain transactions are seamless and are recorded real-time in the general ledger No need for reconciliation between sub ledgers Ability to forecast financial impl

7、ications based on SCM forecasts Online financial budgeting validation on purchasing and requisitions Analytical GL Cube and Inventory Cube,Results,AT&T has saved more than $500 million and has improved its purchasing power by combining accounts with its vendors. Estimated to save $1B in inventory co

8、sts, and $300M per year in reduced operating costs. Warehouses have been able to keep inventories low without missing SLA, resulting reduced overall inventory costs. Ability to identify sold merchandise, resulting in fewer fraudulent returns,Industry Recognition,2010 IDGs CIO Award Recognizes organi

9、zations around the world that exemplify the highest level of operational and strategic excellence in information technology,Systems Architecture,AT&T SCM: E-Business Suite Centric,AT&T SCM: Key Systems Architecture,Oracle E-Business Suite 11i,Inventory Planning,Purchasing,Financials,Corporate Asset

10、Tracking,Distribution Center,Warehouse Mgmt,Inventory Tracking,Receipts,Receipts,Shipments,EDI,EDI,Audits,Repairs,AP,PO,ODP,eAuction,GL,FA,PA,ASCP,OM,RNF,Moves,Opus,Oracle 11i E-Business Environment,Dealers/ iStore,Store Replenishment,Direct Fulfilment,National Retailers,DSL and uVerse HSIA,Store,XB

11、M/Insurance,Dealer/NR,Service Depots,Sales,Returns,Order Management,Forward Orders,Upfront,Reverse,Company Owned Retail,Planning,Purchasing,Inventory,Receivables,Financials,Oracle E-Business Suite 11i Apps,EPL,RU30,AT&T SCM Platform: Oracle10g RAC Infrastructure: VCS+ CRS,AT&T SCM Platform: Transact

12、ion Volume,Approximately 3.35 million logons to the production areas per day 2.06 billion SQL executions per day Approximately 136.5 Billion logical reads and 41TB of physical reads performed per day Approximately 7 TB of writes performed per day Approximately 1.05 billion user calls and 52 million

13、transactions completed per day 200,000 concurrent request per day,AT&T SCM Platform: Operational architecture,Decoupled month-end book closing preparation Statistics gathered on a clone Separate reporting environment refreshed nightly; Inventory and GL Cubes for reporting Revenue share and allocatio

14、n on a separate system Direct supplier interaction with Internet-deployed application modules Utilizes market making mechanisms (sourcing),Oracle 11i ERP/SCM Reporting environment Refresh Summary,ERP PROD,L-TRA,Data Guard,Shadow Image,RPT,Asset Tracking,Archived Transaction History,External System,N

15、ightly reporting database refresh Nightly Asset Synch and Audit summarization from PA, FA, AP,PO,CATS Network SCM reporting data to external System 251 Stored Discoverer reports with over 21,000 folders Business Objects reports (Ad-hoc and out-of-box) Reporting environment is available for summary a

16、nd detail reporting. Complete set of data is available as of previous day 11:00pm,BI Discoverer,BOBJ,Corporate Warehouse,Asset Synch,Data Guard,AT&T SCM: Oracle 11i Dev/Test Configurations,PROD,L-TRA,RPT,R-TRA,DEV,QA,DEV,DEV,QA,DEV,DEV,QA,DEV,DEV,QA,DEV,Data Guard,Data Guard,Flex Clone,FTP,HDS USP-V

17、,HDS USP-V,Bothell, WA,MET1,Shadow Image,NetApp GOLD,Data Guard/ Custom Shipping,NetApp Master,Flex Clone,MET2,Shadow Image,NetApp GOLD,NetApp Master,Data Guard/ Custom Shipping,Flex Clone,Flex Clone,Shadow Image,SnapMirror,Alpharetta, GA,FTP,Storage Efficiency with NetApp de-duplication Tools Perfo

18、rmance test environment on tier-1 storage,AT&T SCM: Oracle Automatic Storage Management,Local and Remote DR databases and also Reporting databases have been migrated to ASM storage to meet storage and capacity needs Avoided SFRAC costs Performance SCMP DR/BC database converted to RAC database Saved

19、SFRAC license cost on E25K frames Comply with AT&T standard for cluster database (ASM is required) Expected to save cost in the future when we upgrade other Corporate Systems databases,AT&T SCM: Archive and Purge,Archive Stats 16 custom and core modules including (GL, INV, OM, AR, WSH, PO, FA) Execu

20、ted weekly, monthly, quarterly, and yearly History instance Informatica Data Archive application used Schedule is monitored real-time to ensure adherence Purge Stats 70 jobs via Oracle concurrent programs Executed daily and weekly Schedule is monitored real-time to ensure adherence,AT&T Supply Chain

21、 Geographic Distribution DB Flow to Test and Dev,XX,XX,Prod,Dev/Test,DR Site,Test Site 1,Development Site 1,Primary Site,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,XX,Development Site 2,XX,XX,XX,XX,Test Site 2,XX,XX,XX,XX,AT&T SCM: Spend Analytics,Top 5 Categories,Top 5 Suppliers,Line Of Busine

22、ss,Spend,Oracle Business Intelligence Enterprise Edition (Oracle OBIEE) Powered Sourcing from Oracle E-Business Suite and Legacy Applications,AT&T SCM: Database Maintenance/Performance Management,Monthly month-end close of books stats validation database statistics preparation on production clone Ta

23、ble Re-organization routine and ad-hoc Periodic index rebuild Daily performance call Daily/weekly/monthly/yearly purge/archive schedules vigilance in adhering to them Extensive performance monitoring on all levels of the system,Partnering with Oracle Advanced Customer ServiceOracle Solution Service

24、Center (SSC),SSC: Project Spotlight: Patch Recommendations,23,Value Addition SSC and AT&T worked together to create a new process to efficiently identify required patches with the goal to minimize the impact of rolling them out in our production environment and to current/future projects: Quarterly

25、document for AT&T environments with the latest recommended patches. Participation on AT&T IT meetings to clarify recommendations and questions Provide detailed patch analysis on a ad-hoc basis Successful roll out of AP.O patchset along with other Financials patches in February 2010: stabilized produ

26、ction environment and brought environment to the latest code base. Successful completion of the ASCP Rup 37, Collections Rollup (RUP) 32 and Application Technology Group (ATG) RUP-7 for the April 2010 production rollout.,SSC: Project Spotlight: Performance Improvement,Value Addition Active participa

27、tion on Conference bridge calls and OWC sessions. Engage Oracle development groups (Financials and Apps Performance) to provide SQL tuning improvements. Improve month end close activities like AR close, depreciation and asset retirement, optimizer, Invoice Validation processes. Maximize performance

28、during month end, preventing delay; AT&T was able to successfully meet the SLAs for the Month End Close Processes month after month. Provide recommendations for major upgrades (DB, Applications and Tools),SSC: Critical SR Spotlight: Other Key areas of focus,Value Addition Active participation on con

29、ference bridge calls and OWC sessions Review current setups and schedules of workflow Background Process Engage on Severity-1 SR and work collaboratively with Oracle development to provide workaround (eg. skip script) Work with at&t and Oracle development organization to provide scripts to clear wor

30、kflow DEFERRED queue Monitor the implementation of recommended suggestions Engage Oracle Development and RAC COE team Engage on Architectural design discussions Stand-by support for DB/RAC upgrade deployment activities Ensure successful implementation of RAC upgrade Rollout,SSC: AT&T Targeted Servic

31、es: Operations,Supply Chain Transformation (Streamline Operations for newly deployed modules) Work with ACS sales to determine appropriate support for upcoming SC rollout. Determine/secure funding for new modules (Demantra and Transportation Management Suite) Develop, Enhance and Secure development

32、sponsors Participate in scheduled project “Deep Dive” calls with PMO and project team Site visit to Memphis to understand warehouse and logistic operations understand business functions. Supply Chain Business develop key relationships with Retail and Network business users,11i Financials and Supply

33、Chain Production Supportability (System) Next generation iPhone launch and 2010 Holiday Retail Season readiness “Top Ten” Prioritization,SSC: AT&T Targeted Services: Transportation Manager,Key Secondary Activities Participate in scheduled project “Deep Dive” calls with PMO and project team Work with

34、 PMO/SSC to determine appropriate support model for New Horizons Work closely with OCS /PMO on project milestones develop relationships Continue to maintain Dev OTM Network Supply Chain Business develop key relationships Site visit to Warehouses SSC walk-thrus Key Deliverables Enhance Supply Chain S

35、SC presence and understand usage and architecture for OTM Site visit to understand implementation, document in configuration guide. Performance testing as requested. Amend SSC contract to include OTM products,SSC: Oracle E-Business Suite Release 12/Database 11g R2 Upgrade,Objective: System Availabil

36、ity, Supportability, and Software Currency Key Secondary Activities SSC “Top Ten” Prioritization: Service Request review meetings with Supply Chain, Financials, and DBA support teamsPatching/Release Management strategy for Release 12 interoperability; Leverage Tools and TemplatesDaily SSC Performanc

37、e Calls Key DeliverablesProactive Diagnostics (Configuration/Performance)Contracted deliverablesSemi-Annual Account Review,Service Highlights Focused Engineering Team of Oracle Subject Matter Experts Fast track solutions based on intimate Knowledge of customer Environment and business needs Proactiv

38、e Software Advice and Knowledge Transfers Performance and Patch Assessments Single point of contact for all technical issues - Technical Lead Single point of contact for all escalations SDM 24/7 coverage,Solution Support Center,Value Mitigate Upgrade Risks substantially All project milestones are me

39、t Ensured optimal usage of Oracle features and functionality Reduced overall Maintenance/upgrade/ training costs,Focused Engineering Team Single Point Accountability SDM Exclusive 1 800 number 24x7x365 Review of Critical Issues as Needed Patch Analysis,Stand-by Support for Critical Go-lives Proactiv

40、e Alerts / Patch Notifications Project Planning / Migration Assistance Periodic Review Sessions Applied Research,Key Delivered Features,Solution Support Center,Questions,For More Information,On this presentation, e-mail Bryon Rickey (BR) or Ravi Kayarthodi (RK).,For general information on Advanced Customer Services, go to or e-mailacsdirect_,