You can find the details in the upgrade guide: (Section: Oracle Database Releases That Support Direct Upgrade)
You can perform a direct upgrade to the new release from the following releases:
The path that you must take to upgrade to the latest Oracle Database release depends on the release number of your current database. If your current Oracle Database is a release earlier than 220.127.116.11, then you cannot directly upgrade your Oracle Database to the latest release. In this case, you are required to upgrade to an intermediate release before upgrading to Oracle Database 19c
18.104.22.168 is still the highest version supported with EBS R12, and only 10.1.0.5 supports direct upgrade.
Oracle Database Online Documentation Library, 12c Release 1 (22.214.171.124)
Database Upgrade Guide
Oracle Database Releases That Support Direct Upgrade
Yes. Missed your EBS part in the question.
The latest DB version supported for EBS is 126.96.36.199. Follow the EBS 188.8.131.52 Database document:
Interoperability Notes Oracle EBS 12.2 with Oracle Database 12c Release 1 (Doc ID 1926201.1)
Check the upgrade section for more details.
Thanks Michael and Vishnu,
We have also EBS 12.1.3 with database 184.108.40.206.
We want to upgrade it to EBS 12.2.9 with database 220.127.116.11.
So we need to apply patch 18.104.22.168 to 22.214.171.124 first? Is it a simple single run patch?
You have a direct upgrade path from 126.96.36.199 to 188.8.131.52 so that you can directly reach highest supported db version.
This will be an out of place upgrade and your action plan should ideally be -
1. Upgrade your ebs r12.1.3 database first from 184.108.40.206 to 220.127.116.11
--Interoperability Notes EBS 12.0 or 12.1 with RDBMS 12cR1 (Doc ID 1524398.1)
2. Upgrade your ebs r12.1.3 to 12.2.9
Oracle E-Business Suite Release 12.2.9 Readme (Doc ID 2495027.1)
Thanks Maaz and ALL,
Just to confirm if my understanding is correct, no need for us to upgrade our database (18.104.22.168) to 22.214.171.124
As it is supported to be directly upgraded to 126.96.36.199?
Because I also saw docs that says it must be on 188.8.131.52 first
Yes it is supported. Below is reference for you -
I have upgraded ebs r12.1.3 database from 184.108.40.206 to 220.127.116.11 directly and it went smooth.
It says at least 18.104.22.168 as starting from 22.214.171.124 we have EBR - Edition based Redefinition Feature that is a mandatory feature for 12.2 adop.
I've just raised a question with Oracle as we're on EBS 12.1.3/RDBMS 11.2 and don't fancy having to upgrade to 126.96.36.199 only for it to lose patch support in July 2021 and having then to upgrade the database again (as our usage means any upgrade requires a comprehensive round of testing that is time/cost heavy).
Basically we'd like to go straight to 19c (a.k.a 188.8.131.52) and roll all this up alongside an upgrade to EBS 12.1.9 by December 2020, to avoid 3 x intrusive upgrades of EBS/RDBMS - so any indication of 19c certification with EBS is strategically important to our planning. Looking at the changes (we only use Payroll and a subset of HR) the only real monster looks to be online patching so I don't believe we're being too ambitious.
Personally I think if we forge ahead with 184.108.40.206, I don't think upgrading "in flight" to 19c once certified will be too disruptive but welcome any comments. To save covering old ground, this discussion looked ideally suited to add my question so hopefully I've evolved the debate rather than hijacked it
I may choose the simplest way first of the upgrade.
Here's confirmation 19c is now certified with EBS 12.1 & 12.2...
Phew - makes our life easier in terms of planning our upgrades