A Brief History of Oracle

1. Oracle: An ERP ProductPresented by: Keshav Badruka Dipesh Patidar Himanshu Namdeo Jeetendra Ninor

2. A Brief History of Oracle • In June 1970, Dr E F Codd published a paper entitled A Relational Model of Data for Large Shared Data Banks. This relational model, sponsored by IBM, then came to be accepted as the definitive model for relational database management systems – RDBMS. The language developed by IBM to manipulate the data stored within Codd's model was originally called Structured English Query Language, or SEQUEL, with the word 'English' later being dropped in favor Structured Query Language – SQL. • In 1977 a company called Relational Software, Inc. released the first commercially available implementation of SQL. Relational Software later came to be known as Oracle Corporation.

3. Oracle - The Company • Founded in 1977 • 2nd largest software supplier in the world • Revenues over $8 billion in 1998 • 41,000 employees worldwide, 16,000 U.S. • Reflects total company - not just applications business • More than 6,000 customers in 76 countries • 1997 ERP market share was 8.3% of total ERP license revenue • 50% of applications revenue comes from services • Oracle’s applications license revenue is growing at 18% a year; significantly less than its rivals.

4. Oracle ERP • Oracle ERP is a suite of product, designed with the intention of processing transactions and sustaining the business stratigic goal through Hi tech applications and internet interface.Oracle ERP (Enterprise resource planning) can also be defined as a resource planning tool, which has an integral transaction processing system. The later versions of ORacle ERP are very function specific and have a lot more web interface products than the earlier products. You can find more infromation on the Oracle Website, and can also go thorough the free learning center Oracle has oppened up through it's Appsnet website. • Examples of Oracle ERP include Oracle Assets, General Ledger, Account Payable, Accounts Receivable, etc...

5. Oracle - The Product Fully Integrated, Global Application SUPPLY CHAINMANAGEMENT CUSTOMER RELATIONSHIP MANAGEMENT MANUFACTURING HUMAN RESOURCES FINANCE PROJECTS Finance WORKFLOW

6. Implemented Modules Of Oracle Apps CRM HRMS PROJECTS • Oracle Marketing • Oracle Sales • Oracle Services • Oracle Partner Relationship Management • Analytics • Core-HR • Payroll • Self-Service • Advanced Benefits • OTL • Ilearning (OTA) • Irecruitment • HR Intelligence • Daily business intelligence for projects • Billing • Collaboration • Contracts • Costing • Portfolio Analysis • Time and Labour • Project Resource Management FINANCIALS SCM MANUFACTURING • General ledger • Assets • Cash management • Payables / receivables • Financial analyzer • Enterprise planning & • budgeting • Inventory • Bill of materials • Work in progress • Engineering • Mrp • Cost • Procurement • Manufacturing • Order management • Product lifecycle management • Supply Chain Execution & Planning • Logistics

7. ERP Oracle - Features • Oracle Financials, USA. Runs on Oracle RDBMS. Java based. Non-specific Industry • Has multiple pre-configured solutions. • Applications are highly customizable due to their JAVA interfaces. • Highly scalable • may be used by large and small businesses. Licenses may be cost restrictive.

8. ERP Oracle Current Trend • The current Trend is ERP systems is the creation of WEB enabled system modules. • In the case of ERP systems, only one or two modules need to be fully WEB enabled to provide for System integration to the WEB. • These must be fully functional and secure.

9. ERP Oracle & Java • Java in the database allows developers to create high performing, scalable applications based on open, industry standards. Not J++ or any other product from Redmond. • Queries are generated in SQJL. • SQJL is an open standard being developed by Oracle, IBM, and Sun. (Surprised?) • communication via the CORBA

10. ERP Oracle & Web • WEB Interfaces are developed using Oracles WEBDb. • This is an HTML WEB Based GUI. Easy to use, etc., etc., etc...... (I’ll let you know). • Data retrieval is performed via Plain Language Standard Query Language (PL/SQL). • This is a very important feature for WEB applications.

11. Business Goals Of Oracle ERP Lower system costs Add strategic competitive business processes into applications Empower end users to be efficient in their jobs Make accurate and fast decisions

12. MANUFAC -TURING Oracle Apps Family ORACLE E-BUSINESS SUITE HUMAN RESOURCES CRM FINANCIALS SCM PROJECTS SELF-SERVICE BUSINESS INTELLIGENCE Oracle Web Employees LOCAL EXTENSIONS VERTICAL EXTENSIONS

13. Oracle E- Business Suite • Oracle E-Business Suite is the industry's only complete and integrated set of enterprise applications, working together seamlessly to streamline every area of your business—from sales, service, and marketing, through financials and human resources, to supply chain and manufacturing. Oracle E-Business Suite is your fastest path to high-quality enterprise intelligence, bringing your company a true 360-degree view of your finances, your customers, and your supply chains, so you can make faster, better decisions and grow profitability in a competitive marketplace.

14. Oracle E- Business Suite • Oracle E-Business Suite automates all parts of your business. From developing, marketing, selling, ordering, planning, procuring, manufacturing, fulfilling, servicing, and maintaining, to handling finance, human resources, and project management—Oracle E-Business Suite provides a comprehensive and integrated offering. • In the past, you had to choose between an integrated suite and “best of breed” for rich functionality. With Oracle, you can now have an integrated suite built on unified information architecture—with the functionality you need in each individual application. These applications connect business processes within and across departmental, geographical, and line-of-business domains. • Provides depth of product functionality and breadth of product offering.

15. Oracle E- Business Suite - Industry Applications Oracle E-Business Suite 11i.10 offers over 2,100 new capabilities, half of which meet specific industry needs, including: • Financial Services: SOP documentation and auditing for compliance with Sarbanes-Oxley and other regulations • Healthcare: Medication administration, patient encounter-specific financial information, integrated patient care and operational intelligence • Manufacturing/High Technology: Option-dependent sourcing, automated spare parts return and repair processing, international drop shipments, distribution planning

16. Oracle Applications Project Experience FINANCIAL MANUFACTURING • Large Manufacturing company In U.S, • Applied materials, U.S • Poly-Propylin Valves Manufacturing, India, Tiwan. • Large Cement manufacturing in U.K • Large Fin Svcs Company, UAE • Large Consulting Company, U.S • Project partners- California Bank in UAE PHARMACEUTICALS SERVICES • Tourism corporation in UK & Middle –East • Broad band services • Broadcast Media Company - UK • Large Pharma Company around 75 countries • Bulk drugs division • Research and Development centers, U.S, India, • Exports Division – U.S, Hong-Kong, Germany, Russia.

17. Case StudyImplementation in a Pharmaceuticals A large Pharmaceutical company with 8 FDA units and functions around 75 countries in the world has gone for implementation • MAJOR ACCOMPLISHMENTS • Use AIM Methodology • Customized self-service screens • Provided time card entry in self-service • Set up grades based on positions to rate performance reviews and awards • Set up advanced benefits to various categories of employees • Work-Flow Notifications • Using API’s uploaded all the employee details • ORACLE PRODUCTS • Human Resources 11.5.7 • Self Service HR • Oracle Advanced Benefits • Discoverer • Oracle 9i Database • Internet Developer Suite • BUSINESS DRIVERS • To implement Oracle Apps with all modules to make online function • To support the benefits enrollment of 5500 employees across 10 locations • Integrate 3rd party Payroll with Oracle Apps • To integrate Swipe card and Leave management system with SSHR • Secured Business group • ACHIEVEMENTS • Installation of Oracle Apps 11.5.7 version latest • Online work flow • Easy setup category wise • Implemented and make online in a span of 3 months with out any obligations

18. Oracle E-Business Suite Solution Develop Sell Plan HR Finance Projects Market Procure Service / Maintain Manufacture Fulfill • Architecture • Security • Admin & Mgmt • Configuration vs. Customization • High-Availability & Scalability • Business Intelligence • Performance & Benchmarks • Integration • Sizing • Portal

19. Oracle Apps Customers

20. Differences Between Oracle And SAP

21. Oracle’s Focus Through 2000 • Complete reorganization that began in spring of 1998 • Retraining of 2,000 sales people to focus solely on applications business • Multiple language support • Implementation of “Business OnLine” outsourcing and application hosting • Development of a dealer network for the midmarket • Improve relationships with systems integrators

22. Oracle’s Focus Through 2000 • Industry focus will be: – Telecom – Consumer packaged goods – Energy – Manufacturing • Expansion of technical architecture • Dominate the Asian market

23. Thanks