ennVee helps a leading manufacturer eliminate enterprise risk and simplify consecutive Oracle EBS 11i to R12.2 upgrades.
A leading designer and manufacturer of complex metal components for the Aerospace industry rely on the Oracle E-Business suite platform to support its business operations. The manufacturer has multiple Oracle EBS instances running on the unsupported version 11.5.10.2. As part of its long-term consolidation plan, it must upgrade all instances to the same supported R12.2.5 version of Oracle EBS.
After bringing the corporate system up to 12.2.5 the company will be able to standardize on the enterprise level so the integration is smoother. The EBS upgrade would enable the company to replace various customizations and leverage the new functionalities available in R12.2, and improve the User Interface for application users.
The objectives of the upgrade were to:
Because the company's instance was heavily customized they wanted to understand how their level of customization would impact the upgrade. We used our ennABLE tool to automatically extract the custom object details from 11i and analyze the code to identify the changes in R12.2.5.
Once we knew the changes involved in each of the identified custom objects, we used the tool to group each object by type: Database, Setup, or RICEFW. There were a total of 3,122 custom objects (a breakdown is provided below):
Database objects (Custom tables, sequences, synonyms, triggers, functions, indexes, views, materialized views, packages, package body, procedures) |
1251 |
Setup objects (Concurrent programs, custom profiles, form function, look-ups, menu, request groups, request set, responsibilities, users, value sets) |
295 |
RICEFW objects (Reports, forms, SQL scripts, shell scripts, alerts, control files, forms personalizations, OAF personalizations, workflows, custom.pll) |
1576 |
Total custom objects |
3122 |
Next, we used the ennABLE tool to automatically remediate the impacted custom objects to suit the target R12.2.5 environment. Any objects that were out of scope from automated remediation were fixed manually (i.e. Workflows, OAF Forms, and Java Classes).
All remediated code was placed in the directory path provided by the company's IT team. (This path should be defined as a DB directory or UTL file path as the database should access it).
The DBA team migrated the remediated objects to the R12.2.5 instance with a specific mode (Test / Bin) respective to the object type.
We facilitated the first Conference Room Pilot (CRP) to demonstrate the new functionality. We also included the remediated objects from the DEV instance onwards to test and validate the end-to-end functionality in the CRP instance (wherein the customizations were built on Oracle Standard reports and were replaced with newer versions).
This phase also involved analyzing the customizations and new standard reports that came with newer, additional features. We embedded the customizations on the revised R12 versions to suit the client's requirements.
The DBAs performed a mock go-live as a part of the rehearsal activity for the final go-live/cutover.
The following tools and technologies were involved in the upgrade project:
We successfully upgraded the first EBS 11i instance which will pave the way for the company's remaining 11i upgrades. Given that the custom objects were remediated automatically, we significantly reduced the overall time-to-upgrade and amount of re-work during other testing phases. Additional benefits include:
|
|
|
|
|
|
|
|
Substantial User Interface (UI) and business improvements by replacing legacy customizations with new functionalities in EBS 12.2.5. |
Related
ennVee helps a consumer products company upgrade from Oracle EBS 11i to R12.2.6
4-6-week R12.2 upgrade customization impact assessment