Site Hub

1. Site Hub Lokesh Verma, Product Management Director

2. Safe Harbor The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

3. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

4. Pains and Use CasesSome examples … Can your trucks deliver your merchandise to your stores without being fined? Can you install new kitchen equipment in existing locations with the required power requirements? Are you putting your customers at risk by not knowing from which farm suppliers you get your produce?

5. As Companies Become Global……Managing sites becomes more difficult over time • Inconsistent Site Information • Site Information continuously Evolving • Bad Site Data Quality, difficult to keep under control • Inaccurate Site selection and market & product placement • Problems in identifying new revenue opportunities, minimizing contractual and financial risk in Real Estate Management • High Inventory and Logistics costs due to inaccurate localization strategies • Cost and Project Over-runs • Misdirected Service • Delays in site/store buildings/openings • Increased Data Quality and Integration cost

6. What Our Prospects are Saying • Site Information is ALWAYS in many disparate systems • Existing Store Master(s) are TYPICALLY custom • Old • Inflexible • “Integration and Flexibility” are larger issues than “Data Quality” • Lots of spreadsheets and rekeying across departments • Dates and Status MOST important (Construction, Leases, etc.)

7. The Oracle Site Hub EffectBusiness Benefits to the implementing Organizations • Consolidate/Federate Site information into one place • Cleanse/Enrich Site data centrally • Share Site data as a single point of truth as a service • Consolidated Complete Accurate 360° view of all sites supporting key decisions and business processes • Complete site lifecycle management from prospection, analysis, selection, administration, assets, logistics and facilities management • Site data administration and integration costs reductions • Increased agility and efficiency • Better Customer Service • Maintenance Costs Reduction

8. Target IndustriesOrganizations with many sites or locations • Retail • Corporate Real Estate • Telecommunications • Public Sector • Post Offices • Financials – Retail Banking • Hospitality • Utility Companies • Travel & Transportation

9. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

10. Data Governance Operational Systems Analytical Systems Analytical MDM Apps Operational MDM Apps Siebel DW Customer Supplier Product Financial Analytical BI &Datamarts EBS Site Planning SAP Oracle / Hyperion Data Relationship Management Oracle Customer Hub Oracle Product Hub Custom Apps Oracle Site Hub Financial Consolidation External Apps Budgeting Application Integration Architecture Oracle Fusion Middleware Oracle Master Data Management SolutionsThe most complete MDM solution in the market today

11. Leverage Users MasterTrusted Site Data Leveragefor Site Lifecycle Management Consolidatefrom Disparate Sources Share with Applications & Users Cleanseto Improve Accuracy EAM Planning EBS Master Site Data Property Share Consolidate SCM Procurement Project Custom Apps Other BI Cleanse Oracle Site Hub Solution

12. Oracle Site Hub Solution Master Consolidate Cleanse Govern Share Store Lifecycle Management • Sites • Locations • Trade Areas • Clusters • Hierarchies • Classification • Attributes • Related Data Entities • Aggregate data in a centralized data model • Manually / Bulk / Excel Load • High Volume Batch & Real time Integration • Geo-coding • Structured Search • Data Validation • Normalize, and enrich master data • DQM • Integration with • Google® Maps • EBS Appls • Data Profiling • Maintain history & audit trail • Security • As a single point of truth • 360o view of Sites • Web Services • Business Events

13. Site Selection Construction Management Store Procurement Lease Admin. Facilities Management Site Hub: Business Process FlowsThe Authoritative Source for all Sites Analytics Store Lifecycle Management Site Hub Master Site Records Centralized Data Storage Integration Services Data Quality Management* Merchandising, Supply Chain, Channels Merchandise Planning Warehouse Management Transportation CRM Merchandise Operations *Utilize OWB/ODI

14. What kinds of Information?Capturing site attributes of interest …

15. The Oracle Site Hub SolutionA competitive weapon for site driven business • Unique Sites Hub Product • Architecture based on Open Standards • Predefined, state-of-the art and flexible (over time) data model • Out-of-the-box configurable End User and Data Steward GUI • Web services, integration with Google Maps • Full spectrum of site lifecycle management functionalities: building & maintenance, leasing management, facilities management, Assets management • Out of box integration with 3 Oracle applications (Enterprise Asset Management, Inventory & Property Management) & with Oracle Trading Community Architecture

16. Inventory, EAM, & Property Manager Extensible Attributes Integration to Google® Maps Hierarchies & Clusters Excel Import-Export Trade Area Groups Site Comparisons Web Services Key Capabilities Site Attachments & Associations Site Search TCA Architecture Templates

17. Site SearchUtilize a parametric search using site attributes • Simple and Advanced Search • Easy search with site identification information • User defined searches on site attributes – No need for custom UIs

18. Extensible AttributesCreate & track unlimited number of site attributes

19. Google MapsUtilize Google Maps to visualize sites & site-related data

20. Site Hub: Leveraging Excel

21. Classify sites into Hierarchies & ClustersProvide relationship management between sites • Build hierarchical structure for sites • Sites may exist in multiple hierarchies • Group sites with one or more characteristics into clusters for driving business functions

22. Site Hub: Integration with Enterprise Asset Management

23. Site Hub: Integration with Property Manager

24. Assort sites into Trade Area GroupsAssociate related sites based on trading areas Trade Area Group with up to five (5) Trade Areas in Admin Role

25. Site ComparisonsCompare sites side-by-side

26. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

27. Site Hub Deployment Options • Option #1 – Site Hub and EBS are in One Global Instance • Option #2 – E-Business Suite as a Spoke to Site Hub • Option #3 – Site Hub only

28. Site Hub Deployment OptionsOption #1 – Site Hub and EBS are in One Global Instance Siebel MIDDLEWARE Oracle E-Business Suite with embedded Site Hub SAP Legacy External Apps R12.1

29. PROs and CONsOption #1 – Site Hub and EBS are in One Global Instance • PROs • Site Hub provides various integrations: • Integration with EAM, Property Manager and Inventory • Leverages Trading Community Architecture (CDH) • Future Site Hub integration with EBS applications • Single source of truth for the global database • CONs • Patches/Upgrades on EBS may impact Site Hub. • System must be sized accordingly to handle multiple work processes (paths)

30. Site Hub Deployment OptionsOption #2 – E-Business Suite as a Spoke to Site Hub Siebel MIDDLEWARE SAP Oracle Site Hub Legacy R12.1 External Apps R11.x or R12.0 or R12.1 Oracle E-Business Suite

31. PROs No constraints on Site Hub setup coming from the EBS implementation. Maximum freedom to define the master as needed. Allows implementing organizations to migrate to the single instance model at their own pace, while still taking advantage of a single source of site and customer reality. Patches/Upgrades on Site Hub will not impact on eBS, and vice versa. CONs The Site Hub setup is a separate/additional implementation. Additional integration development and maintenance is required. PROs and CONsOption #2 – E-Business Suite as a Spoke to Site Hub

32. Site Hub Deployment OptionsOption #3 – Site Hub Only Siebel MIDDLEWARE Oracle Site Hub SAP Legacy External Apps R12.1

33. PROs “Pure” site data management solution, which can be the basis for a new SOA compliant Enterprise Application Architecture Allows implementing organizations to begin realizing the value of E-Business Suite functionality, even before they have the E-Business Suite up and running Allows implementing organizations to plug in pieces of the E-Business Suite at their own pace, or keep legacy systems living on if migrating to the E-Business Suite is not an option Provides an easy migration path to single global instance vision CONs Spoke systems continue to live on Continued costs (IT and personnel) associated with maintaining disparate systems, with different technologies and platforms PROs and CONsOption #3 – Site Hub Only

34. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

35. How does Site Hub integrate with rest of EBS? What applications share/use the Site Data? How does it integrate with other Hubs (CDH/PIM)? Integration with 3rd party applications? I use a non-Google application for geo-coding and map viewing. How can I use it with Site Hub? I have a custom address validation tool. How do I use it in conjunction with Site Hub? Can I integrate Site Hub with Stellant / AutoVue? Frequently Asked Questions

36. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

37. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

38. A Large National Postal Services company is going through restructuring. The Govt. has decided to privatize the sector and this company needs to compete with the private vendors. Today, they provide mail delivery to private residents and by law, they are required to serve the complete private resident market. They also serve the mail delivery for corporate market, which may become optional in the future. They serve about 6 million homes in the country. In addition, they can deliver ‘junk’ or ‘advertisement’ mails to only those households who approve it. Mail is delivered via 277 distribution centers. Each distribution center typically handles about 50 routes. Each distribution center has about 15 to 20 mail delivery persons who handle 3 to 4 routes. A route typically covers one zip code, but can go across zip codes. A mail –man stops at about 200 mail stops (in a single route) and delivers mails to one or many mail boxes per mail stop. Today, the relation between mail box, mail stop, and route is the same for the whole week (or even months), but going forward, this co. would like the ability to define the routes differently based on the day of the week e.g. on Saturday, they would only like to serve fewer customer who pay a premium for it or they would like to serve the residential market only 3 days of the week. They also use a route optimization system that optimizes the routes every quarter. They would like to model the mail boxes/stops/routes in the system; they also want to model the residents in the system and create associations. These associations should change when a resident moves or goes on vacation. Case Study – Model

39. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

40. Posten Norge: Value Chain SH plays here Inbound logistics Outward sorting Transportation Inward Sorting Outbound transportation Sequencing Distribution • Letter and Parcel goods flow must be integrated, industrialized and precise. • Highly complex operation with daily collections at 35,000 locations and delivery to 1.9 million locations • Specified deadlines must be reached regardless of volume. Oracle Confidential – Internal use only

41. Posten Pareto Project • Scope • Complete register for Mailboxes, Stops and Routes within Norway • Map around 6 million sites, linking all mail recipients to them • Objectives • Optimize routes and postal delivery logistics • Reduce Postal Delivery Time/Costs • Reduce administrative costs and comply with regulations • Increasing efficiency and overall agility • Reduce IT Costs • Control and Improve Data Quality in a complex IT Environment Oracle Confidential – Internal use only

42. Posten Norge EntitiesMapping to Site Hub (and CDH) Oracle Confidential – Internal use only

43. Posten Norge Entities Customer Hub (CDH) N ... M 1 ... N Party Site N … M Address Mailbox Mail Recipient 1 ... N N ... M Route Stop N ... M Site Hub (SH) Room Room Room BP Oracle Confidential – Internal use only

44. Posten Norge Entities Routes and Stops modeling with hierarchies Route #1 Mail Recipient 1 MBX 1 S1 Mail Recipient 2 MBX 2 Breakpoint Mail Recipient 3 S2 S3 S4 Oracle Confidential – Internal use only

45. The Deal • Products: Customer Hub (CDH), Site Hub (SH) • Deal value: 1,525K USDDeal closed: Feb 2009 • Competitors: Custom Built Solution based on .Net • Why Oracle: • Trusted Provider and Advisor, and strong local relationship with Posten • Strong sales account management • Strong support provided both by Site Hub Development and by the EMEA MDM SC Team, plus local knowledge and resources from Oracle Consulting • Product completeness, flexibility and fit to Posten Requirements • Strong commitment from Development to partner with Posten on this project - SIP Oracle Confidential – Internal use only

46. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

47. What’s coming Next • Focus on Key Areas • Retail • Corporate Real Estate • Public Sector • Telco • Site Hub V2 • Partner Solution • Site Optimization • Site Selection & Market Planning

48. Site Hub V2 12.1.2 • Advanced Hierarchy Management with UDA support • Web 2.0 UI with drag and drop http://www-apps.us.oracle.com:1100/~jijiao/MyHierarchy/MyHierarchyUI.html# • Comprehensive set of Web services • Bulk Import Interface • Support for user entered geo codes • Automatic Site Numbering 12.1.3 • Roles Based Security • Date Effectivity for attributes/hierarchy • Integrated Workplace Management – Enhanced integration with projects, EAM, and Property Manager • Change Management / Workflow / Approvals • Integration with Document Management • DQM

49. Agenda • Day 1 • Business Issues, Site Hub Benefits and Target Industries • Functional Overview • Implementation / Integration Considerations • FAQ / Q & A • Demo • Case Study • Day 2 • Review Case • What’s coming next • Partner Update • Important Resources

50. Partner Update • Tango Management Consulting – • Based in US, formed by Bearing Point’s Real Estate Solution team • Recommended by our Retail Sales Reps • Co-development Partnership • Preferred Implementation Partnership • May partner with them for Site Selection and Market Planning Modules • Johnston & Mclamb • Site Optimization Solution on top of Site Hub http://analysis.johnstonmclamb.com/sitehub_training/#