Erp Project Oracle vs Asap

green light natural selection Planning (ERP) chore Students institute Registration number Course ap maculationee Table of Contents ABSTRACT3 INTRODUCTION5 VENDOR OVERVIEW8 INTRODUCTION8 run over8 vaticinator9 business line FUNCTIONS13 yield14 Sales14 Support serve15 External avail15 craft FUNCTIONS back up BY ORACLE AND mark16 TECHNOLOGY program FROM eject AND ORACLE19 COST analogy in the midst of wear d avouch AND ORACLE20 EASE OF USE22 ERP MODULES23 vaticinators Financial circumspection Analytics23 seer infobase 11g endeavor interlingual rendition24 VENDOR SELECTION27 ERP emergence LIFE hertz28 cooking stove AND COMMITMENT dress28 analytic thinking AND DESIGN29 ACQUISITION AND DEVELOPMENT STAGE30IMPLEMENTATION STAGE30 OPERATIONAL STAGE30 Biblio interprety31 ABSTRACT set-back step imagery planning (ERP) is a constitution that conflates either the internal and extraneous enjoymen dining table units of an face, the practicable units whitetho rn be manufacturing, pay, storage, precaution, hex, node ecstasy etcetera in piece to integrate alone the schemes answeral unit into a flaw little and proportionate clay, com caster softw argon submit been substantial by several(predicate) vendors, these softw be may be custom do for a particular arranging or they may be general for aim by both administration (Jerferson, 2010).ERP bodys atomic number 18 put in place to improve on the efficiency of knowl frame in circumspection of the organization, lendly the selective information from the contrary units of the organization be cutd by the softw ar administration and is unremarkably stored in a inter compound location c all(prenominal)ed a swear show upr, the horde may be physically located in the organization or it may be a rea rockic one on the internet, the virtual serve routines a engine room called asperse computation.The ERP scheme normally contains modules that be specialized su b- formations that ar task-oriented, these modules include human imaging, production planning, pecuniary planning, prize instruction, materials counsel, deals and distri plainlyion, importanttenance, controlling, asset precaution, purge prudence and industry solutions. The ERP packet program ar developed and sold by vendors down the stairs different aims, the highest level is the extensive go-ahead ERP level I which include vendors much(prenominal) as skim, prophesier and Microsoft, this level is for larger endeavours with complex communication protocols mingled with so m about(prenominal) puzzle outal units.The second level is the mid grocery store ERP tier II which include vendors much(prenominal)(prenominal)(prenominal) as Infor, QAD, Lawson, sage and IFS, these ERP softw be argon suit of c gagehesable for mediocre companies that have reasonable complexity in call of information attention. The last level is the subtile strain ERP tier III, vend ors of these ERP systems include Exact Globe, Syspro, Net rooms and Visibility, ERP bundle in this be satisfactory for small argumentationes with simple information attention systems (Jerferson, 2010).In this shake off, a detailed summary of a hypothetic universitys information forethought system is do, and then an ERP software lead be selected from one of the devil vendors, SAP or prophet. The selection provide be base on the steps of the ERP teaching invigoration cycle, the cycle leave behind occupy all the tired phases of an ERP information life cycle. The major activities of the university include pro ken of education, re look to activities and confederacy overhaul. The blend inal units of the university include the academics affairs, inance discussion section, module administration, medical examination operate, trade and public dealing, central store, catering, students salutary-being and tone assurance. The project allow sorb apart the softw are modules that are provided by vaticinator and SAP, a detailed investigation on the suit magnate of the deuce exit as vigorous be made, and then one of them result be selected for use as the universitys ERP system. This selection will be base on facts and will be as systematic as the ERP development cycle.INTRODUCTION on that bear witness are several(prenominal) ERP vendors in the military manwide market, each is fighting to be the possessive brand, and as a result, stiff competitor between the vendors is taking place. Each vendor is engineering better ERP software to pluck the nodes attention and suffer their ineluctably, virtually of the vendors are SAP, visionary, Microsoft, Lawson, sage and IFS. In this project, the deuce nigh dominant vendors in the market will be analyzed, these are SAP and vaticinator.The two vendors had a total market share of 55% between the year 2005 and 2009, and they have developed a wide range of products that are tailored to sui t several organizations, be it military, organisation or industrial (Jerferson, 2010). SAP and visionary are both in the large enterprise tier I category and they have mainly inventioned products to suit this segment of the market, however, nowadays they are underdeveloped ERP software for midmarket tier II. The project will take a hypothetical university as a case theater of operations, the university offers a assortment of courses and has a number of campuses distributed all everyplace the country.As part of the guidance policy, the university is divided into several departments that represent the task functions of a infer organization, the departments are- 1. Academics affairs This department deals with the plaza business of the university, which is provision of education, the department swots the timetables, assigns lecturers to the different units, manages the curriculum, manages the students results, ensures that all the university policies are adhered to and org anizes the tests and exams. 2. aboriginal storeIn this department, they receive anything that is supplied by the suppliers. The central store as well as invents requisitions for general materials such(prenominal) as stationery, cater uniforms, sanitary consumables etc. but they dont make avers for special materials that are specific to a certain department only such as machinery, info assistors, furniture etc. 3. pay This department deals with the concern and controlling of the universitys budgets, it alike deals with observe and focusing of the crop fees as well as the add together salaries and allowances.The department relies intemperately on computer software to ask out its function activities, all information is stored in a central server. 4. Students welfare The students wellbeing is taken care by this department, activities such as sports, festivals, parties, concerts are organized, monitored and financed by this department. 5. tender choice The recrui tment of in the raw members of stave, promotions and disciplinal procedure for misconduct of staff are all carried out by this department. The department similarly carries out teach programs for members of staff. . Catering This department manages the catering operate at the students and staff cafeterias, the department as well as makes orders for all the ingredients they need for preparing the food on the menu for the different days. The gross revenue from the cafeteria are non managed by the catering department, they are managed by the finance department. 7. Medical service The students and health needs are meet by this department, the staff in this department include doctors, nurses and pharmacists.They overcompensate any sick student or staff for free, but they use software to keep their info such as medical records, inventory and lab results. 8. domain relations This department deals with uplifting the universitys image, maintaining good relations with other(a) stake holders and promoting the university at different levels of the socioeconomic setup. 9. Other department Other smaller departments include quality assurance office, advertising department and repairs and maintenance, deportation and research institute. VENDOR OVERVIEW INTRODUCTION SAPSAP AG is a software confederation bear witness in Germany that makes enterprise software, the company was founded in June 1972 and was started by former IBM engineers, the company was ab initio called transcriptionanalyse und Programmentwicklung (System analysis and Program knowledge) but the get to was later changed to Systemanalyse und Programmentwicklung (System synopsis and Program Development), in 2005, the name was officially changed to SAP AG, SAP AG was include in the German stock index DAX in 1995 and was included in the Dow Jones STOXX 50 in 2003 (Lea rouge, 2013).Currently, SAP is the world leader in the sale of business and database software with a market share of 32%. Some of the main products of SAP are- CATEGORY tract NAME stemma Analytics ripe(p) planner And Optimizer Business Information Warehouse accession opening substitution Component Governance, take chances And Compliance Human resourcefulness vigilance Systems Knowledge Warehouse earnings exertion Server Catalog Content centering Hana proviso Chain achievement wariness planning And Event prudence Manufacturing scale information charge Service And rise to power guidanceIndustry Oil And boast Healthcare Telecommunication populace empyrean Utilities sell Small and midsize enterprises Business whiz Business ByDesign Other CCMS Sapgui eCATT Central fulfill Scheduling Solution theatre director ORACLE prophet is an Ameri evoke database and business management software company that was founded in 1977, its primary name was Software Development Laboratories, in 1979 the name was changed to Relational Software Incorporation, the name was changed again i n 1982 to vaticinator Systems conjunction and lastly it was renamed prophet Corporation in 1995 (Wikipedia, 2013).Oracle is ranked as the worlds third largest software maker afterwards Microsoft and IBM by revenue, however, it is ranked second in as an ERP software maker by market share after SAP. Oracle had a market share of 23% in ERP software between 2005 and 2009 plot of ground SAP had a staggering 32% market share. Some of Oracles products are listed on a lower floor CATEGORY piece of ground NAME employments Oracle E-Business Suite Enterprise transaction management Financial management Oracle fusion applications Oracle CRM on demand Customer relation management Hyperion JD Edwards world JD Edwards enterprise one Human enceinte management command data management Primavera Web commerce Sustainability procurement Project management Siebel Supply reach management Database Oracle database 11g enterprise form Oracle database 11g standard chance variable Oracle database 11g standard form one vigorous data guard Advanced certificate Airline data model Database credentials Express edition Label security department MySQL OLAP Oracle database doojigger Database vault NoSQL database sound backup Secure enterprise search Engineered systems Oracle big data whatchamacallum Oracle database appliance Oracle exadata database machine Oracle exalogic elastic cloud SPARC superCluster T4-4 lie ZFS storage appliance Enterprise management action management Application action management Application quality management Cloud management Database management computer hardware management Lifecycle management Middleware management Oracle enterprise manager 12c Java coffeeFX Oracle JDeveloper Java broadcast Micro edition Java weapons platform standard edition Oracle java SE entourage Netbeans IDE Oracle java SE brave Middleware Application grid Application server Collaboration doorway Linux Developer tools W eblogic Webcenter SOA Identity management Others Solaris Servers (hardware) Integrated management Sun calamus clients Virtual desk crimp infrastructure From the list, it fag be seen that Oracle makes more products than SAP, this may explain why their revenue is higher. BUSINESS FUNCTIONSBusiness functions are the routine tasks performed in order to achieve the goal of an organization. The watch beneath shows the business functions (LLC, 2002). These functions are similar for just almost all types of organization, but in some organization some functions are altogether omitted based on the products or services offered. The figure beneath shows the most usual business functions of any organization. A legal brief description of the business functions is given to a lower place Production look and development in this level, the organization develops bleak products and freshfangled designs for real products.Tests, experiments and survey are the characteristic activitie s of this phase, data collected from tests and experiments is stored, managed and utilized by the organizations decision makers Production and quality this is a major function and usually represents the biggest part of the organization in terms of human resource, at this level, the production is managed, plan and planned. Effective machine and staff invent is a very important scene in this function, the quality and production evaluate are controlled based on the data received from the sales and design team.Distribution and Logistics this function deals with the supply chain, it manages the raw materials and the final products. The activities that square off under this function include the coordination of storage of raw and finished products, management of transport and staff who directly deal with the supply chain. Sales Sales under this function, the human relationship between the organization and its client comes in, the sales team presents the products to the clients in a comfortable and persuasive manner, the team overly makes tenders, proposals, invoices etc. o the customers. The team similarly gives feedback to the research, development and selling teams on the status of customer satisfaction. merchandising the marketing department deals with promoting the products of the organization, marketing will involve managing the packaging, advertising, forecasting, budgeting, pricing and planning. Carrying out market research and survey is also a key role compete under this function Support services finance this is a key function in any organization, even for non-profitable organizations. wariness of cash and budgeting are the key activities in this function, the finance department records the incomes and expenditures of the organization and carries out coming(prenominal) planning in terms of increase the income and reducing the expenditure. figuring the use of computers has get under ones skin just about mandatory for any business, therefore, h aving computing make services is very important. In this category, the organizations database, net attain and software are effectively managed.Human resource it deals with recruitment of new members of staff, promotion of staff, formulation of contracts and telephone line descriptions for the staff, training of the staff and carrying out disciplinary tasks concerning the staff. Materials under this category, the requirements of the organization are set and then the potential suppliers are contacted, the bells are negotiated and the purchase orders are prepared. The staffs working in this area have to closely work with the production team as well as other teams in order to ensure that all teams in the organization have the necessary materials.External services hire accountants the accountants carry out audits to validate the companys accounts, they also give advice on matters relating to tax and other issues related to the monetary resource of the organization. trouble consult ants the consultants carry out surveys on the organizations policies, procedures, methods, governance and administration. hence they use the data from the surveys to recommend changes to the areas that have any flaws or require improvements.Recruitment sureness they carry out job interviews for recruitment purposes, they look for the necessary skills ask by the organization and recommend to the human resource department a list of thunder mugdidates who toilette high hat fit in the job. publicizing in most organizations, advertising is make by the marketing team, but in large organization, a separate impertinent body is charged with advertising the organizations products and services. The advertisers will propose to the management the best admittance to get an edge over the competitors.Market research this place also be through by the marketing department or by an external agency, surveys, data analysis, drawing conclusions from the analysis and formulating recommendations are the main tasks in market research. Public relations this has recently become a very important business function for more or less all organization, the public relations department uplifts and maintains the image of the organization, they answer to any inquiries made, carry out exhibitions, attend and organize conferences and also prepare press releases, brochures and newsletters.BUSINESS FUNCTIONS back up BY ORACLE AND SAP From the list of business functions and the list of packages of the two vendors, it is blue to see that the two vendors have packages for almost all the business functions, packages such as procurement, Human capital, JD Edwards world, Master data management, Database security, Database management etc. from oracle cover almost all the business functions. SAP also has packages that check business functions these packages included Supply Chain Performance Management, Human Resource Management Systems, Manufacturing, Business One, Central form Scheduling etc . the table beneath compares the two vendors in their ability to accompaniment business functions, BUSINESS FUNCTION back up SAP ORACLEResearch and development * Master Data Management * Central serve up Scheduling * Analytics * Solution Manager * Project management * Master data management, Advanced security * Active data guard * Application management * Database management * Collaboration * Identity management Production and quality * CCMS * Business One * Utilities * Manufacturing * Advanced Planner And Optimizer * Integrated management * ironware management * Lifecycle management * Application performance management * Oracle exalogic elastic cloud * Database security * Siebel Distribution and Logistics * Central Process Scheduling * Service And plus Management * Supply Chain Performance * Management * Catalog Content Management * Central Process Scheduling * Service And Asset Management * Supply Chain Performance * Management * Catalog Content Management Sales * Business B yDesign * Retail * Master Data Management * portal vein * profit Transaction Server * Business ByDesign * Retail * Master Data Management * Portal * Internet Transaction Server Marketing * Training And Event Management * Analytics * Application quality management * Project management * Enterprise performance management Finance * Enterprise Central Component * Internet Transaction Server * Master Data Management * Service And Asset Management * Business One * Business ByDesign * JD Edwards world * Financial management * Oracle E-Business Suite * Web commerce * MySQL * Oracle database appliance * Database vault * Database management Human resource * Human Resource Management Systems * Training And Event Management * Human capital management TECHNOLOGY PLATFORM FROM SAP AND ORACLE Technology platform refers to the ability to create or edit a software on an existing or future system, different ERP vendors have platforms that support their range of products and even their rivals product s, this assistances in allowing the customer to purchase a mixture of products from the alike(p) vendor or from two or more vendors. The table below shows the technology platforms of the two vendors SAP Oracle Sapgui * NetWeaver * Enterprise Workspaces * Cloud * SAP StreamWork * Mobility * Sybase Unwired Platform * Sybase Afaria * Project Gateway * Duet Enterprise * In-Memory Computing * Virtual desktop infrastructure * Developer tools * Linux * Portal * Application grid * Oracle java SE support * Netbeans IDE * Java platform standard edition * Java platform Micro edition * Oracle JDeveloper * javaFX * Application server * Collaboration The table below shows the technology platform of the two In terms of the operating systems they support and other platforms. SAP ORACLE * Windows * Open reference * Web Based * Linux WindowsLinuxUnix COST COMPARISON BETWEEN SAP AND ORACLEThe total speak to of implementing an ERP project is the total amount pay to put the system in place, it inv olve the purchase of the system, the constitute of implementing the changes required for the system to work and the salaries and wages of the personnel who work in the system. In term of the initial cost, SAP has a higher price than Oracle, SAP has maintained their high account rates because their focus is mainly on larger enterprises, so the price seems illogical for small and medium enterprises, and therefore, most customer rank SAP as the most expensive (Jerferson, 2010). However, SAP has the lowest median(a) cost overrun at about 8% over budget but Oracle had the highest cost overrun at about 15%, which is almost look-alike that of SAP.The payback period for SAP is 13 months small-arm that of Oracle stands at 11 months (Jerferson, 2010). According to a research conducted by Panorama consulting group, the project cost for the two vendors were as depicted on the graph below It end be seen that the two normally go beyond the evaluate budget (at 53. 6% SAP, 52. 6% Oracle) su ggesting that the budgeted cost for ERP projects are likely to be less than the actual budget by an bonnie of 53. 1% (Jerferson, 2010). The tables below were extracted from Nucleus Research and they were comparing the costs of SAP and Oracle (Jerferson, 2010). EASE OF USE The ease of use of an ERP system displace be compared by looking at the customers satisfaction after purchasing the software. 2% of SAPs customers were satisfied spot 74% of Oracles customer were satisfied, this indicates that Oracles software are easier to use than SAPs software but the margin between the two was very close (Jerferson, 2010). ERP MODULES The two modules were selected from Oracle, and they are Oracles Financial Management Analytics This module provides the top pecuniary management team with a good sagacity into the status of the financial department and the financial results, it offers a unified solution that can be deployed fastly and contains packaged dashboards and analytics tools that he lp give a quick acumen into the status of the financial system.This module supports the financial business function, finance involves a lot of staff and workload, and the staffs carry out routine tasks that can be repeated daily, weekly, semi-annually or annually. These records are often kept in files and this poses a huge challenge when the top management needs a quick insight or review into the results. Oracles Financial Management Analytics automates this system and maintains the records in a database system so that they can be accessed easily. The working convention of Analytics is depicted in the figure below (Oracle, 2012). The key features of Analytics are shown in the table below FEATURE DESCRIPTION executive View Gross increase By Region, Income By Region, Net Cash string up Process Management Metrics, inclination Analysis, general/Entity StatusFinancial Close history Summary Summary, Graphs, Milestones, Compensation Performance Indicators balances form On Year Com parison Table, Ratio Components, Ratio abbreviate Analysis profits And Loss Summary Income Statement, Variance Analysis, Trend Profit And Loss Gross Profit Variance Analysis, Gross Profit By Product, Trend Gross Profit residue Sheet Consolidating Balance Sheet, Metrics, Variance Analysis, Trend Balance Sheet Cash proceed Cash Flow Summary, Consolidation, Variance Analysis Current Analysis Variance Analysis This module supports the finance business function, this is a key function in any organization, even for non-profitable organizations.Management of funds and budgeting are the key activities in this function, the finance department records the incomes and expenditures of the organization and carries out future planning in terms of increasing the income and reducing the expenditure. Oracle database 11g enterprise edition Oracles database 11g enterprise edition is a database management software that is suitable for small and medium sized enterprises, this module manages all the data in the organization and enables all the business applications to benefit from the performance, reliability, security and scalability of Oracles database 11g enterprise edition (Wikipedia, 2013). Oracles database 11g enterprise edition supports all standard data types such as XML, Text, Documents, Images, Audio, film and Location data.Access to data is via standard interfaces such as SQL, JDBC, SQLJ, ODBC . NET, OLE . NET and ODP . NET, SQL/XML and Xquery, and WebDAV. It also has some analytical tools for modeling in SQL-based systems (Wikipedia, 2013). The figure below shows the working principle of Oracles database 11g enterprise edition. DATA lineage affect DATA memory board substance abuser drug user member DATA STORE PROCESS DATA STORE PROCESS DATA STORE USER USER PROCESS DATA STORE PROCESS This module support several business functions, for example it supports the sales, finance, logistics, human resource management, production etc. by keeping all the relevant data i n a secure and organized manner for favorable access and retrieval when need.The two selected modules can perfectly fit in the universitys operation. The university has a finance department which deals with the management and controlling of the universitys budgets, it also deals with monitoring and management of the school fees as well as the staff salaries and allowances. The department relies heavily on computer software to carry out its daily activities. Oracles Financial Management Analytics can be used to manage the finance department of the university. Oracles database 11g enterprise edition can be used to manage all the university data including the students results, past and present exams, e-books, financial records, hospital records, timetables etc. VENDOR SELECTIONThe preferred vendor is Oracle, this is because, they are cheaper compared to SAP, the payback period is shorter than that of SAP and their customers enjoy higher rates of satisfaction. In addition, Oracle has better customer services than SAP and has a wider range of products to need from than SAP. The domain of the organization under study did affect the choice, the university is a service provider and not a manufacturing organization, hence, some of the modules needed in the manufacturing domain may not be needed by the service providing university. The size also modify the choice of the vendor, the university can be considered as a big enterprise with branches (campuses) in different regions, thus a powerful tier I ERP system would be required to manage the university. A customized version ofERP will be the most appropriate for use in the university, this is because, the university is a unique enterprise with unique types of data management protocols, some data can be accessed by a few authorized users while other types of data should be unattached for every user, the levels of authority in the university are different from those in other service providing enterprises. Therefore, a great deal of customization will be required if a prosperous ERP system is to be enforced, this is nevertheless, an expensive weft since customized ERP system cost more and take longer to implement. ERP DEVELOPMENT LIFE CYCLE The ERP development life cycle can be summarized in a flow chart below (Motiwalla, 2010).SCOPE AND COMMITMENT STAGE This is the first spirit level of the cycle and it entails carrying out a feasibility study to jibe whether the ERP system will actually work and if it whole kit and caboodle (Motiwalla, 2010), will it benefit the university. In addition to this, the university will develop the scope of the performance based on the resources and time requirements. past the characteristics of the ERP death penalty are defined to determine what features should be included in the ERP and the customization it may need, the top managements cargo becomes very important at this degree and the short and long term vision for the new ERP system are formulated. Once this has been done, the suitable vendor is selected based on criterions such as price, reliability, payback period, customer support etc. The scope and commitments required at this stage include * Gap analysis an evaluation of the functions provided by the proposed ERP system is made and a comparison between the functions it can perform and the required functions is also made * Physical scope the number of users who will use the system, the location where the system will be implemented and the sites that will be addressed are considered at this point * BPR scope at this level, the users, department and sites affected are identified, the current processes are looked at to see if any changes will e required to implement the system * skilful scope evaluate the ERP system to establish if there are any modifications to be done on the system * Resource scope the time and money allocated to the project are determined at this point * Implementation scope the actual capital punishment is considered to determine which modules will be implemented and the link with the existing system ANALYSIS AND DESIGN At this stage, the ERP system is designed by the appointed teams, the user requirements are established, and the differences between the current business process and the ERP are identified and accommodated in the design (Motiwalla, 2010).Conversion of the data and the system is done at this point so that the new system is linked with the old one, a change in the management plan is also formulated to ensure successful implementation of the ERP system. Training of the staff on how to use the new system is also done at this stage. ACQUISITION AND DEVELOPMENT STAGE The software is purchased from the vendor and the license is give for as well, tasks identified in the chap analysis are executed at this stage, the changes in the management are also implemented to allow for the proper functionality of the new ERP, the old data is transferred to the new system and finally the security of the new system is configured. IMPLEMENTATION STAGE The purchased software is installed and implemented, the approach used in implementation can be one of the following * Phased * operate * Parallel * Big bangEach of these approaches has its pros and cons, but for our case, the best approach would either be phased or parallel because these two would give the staff and the students enough time to adapt to the new system. OPERATIONAL STAGE This is the final stage of the cycle, the project team officially pass on over the system to the university, the university will own the system and shall be responsible for managing new releases, installation of the patches and upgrades and renewal of contracts and licenses with the vendor. Bibliography Jerferson, D. (2010). Battle of the Titans SAP vs ORACLE. Denver Panorama Consulting Group. Leakey, J. (2013, February 21). SAP AG. Retrieved February 22, 2013, from Wikipedia http//en. wikipedia. org/wiki/SAP_AG LLC, A. P. (2002). Business Etiquette. London ILT. Mereddy, R. (2011).SAP basis Administration Handbook. unsanded Dehli McGraw-Hill. Motiwalla, L. F. (2010). Enterprise System for Management. New island of Jersey Pearson Education Incorporation. Oracle. (2012). Oracle Financial Management Analytics Data Sheet. California Oracle Press. Research, N. (2010). TCO study STUDY SAP VERSUS ORACLE JD EDWARDS. aluminium Nucleus REsearch Incorporation. SAP. (2013, February 19). SAP star sign Page. Retrieved February 22, 2013, from SAP http//www. sap. com/index. epx Wang, J. (2011). Oracle Database 11g. New York Oracle Press. Wikipedia. (2013, February 22). Oracle corporation. Retrieved February 22, 2013, from Wikipedia http//en. wikipedia. org/wiki/Oracle_Corporation