DreamPirates DreamPirates

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

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

1z0-1049 Exam questions 2021

1z0-1049 Exam questions 2021

- We have a special discount offer for our customers. So, what are you waiting for? Contact us and get 1z0-1049 Pdf at a less price


Apex Legends Switch Install Size Revealed

Apex Legends Switch Install Size Revealed

- Apex Legends players planning on getting the game on their Nintendo Switch now have an idea of just how much space they need to clear out.


Amazing Benefits of Rakhi Shopping Online

Amazing Benefits of Rakhi Shopping Online

- The festival of rakhi is nearly associated with the world-famous mythological tales. Most people celebrate Raksha Bandhan that usually


Car rental after an accident - The 6 most important points

Car rental after an accident - The 6 most important points

- Learn more about the rental car process after an accident. See who pays, how claims are handled through insurance, and many more.