NuRe COMIT – Custom Objects Upgrade tool for E-Business Suite

March 30, 2023

NuRe COMIT – Custom Objects Upgrade tool for E-Business Suite

Post Views: 444

Upgrade of Oracle E-Business Suite R12.1.X to R12.2.X

Customer’s businesses are faced with technology refresh every 3-5 years with the pace of changes and the needs of business outcomes that needs to be accomplished. Each such cycle mandates need for upgrades in case customer uses out of the box ERP software like E-Business Suite (“EBS”).

Executive Summary:

This blog discusses the challenges involved in upgrading from R12.1.X to R12.2.X and introduces a tool that can automate the identification and retrofitting of custom components. The tool consists of two components, EBS_CUSTOM_DISC and CUSTOM_RETROFIT, which generate the source code of custom components and identify schema references in the respective custom components. The tool creates a repository of custom components and their source code, and generates a ZIP file of the source code. The utilization of the tool can significantly reduce the manual effort required for the upgrade, improving delivery timelines and minimizing resources.

Challenges:

The following are the challenges during the upgrade from R12.1.X to R12.2.X

Identification of custom components
Repository of custom components
Manual retrofit of the custom components
Based on the volume of custom components the manual effort and time is dependant.

As part of Oracle upgrade tool, the standard patching will take care of the compliances of the standard modules and components, however for the custom components need to be examined and searched for the schema references, component wise. To replace the schema references from the custom program units, this consumes considerable amount of time and effort.

Key Advantages

Can run on the same Unix/Linux Oracle Application server
Identify the custom components
Creates a repository of custom components list
Creates a repository of the custom components source code
Creates a ZIP file of the custom components source code
search for the schema references and automatically retrofits the code units

Execution flow:

The tool has two components

EBS_CUSTOM_DISC this script generates the source code of the custom components.
CUSTOM_RETROFIT This script identifies the schema references in any of the custom components and automatically replaces the reference and make a comment of the replacement.

Execution Steps:

Provide the nomenclature/naming convention of the custom components and modify the EBS_CUSTOM_DISC script accordingly, including the custom top.
Create a directory on the application server and provide the required permissions.
EBS_CUSTOM_DISC – script creates two folders one with custom components source code and other with zip file having custom components source code.
Execute CUSTOM_RETROFIT, this script scans the custom components source code for schema references and retrofits along with comment and a Log file will be generated to identify the schema references.

The utilization of the tool has significant impact on the time and resource which will improve delivery timelines and minimize the manual efforts.

Sample Screen shots of the Output:

Sample screenshots of the tool output, visualizing the list of files generated and the component types included in the tool.

The below sample screen shot shows the list of component types included in the tool.

The business benefits of EBS_CUSTOM_DISC and CUSTOM_RETROFIT scripts are as follows:

EBS_CUSTOM_DISC script generates the source code of the custom components, which helps in identifying and creating a repository of the custom components. The benefits of this script are:
- It saves time and effort by automating the generation of the source code of custom components.
- It ensures consistency and accuracy by creating a centralized repository of custom components.
- It provides a better understanding on the volume and type of custom components, which helps in managing and maintenance.
- It improves the resource utilization
CUSTOM_RETROFIT script identifies the schema references in any of the custom components and automatically replaces the reference and makes a comment of the replacement. The benefits of this script are:
- It saves time and effort by automating the identification and replacement of schema references in custom components.
- It ensures compliance of replacing the schema references in accordance with the Oracle upgrade patching.
- It minimizes the risk of errors by providing a detailed log file of the replacements made.

Overall, these scripts help in streamlining the upgrade process, reducing manual effort, and improving the accuracy and consistency of custom components.