Oracle HTML DB

HTML DB uniquely converts an Oracle database into an online development service, which enables anyone with a Web browser to create reporting and data-entry applications quickly without the need for professional programming skills.

What Is Oracle HTML DB?

· It’s Browser driven.
· Provides rapid application development.
· It’s Wizard driven.
· You can quickly build web applications on the Oracle database for:
o Reporting
o Data entry
· Supported by Oracle 9.0.2.3 or later.
· Only needs Oracle HTTP Server.

Browser HTTP Server Oracle DB & HTML DB

HTML DB allows

You can create forms for:

· adding a record
· adding multiple records at a time
· updating a record
· deleting a record(s)
· viewing a record as read only

It allows you to setup triggers that execute when a particular action is committed by the user. For example, if a user clicks the delete button, some code will execute that will remove a product from the Oracle database, or write that record to another table, so that you have an audit trail.

Data is stored centrally and can be accessed by users from various locations. Users can be given privileges, where they can access only their own data. As an example following is a business scenario.

Business Scenario

Effective project management is the key to completing any project on time and within budget. Within every project there are always multiple issues that need to be tracked, prioritized, and dealt with.
For example there may be several projects that must be completed on time for Company A to be profitable. Missing deadlines for any of the projects will cause Company A to lose money. The project leads are tracking issues in several different ways. Some individuals are manually tracking issues in notebooks, others are tracking issues in text documents, and other managers are using spreadsheets.

By creating a hosted application in Oracle HTML DB, each project lead can easily record and track issues in one central location. Not only will everyone have access to just the data they need, but having the data stored in one location, will make it easier for management to determine if any critical issues are not being addressed.

Reports

Reports can be produced that allow users to filter report output. This allows the end user to set values that will be queried against to produce a report. These reports can be sorted by any heading on that report and can also be filtered down again. To produce these reports a developer needs to set the reports up and add the SQL queries or PL/SQL code to HTML DB.

Data can be imported from a spreadsheet into HTML DB and put into an Oracle database. All that is required is the database tables need to be setup first.

Reports can also be produced as pie charts, line charts, date reports (a calendar with text on specific dates where for example a support issue arose), bar charts and text output.

Author: Dal Hayer

Read more ...

ERP Software Suppliers

The ERP market has continued to grow over the last 10 years. While it was once only the domain of Fortune 1000 companies, Enterprise Resource Planning has now caught the attention of small to medium sized companies. The growth rate of Enterprise Resource Planning has reached over 30% since the end of the 1990s.

Because this tool has become so important for a large number of companies and organizations, it is important to understand the suppliers who make it available to them. The foundation for ERP technology was introduced in the early 1970s. An organization called SAP was created by engineers who had worked for IBM, and it became one of the largest ERP vendors in the world.

The software created by SAP is R/3, and it was created for the purpose of assisting companies with their logistics and accounting processes. In addition to this, SAP also offered a number of tools that dealt with human resources. Over time, SAP has extended its services to include supply chain maintenance and data warehousing solutions. The second most popular ERP software company was PeopleSoft. The area where this company became most prominent was human resources. It eventually placed an emphasis on tailoring its products to the service sector, and they wanted to help organizations deal with their costs and expenses. One reason why SAP and PeopleSoft had a great deal of success is because they extended their product line to suit the needs of a changing market.

There are a number of other suppliers that have made important contributions to the ERP industry. Some of these companies are J.D. Edwards and Oracle. Oracle has sold ERP tools since the late 1980s, and these tools were designed to work with their databases. Oracle has focused on selling their products to consumer goods firms and manufacturing companies. Because of this, they have become a formidable adversary to companies such as SAP. However, Oracle has had a number of problems over the years. Many of these problems are a result of reorganizing the structure of the company as well as the uncertainty of their newer products.

Another ERP supplier that has become quite popular is Baan. Baan is a company based in the Netherlands that sells ERP logistics tools to companies that wish to avoid doing business with SAP. They have spent a great deal of effort focusing on software suppliers that are relatively small. One of the most powerful advantages of this strategy is that a broader variety of products were introduced. The firm called J.D. Edwards is a company that has sold software for many years. However, they did not officially become a public company until the 1990s. When the launched the OneWorld ERP tool, they became a powerful force in the market, and they have earned billions of dollars in profits.

There are the four ERP vendors that have made a tremendous impact on the industry. However, it should be noted that there are a host of smaller companies. Because the largest vendors have placed an emphasis on working with Fortune 500 to Fortune 1000 companies, this has left open a market that was not tapped for many years. The smaller ERP vendors are catering their services to smaller businesses. Some of the companies which have done well in this area are Infinium Software, QAD, and PowerCerv. The software sold by these companies will require a great deal of customization if they are to be used properly.

However, they have assisted these smaller businesses by offering their products at a much lower cost. In addition to this, the software can be implemented within a short time frame.

Source: www.exforsys.com

Read more ...

Oracle Applications (Oracle E-business Suite) Customizations: What Is It?

Oracle Applications Customizations is a major issue in many companies that have implemented it. Oracle recommends every company that installs Oracle Applications to avoid any customization, but I have not seen any company that utilizes it and have not done any customization.

There are two types of Customizations: Extensions and Modifications.

• Extensions are components developed by customer, using the development features provided by Oracle within the E-business Suite. Oracle has provided guidelines and standards for creating extensions. It is extremely recommended that those are followed; it will certify that the new objects (extensions) are kept separate from standard E-business components.

• Modifications are changes done in the standard E-business suite objects or code. For example, a customer gets a database trigger from Oracle Applications database and makes some changes in the code. When customers follow this approach it is very difficult to identify the changes that have been done in the Oracle Applications, and this will affect future upgrades.

There are some common extensions on Oracle Applications Suite:

• Alert: Oracle Alerts facilitates the flow of information within a customer’s organization. Oracle workflow is used to develop new alerts.

• Database Objects: when the functionality is not available in Oracle Applications, it is possible to create a set of database objects. If the creation is necessary, it has to be done carefully, once it could impact the performance and the integrity of the system.

• File System and Custom Directory: always use the standard Oracle Flexible Architecture (OFA). This helps you to standardize installation and maintenance procedures. Create a new directory ($CUSTOM_TOP) and store all the customization in there.

• Forms: provides a way of populating custom tables. Oracle has provided a guideline for its implementation that must be followed. It has to be coded and tested properly; otherwise it can compromise the data integrity.

• Reports: Oracle provides the most usual reports and every company has to develop to their specific formats. Oracle Reports builder is the tool to be used and there are some risks in case of an upgrade, once that the schema of the objects used by Reports and Oracle eBusiness Suite can be changed in future releases.

Customization is a need at any company that has implemented Oracle Applications. Oracle is frequently advising everyone to avoid any kind customization. I agree in some part with Oracle, I would just change this advice to “Extend but not modify”.

Author: Andrew Karasev

Read more ...