Northern California OAUG Oracle Trading Community Architecture June, 2006

1. Northern California OAUGOracle Trading Community ArchitectureJune, 2006

2. Trading Community Architecture WHY EVOLUTION WHAT’S IN R12 SUMMARY

3. Trading Community ArchitectureWHY

4. To answer some questions Who are my Customers? Who are my Trading Partners? What have they purchased? What business have they done with us? What else can I sell to them? What more can we do with them? Who can I sell to next? How can we improve business with them?

5. Goals • For Customer information, bringing ERP and CRM to the same core architecture • Separating the entity that enters into a relationship from the business relationship itself • Allowing organizations and people to exist independently of their business relationship within a company • Sharing of party information across all of the ERP and CRM applications and reducing data redundancy • Providing complete view of a party and all of its relationships with you, and its relationships with other members of the trading community

7. Trading Community ArchitectureEVOLUTION

8. Evolution on a release scale 11iR7 11iR9 11iR10 11iR2 11iR3 11iR4 11iR6 WebServices SSM D&B Integration PartyMerge CPUI ODL (CDL) Bulk Import PublicAPIs ClassificationModel Auto-Merge DQM Address Validation Online Fuzzy Match BESCallouts CDH Employee Integration TCA Data Model OCO (CO) OCO (CO)

9. Steps of Evolution • Started with building a best in class customer data model • Introduced inbound and outbound interfaces to the data model – Public APIs (Java and PL/SQL), Bulk Import, Event-Subscription • Focused heavily on building data quality – Fuzzy Match, DQM, Merge, Data Librarian • Introduced third party integration e.g. with content provider DNB, with address services providers • Built comprehensive UI to view and maintain customer information – Customers Online. Provided UI components to application products for consistent exposure of customer information – Common Party UI

10. Steps of Evolution • Introduced system cross-referencing mechanism – Source System Management • Provided unlimited extensibility to the model, to capture information specific to your company or your industry • Built 360 degree transaction viewer, graphical relationship viewer • Built integration with HRMS, HealthCare, Student System, User Management, B2B Gateways • Worked with product teams to streamline application flows having touch point with customer information

11. CDM Areas of Responsibility Evolution in 11i EBS • Became central person and organization master for majority of applications in EBS Oracle E-Business Suite Application Families* CDM Sales Service Financials HR TCAEnabling Infrastructure Common Party UI, DQM, D&B Integration, APIs TCAData Model HZ Schema * This diagram depicts only a small subset of the application families that utilize TCA

12. Campaign to Compensation Business Flows • Campaign to Lead • Lead to Opportunity • Opportunity to Quote • Opportunity to Forecast • Quote to Order • Order to Invoice • Invoice to Cash • Cash to Compensation E-Business Suite Applications • Marketing Online • Telesales • Sales Online • Territory Manager • Quoting • Pricing • iStore • Order Management • Accounts Receivable • Credit Management • Incentive Compensation • Human Resources • Payroll • Marketing & Sales Intelligence

13. Service Request to Resolution Business Flows • Call to Resolution • Click to Resolution • Inbound Call to Depot Repair • Inbound Call to Dispatch • Dispatch to Resolution E-Business Suite Applications • Teleservice • Contact Center • Customer Care • iSupport • Field Service • Installed Base • Scheduling • Depot Repair

14. Contract to Renewal Business Flows • Contract Creation to Renewal • Contract Usage to Cash E-Business Suite Applications • Sales Contracts • Service Contracts • Accounts Receivable • Service Intelligence

15. Evolution in 11i EBS • Became central person and organization master for majority of applications in EBS Oracle E-Business Suite Application Families* Others HR CDM Sales Service Financials HR HR TCAEnabling Infrastructure Common Party UI, DQM, D&B Integration, APIs TCAData Model HZ Schema * This diagram depicts only a small subset of the application families that utilize TCA

16. Evolution in 11i EBS …But what about organizations that are in a heterogeneous applications environment? Epiphany Navision Siebel Retek SAP PeopleSoft Lawson Oracle

17. Epiphany Navision Siebel Retek SAP PeopleSoft Lawson Evolution of Customer Data Hub Extended the solution beyond Oracle e-Business Suite…Introduced Customer Data Hub • Central customer master data store • Data quality tools run in single instance for increased ROI • Platform for custom applications • Creates enterprise customer data ownership • Improved customer visibility • Real-time access to all data • 360 degree view of all transactions • Lower total cost of ownership • Simplified integration • Reduced maintenance costs

18. Trading Community ArchitectureWHAT’S IN R12(This is not a product announcement)

19. Integration Repository(Web Service Provider) Servicebeans/SDOs/Generate Functions Business Object Level APIs and Events Save Create Update Get Business Level APIs and Events Business Objects (DB Objects) Business Object Layer V2 API’s Entity Centric V2 Business Events Entity Centric Entity Centric V2 API’s and Events R12 – SOA Enabling TCA

20. R12 – Integration capabilities Release 11i Release 12 Integration based on TCA Entities Business Objects based integration  Low level entity access Business Object level access  Extensive Custom Coding No coding required  No middleware integration Out-of-the-box integration to Oracle SOA Suite  Integration Components Complete Integration Solution  Java & PL/SQL APIs Web Services 

21. R12 – Supplier Integration • Supplier organizations are in TCA • Terms of doing business with the supplier are in Purchasing / Payables • Supplier organization, address, contact, phone, email etc. are all in TCA • Employees are already in TCA, Payables using the same employee records in TCA • New supplier maintenance UI using TCA UI components

24. R12 – Shared Services Architecture • Oracle E-Business Suite introduces new Shared Services Architecture in R12 • TCA leverages the new architecture in providing easier maintenance of Account layer information that are operating unit sensitive • No more changing responsibility to access account information from different operating units

26. R12 - What’s in TCA Legal Entity & Intercompany Supplier Student, Faculty Customer Partner & End Customer Patient & Doctor Bank & Branch Contact & User Employee

27. Trading Community ArchitectureSUMMARY

28. The Guy from Australia

29. What you get from TCA • Prevent situation like the one we just watched! • Tools that deploying companies can use to model their customers as they see best for their business • Architecture that will grow with deploying companies’ requirements • Features to maintain extremely reliable customer information • Glue that ties several E-Business Suite flows in a seamless way • Customer Data Integration solution even if deploying company is not running a single E-Business Suite module • Platform that can play a key role in your IT landscape for Master Data Management

30. What you have to do • Take a close look at how you do business and how your business processes are most efficiently performed • Ask questions about how you should model customer information e.g. which entities should be modeled as parties, when should you create an account, should you create multiple accounts for some parties, should you create multiple billing sites for an account, should you create account relationships • Even if you are implementing few modules of E-Business Suite to start with, keep in mind the bigger picture about customer information

31. MetaLink Resource • Oracle Trading Community Architecture – Modeling Customer and Prospect Data : The document talks about answering a set of key questions about your prospect and customer data. This document offers guidance on the order in which these questions should be asked and on how to answer each question given your objectives and business processes. • Oracle Customer Data Hub Implementation Concepts and Strategies : The purpose of this document is to address the various considerations and decisions that come into play when implementing the Customer Data Hub, and to outline a concrete methodology for successfully implementing the CDH.