DreamPirates logo DreamPirates
general

Oracle Applications (Oracle E-Business Suite) Customizations: What is it?

- By Elizabeth Huston789
Publish Date : 2021-04-24 07:00:10
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.

o 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.

o 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:

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

 

https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=dd58148b-93ca-464a-a80c-88e08ce01079
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=1d7c573c-8118-4d73-9222-5471c79e8589
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=bf53054d-4d2f-4da9-ab34-6b3c7effc008
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=dbed4a0b-48a1-4651-8eb2-f2de183e9b6f
https://redzone.labette.edu/ICS/Campus_Life/Campus_Groups/Radiography_Club/Discussion.jnz?portlet=Forums&screen=PostView&screenType=change&id=b16edd38-9b3a-4811-a1a9-cbec0a5ae256

 

 

o 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.

o 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.

o 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.

o 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".

Andrew Karasev 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, PharmaceuticaOracle 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.

o 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.

o 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:

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

o 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.

o 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.

o 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.

o 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".

Andrew Karasev 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 Ricol, 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



Category : general

[2021] PeopleCert 102 Exam - Right Preparation Method

[2021] PeopleCert 102 Exam - Right Preparation Method

- PeopleCert 102 Dumps - Quick Tips To Pass Click Here & Success Now: https://www.passitcertify.com/peoplecert/102-questions.html


Get FSDEV PDF Dumps For FSDEV Exam Prep

Get FSDEV PDF Dumps For FSDEV Exam Prep

- Solutions for your career oriented certification. PDf, Practice test software. Get latest and Actual Exam Dumps For Best Results In Final Exam.


Harnessing The Buzz Surrounding Social Media For Your Business

Harnessing The Buzz Surrounding Social Media For Your Business

- harder to make a deal and convince someone you deserve a better price on a vehicle if you are draped in expensive clothing. While you want to appear neat and ct


Why A Grand Theft Auto Remaster Trilogy Makes Sense

Why A Grand Theft Auto Remaster Trilogy Makes Sense

- Rumors point to a remastered trilogy of the PS2-era Grand Theft Auto games, and heres why such a project would make sense for Rockstar.