Thinking about going to IOE

Go to the IOE boom

In the past few years, the IOE craze has re-emerged, and this craze is more mature than before.With the development of domestic servers and data, the improvement of software development capabilities, and the mushrooming of various open source components, domestic enterprises have begun to truly embark on the road of IOE.

O in IOE

O refers to Oracle, more refers to Oracle database.

Oracle has many products, some of which are acquired.
1. Oracle database.
2. Enterprise software: mainly enterprise ERP software, including EBS, Peoplesoft, Sieble, etc.
3. Middleware: Oracle Application Server, Weblogic.
4. Java, Mysql and server hardware etc.

What is EBS?

This article talks about the O in IOE. The two largest ERP products in the world are SAP and EBS. In addition to providing databases, Oracle's more important product is EBS (E-Business Suit). How much revenue does Oracle contribute each year.There was a joke in the past, "If you don't go to EBS to court death, go to EBS and wait to die", because EBS was indeed a better choice at that time. It solved various businesses of manufacturing, distribution, and finance. At that time, it was on the ship of EBS.In addition to the large fees to be paid for the first implementation, the subsequent annual Oracle Support and License fees are a considerable expense.I think it was a good choice to go to EBS at that time, at least let the constantly expanding business flow and survive in the system, in order to find a new ERP outlet in the future.

Is EBS out?

The large-scale ERP has complete modular functions, supports various businesses of multiple companies in the group, and realizes the integration of financial business. It is still very popular in terms of functionality.

What can EBS do?

The ERP full-module commercial suite, of course, is charged by module and license.

1. Module diagram

2. Encyclopedia of application modules

An application module in the entire business suite is equivalent to a system.

What are the pain points of EBS now?

1. The amount of data in the database

Because EBS is a single instance of Oracle, the amount of single data is very large, especially for companies in the Internet industry, business data is stored in a single table, and SQL performance is worrying.

Oracle's solution:

If the data performance is not good, then use the Oracle Exadata all-in-one machine, but the cost is very high, but the ticket is naturally more expensive to change from the Oracle boat to the big boat.

Oracle Exadata ApplianceIntroduction to the machine_DBA implementer-CSDN blog_oracle one machine

Oracle Exadata Technology Analysis (ZT) - dbblog - Blog Park

2. Distributed scalability problems

EBS App is a centralized system

Remarks: Although EBS can deploy multiple nodes, it is only responsible for directing user traffic to different nodes. The real calculation is still orchestrated by the concurrent manager and handed over to an application for execution. Most of the business logic code runs in a single instance.package in the package.

Other aspects:

3. The front end is a web page developed by OAF or ADF, and the development cost is quite large.

4. Many of the front ends are Java Applet forms, which require users to install java jre and have certain requirements for browsers.The interface style is more traditional, but form validation and personalization are still awesome.

5. The technology stack includes PLSQL package, Oracle Form, Oracle Report, page OAF/ADF, workflow, etc.The development language and IDE are self-contained by oracle, so they will not have much intersection with the current mainstream vue, java, big data, etc.

Even Oracle's biggest rival, SAP, has gradually shifted to the Java platform from ECC5.0, not the original single ABAP language.

Why are so many companies inseparable from EBS?

1. Audit requirements

EBS has a very complete audit function, and the world-renowned consulting companies and audit companies are familiar with EBS and SAP.Especially for the audit of financial accounting, the different requirements of the US standard and the Chinese standard, the domestic ERP or the company's self-developed ERP system, the recognition degree is not so high.Especially the three major financial statements of EBS: balance sheet, income statement and cash flow statement.

2. R&D team

There are many business modules and many systems to be built. The company does not have the resources and ability to build them all.I bought the EBS kit, and the EBS implementation supplier provided solutions and training, and paid for the problem.

3. Collective multi-company needs

For global projects, the user interface is multilingual, and the business characteristics of various modules should be based on local characteristics to achieve financial business integration.

4. The needs of the manufacturing industry

Three categories: manufacturing, distribution, finance, and various modules in the financial category are very important for listed companies. The manufacturing category is more useful for the manufacturing industry. ENG, BOM, WIP, MRP and other modules help various manufacturing industries.provide the solution.EBS can achieve a set of standard procedures, output a solution through system configuration + personalized configuration + a small amount of customized development.

—————————————————
By Frank-Li