Oracle Telecom Solutions for the 21st Century

1. Oracle Telecom Solutions for the 21st Century Robert Brown – Senior Director Telecom & Media

2. Oracle Telecom Solutions for the 21st Century • Oracle in Telecoms • Vision for the Industry • Industry Solutions • Number Portability Solution • Questions

3. Oracle in Telecommunications • Oracle has been supplying technology and applications to the Telecommunications industry since the mid-1980s • 85% of telecommunications companies worldwide use Oracle technology and/or applications • This represents a significant proposition of Oracle's core business; • Oracle has developed extensive experience and understanding of the needs of Telecommunications Operators • Through Deployment of: • Technology • Packaged Business Applications • Custom Development

4. Commitment and Success in Telecoms • Oracle “Goes-To-Market” by Industry • EMEA Telecommunications Group is core team of Industry and Solution Specialists • Regional Teams (e.g. Spain) lead engagement with Strategic Customers • EMEA Consulting (Professional Services) Practice dedicated to Telecommunications Industry • Oracle Applications Development support for Industry • Dedicated Team for Telecommunications • Drive Industry Analysis, Requirements Capture and Design • Supported by Customer Advisory Board • Solution Engineering Teams implement Industry Requirements • Industry Commitment • Customer Board for Telecommunications Business Processes • Membership of Industry Institutions - e.g. TMF • Executive Sponsorships – Development & EMEA

5. A few International Customers

6. Oracle Telecom Solutions for the 21st Century • Oracle in Telecoms • Vision for the Industry • Industry Solutions • Number Portability Solution • Questions

7. Standard Software Phase • Few large software vendors • Large footprint of application suites • Low TCO • Specialised Packages Phase • Niche Software vendors • Industry-specific applications • Heavy integration expenditure • Custom Development Phase • Custom built • Proprietary Software • Closed Interfaces Maturity Cycle in Software Maturity Time

8. NP Realise the benefits! Driving the Cycle in Telecoms OSS BSS Create the Build and Vision! Integrate! Database ERP Keep Complete the innovating! capabilities!

9. Oracle’s Telecoms Mission Statement • The BSS/OSS Applications Market • Oracle will actively foster the drive to maturity in BSS by continually increasing the scope of our suite of applications and delivering components to meet “best-of-breed” requirements • Oracle is also actively engaged in the evolution of the OSS into an open, modular, software-based stack • The Database Technology Market • Continue our leadership in TCO • Enable the lean real-time enterprise with database support for real-time BSS/OSS applications • Our goal is to become the leading supplier for technology and applications in Telecoms

10. BusinessManagement Established Apps Base Established Technology Base ServiceManagement Fostering maturity in BSS applications BSS OSS Driving an open, software-based OSS Network Management Network Elements PSTN Mobile Broadband Data Oracle’s Strategy for Telecoms ITU Levels of Telco Management

11. Oracle Telecom Solutions for the 21st Century • Oracle in Telecoms • Vision for the Industry • Industry Solutions • Number Portability Solution • Questions

12. Industry Solution Sets • Applications • Product Catalogue for Telecom • Customer Data Hub • Order to Fulfilment • Asset Management • Convergent Charging • Number Portability • Database • Service Delivery Platform • Customer Insight • Carrier Grade Framework

13. Oracle Telecom Solutions for the 21st Century • Oracle in Telecoms • Vision for the Industry • Industry Solutions • Number Portability Solution • Questions

14. Telco A NP Database Telco E ??? Telco C NP Database Telco D NP Database Number Portability - Option 1 De-centralised Bi-lateral Agreements Telco B NP Database No Standard Communication Protocols

15. Number Portability - Option 2 Centralised Reference Database Telco A NP Database Telco B NP Database CRD NP Database and Clearing House Telco C NP Database Telco D NP Database Standard Communications

16. Carrier B Donor “I want to join!” NRC “Is this num- ber portable?” “Is this num- ber portable?” “Yes!” “Yes!” Prepare porting Prepare porting NP Business Scenario Customer Porting Request Carrier A Recipient

17. Carrier B Donor NRC “Order to port” “Order to port” “Acknowledge” “Acknowledge” NP Business ScenarioPorting Order in Progress Carrier A Recipient

18. Institution A Carrier C Carrier D Carrier A Recipient Carrier B Donor “Notification” NRC “Port activation” Validation “Notification” “Notification” Activation Activation Record Notify/ProvisionInternal Systems NP Business ScenarioPorting Order Activation

19. Reference Database Reference Database Order Entry Administrative Interface Administrative Database Customer Care Oracle NP-SDP Administrative Database Network Management Administrative Interfaces Operational Database Operational Database Billing Network Interface System ... Exchange Exchange Number Portability Business Scenario- Affected Systems Oracles Focus Area Support the administrative part of Number Portability Used for Routing of calls

20. Oracle Number Portability Solution End to End Number Portability support

21. Administrative Process ProvisioningProcess Routing Process Oracle Number Portability SolutionSupport for the main processes Operator(s) NPAC CRM CRM Network Billing ... RoutingDB

22. Covered NP scenarios in Oracle NP • Mobile & Fixed numbers • Geographical number portability • Centralized and Decentralized process implementation • Can act as Operator & NPAC

23. Functionality Summary of the Oracle Number Portability Solution • Porting Order Engine • Open interfaces for capturing of incoming porting orders from multiple sources • Porting Process Engine • Tools to design, build, maintain and execute the porting processes in a graphical form • Communication Engine • UI tool to create and maintain the required incoming and outgoing messages including support for validation and verification of the content

24. Oracle NP Porting Order Portings Service Provider Number Range BusinessRules Out In XML Adapter(s) Operators, NPAC, Network.. Oracle NP – Process support Number Portability Order

25. Built on proven technologies Standard Technologies • Based on Oracle Data Base technology • The underlying technology provides a highly stable and performant application including support for clustering, fail over etc. • Based on Oracle Application foundation • The Application part adds a proven solution for handling of users, responsibility, roles and security. • Using standard– not propriety - technologies • Oracle DB • Java • XML • PL/SQL Insert diagram figure to support the text. Oracle Applications Oracle DB

26. Workflow driven execution of Porting Processes • Graphical Business Processes • The business logic (activation order etc) is mainly defined in the Service Fulfillment Manager as workflows. • The workflow consists of multiple parts: • One graphical design tool where the processes are build • One runtime engine where the processes are executed • One business flow monitor where the executed processes can be tracked • The execution rules can dynamically change during the fulfillment and the output from one step in a process can act as input in an other step. • The SFM workflow engine lets you create main and sub processes that can be reused in any different use case. • Oracle NP Workflows contains 100 NP specific nodes and functions that speeds up the implementation Insert diagram figure to support the text.

27. Service Providers Number Ranges Portings Complete Data Models for Number Portability • Service Provider • Number ranges assigned • Routing Number • Contact details • Number Ranges • Type of number range (fixed, mobile, ...) • Blocked numbers • Porting • Information about ongoing Porting • Information about historical Portings

28. Number Porting Overview • Business View • All portings can be tracked from a business view in order to respond to inquires about a porting (active or historical) • The information to be found here covers • Who is porting to who • Stratus of the porting including all date and time stamps • Network View • For each porting it is also possible to see the actication view of it; every call to an affected system is being stored including the status of the call (notify billing etc.) • Information to be found here covers. • The services ported (fax,data,sms) • Activation map showing which systems have been updated and when

29. Process tracking • Order Follow up is supported via the Graphical interfaces that provides full drill down access from order level until the lowest command level. The same GUI provides all information about the order such as all incoming data, all outgoing data, timestamps for each step. • In case of problems all notifcations/errors generated by the order can be found in one place. • During the execution of an order external systems can be notified about the status of the order at regular interval. • This screen is used by the back office team in order to track and resolve problems during a porting

30. Summary • Number portability will happen • The questions is how and what business/technical impact • The experience from Sweden (and other countries) can be learnt from • Oracle has a tried and trusted solution • We are committed to the industry from HLR/HSS through to GL • Oracle has the practical experience and knowledge • We will ensure a smooth, successful implementation with as little impact on existing systems as possible

31. Q & Q U E S T I O N S A N S W E R S A