Oracle E-Business Suite Extensions Development

by : Andrew Karasev

Oracle Applications, Oracle Financials, Oracle E-Business Suite Extensions & Modifications

Concerning Oracle Applications there are two types of Customizations: Extensions and Modifications:

  • Extension is component developed by customization partner or customer IT group, 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.
  • Modification is the change 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.

Generic recommendation is – try to avoid modification and stay in the frame of extensions.

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.

Please do not hesitate to call or email us USA 1-866-528-0577, 1-630-961-5918, Brazil: +55-11-3444 4949, Mexico: 52-55-535-04027, Europe: +44 20 8123 2580, +45 36 96 55 20