Oracle EBS Upgrade from 12.1.3 To 12.2.11

Dear All,

We just completed upgrading our Oracle EBS 12.1.3 To 12.2.11.

I want to share my journey during the upgrade. Our methodology was upgrading the database from 11gR2 to 19c then move to EBS upgrade.

Following documents were followed to upgrade database:

1.     Oracle E-Business Suite Release 12.1 with Oracle Database 19c (Doc ID 2580629.1)

2.     Oracle 19c - Complete Checklist for Upgrading to Oracle Database 19c (19.x) using DBUA (Doc ID 2545064.1).

I completed database upgrade at beginning of 2022. Then moved to EBS.

We upgraded EBS on Production, after two upgrading trials on fresh clone instance from Production instance.

On first trial, I faced many issues, root cause for most of these issues was custom objects. So, in second trial, i exported custom tables and schemas, saved all packages, functions and procedures, views and mviews creation statements, dropped custom objects and schemas, upgrading EBS, and finally re-create schemas and custom objects. After that, we asked users to login and test a complete business cycle to solve any issue before moving to production.