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 relies on the Oracle E-Business suite platform to support its business operations. The manufacturer has multiple Oracle EBS instances running on the unsupported version 220.127.116.11. As part of its long-term consolidation plan they 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.
- Significant amount of customization in 11i. There were numerous changes in the EBS 11i Finance and Sub-ledger Accounting modules and many older forms that needed to be moved into OAF.
- Technology challenges stemming from architecture changes
- Business testing
The objectives of the upgrade were to:
- Eliminate enterprise-level risk to the business due to the unsupported 11i version
- Make the integration and standardization process smoother for the future 11i to R12.2.5 upgrades.
- Support the long-term consolidation plan and efforts
11i to R12.2.5 Upgrade Approach
- Plan and scope the upgrade
- Perform upgrade patching and associated DBA activities
- Functional validation and delta setups
- Use ennABLE for custom object remediation and migration
- Manually remediate any objects that aren't automatically remediated by ennABLE
- Bug fix remediated objects impacted by the upgrade
- Validate and test RICE-W components
- Conduct CRP and support UAT
- Manage the entire code migration process with client technical team
- Migrate to Production
Pre-upgrade impact assessment
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)
Setup objects (Concurrent programs, custom profiles, form function, look ups, menu, request groups, request set, responsibilities, users, value sets)
RICEFW objects (Reports, forms, SQL scripts, shell scripts, alerts, control files, forms personalizations, OAF personalizations, workflows, custom.pll)
Total custom objects
Remediating and migrating custom objects
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 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 which 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 requirement.
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:
- Oracle E-Business Suite (18.104.22.168, R12.2.5)
- ennABLE automated remediation tool
- Oracle Forms 10g
- Oracle Reports 10g
- Putty & WinSCP
- SQL Developer/TOAD
- Workflow builder
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:
60% reduction in customization development time through automation.
Eliminated business risk with a validated Disaster Recovery plan that is available as expected around multiple business units.
A standardized enterprise application that supports the corporate vision and standardized technologies due to platform change.
Reduced the cost of steady state support by upgrading to the latest EBS version and better positioned to meet vendor support requirements.
Substantial User Interface (UI) and business improvements by replacing legacy customizations with new functionalities in EBS 12.2.5.