| |
Oracle Applications (Oracle E-Business Suite) Customizations: What is it?
By Roberto Artigas Faucz
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".
If you need
help, please give us a call: 1-866-528-0577, 1-630-961-5918,
help@albaspectrum.com
About the Author
Roberto
is technical consultant at Alba
Spectrum Technologies (
http://www.albaspectrum.com ) - Microsoft Business Solutions Great Plains,
Navision, Axapta, MS CRM, Oracle Financials and IBM Lotus Domino Partner,
serving corporate customers in the following industries: Aerospace & Defense,
Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance,
Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising &
Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates,
Apparels, Durables, Manufacturing and having locations in multiple states and
internationally.
We are
serving USA Nationwide: CA, IL, NY, FL, AZ, CO, TX, WI, WA, MI, MA, MO, LA, NM,
MN, Europe: Germany, France, Belgium, Poland, Russia, Middle East (Egypt, Saudi
Arabia, OAE, Bahrain), Asia: China, Australia, New Zealand, Oceania, South &
Central America: Mexico, Peru, Brazil, Venezuela, Colombia, Ecuador, Chili,
Paraguay, Uruguay, Argentina, Dominican Republic, Puerto Rico
Article Source: http://www.simplysearch4it.com/article/20281.html
| If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/20281.html" as shown above and make it hyperlinked. |
| Some other articles by Roberto Artigas Faucz | |
| |
