Oracle PSU/CPU Patching

Oracle patching can be an adventure (to say the least). One of the harder items I found was just where to get the appropriate patch to apply. I’m noting some places to look in Oracle support to find what is current

Database

Which Patch’s are available?
MOS notes about patches, patch sets, PSU, SRU and bundle patches :
NOTE:[756388.1] Introduction to Oracle Recommended Patches
This MOS notes is the main entry to the Oracle recommended patches. It includes further links to Oracle Database, Oracle Enterprise Manager, Oracle Fusion Middleware and other products.
NOTE:[756671.1] Oracle Recommended Patches — Oracle Database
This notes includes the links for the latest recommended patches of Oracle Databases on Unix and Linux since Oracle 10.2.0.3
NOTE:[161549.1] Oracle Database, Networking and Grid Agent Patches for Microsoft Platforms
As the name says, this note contains further links for recommended patches of Oracle Databases on Microsoft Windows
NOTE:[1454618.1] Quick Reference to Patch Numbers for Database PSU, SPU(CPU), Bundle Patches and Patchsets
This MOS note is some kind of a master note for any PSU, CPU, Bundle Patches and Patchset. Here you’ll find any patch number without struggling yourself first through all the Oracle recommendations – kicks to Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2)
NOTE:[742060.1] Release Schedule of Current Database Releases
On this MOS Note you do not really find any patch numbers or names but you’ll find the release schedules of upcoming patch set. Ok you do not see an exact date. But at least the quarter of the year.

NOTE:802103.1 – Oracle Recommended Patches — Previous Oracle Database Recommended Patches
NOTE:2584628.1 – JDK and PERL Patches for Oracle Database Home and Grid Home
NOTE:783141.1 – Reference List of Critical Patch Update Availability(CPU) and Patch Set Update (PSU) Documents For Oracle Database and Fusion Middleware Product
NOTE:1929745.1 – Oracle Recommended Patches — “Oracle JavaVM Component Database PSU and Update” (OJVM PSU and OJVM Update) Patches
NOTE:148054.1 – Oracle Database 8.1.7 (8i) & 8.1.7.x (8i) Notice 2 of 2
NOTE:1071023.1 – How to Request Software Media when it is Unavailable on the Oracle Software Delivery Cloud Site
NOTE:274526.1 – How To Download And Install The Latest OPatch(6880880) Version
NOTE:1963039.1 – Latest Patch Set Update and Critical Patch Update Availability Document
NOTE:1351428.1 – Information Center: Patching and Maintaining Oracle Database Server/Client Installations
NOTE:1581950.1 – Database Security Patching from 12.1.0.1 onwa

NOTE:(Doc ID 2484000.1) – Identifying the Latest Critical Patch Update for Oracle E-Business Suite Release 12

NOTE: (Doc ID 2118136.2) Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases
Looks like there is a base 19.?.0.0.0 (daabase updates) and rev1 19.?.1.0.0 rev2 19.?.2.0.0 (update revisions

EBS

Which Patch has been installed?
EBS patch set
Identifying the Latest Critical Patch Update for Oracle E-Business Suite Release 12 (Doc ID 2484000.1)
doc has reference to most recent cpu patch
starting with the July 2021 CPU, you can use the Secure Configuration Console to check your Oracle E-Business Suite CPU level. To do so, perform the following steps:

From the Functional Administrator responsibility in Oracle E-Business Suite, navigate to the Configuration Manager tab to open the Secure Configuration Console.

Find the security guideline “FND Min CPU patch level check” in the table, and expand the details for that guideline. The console displays the current Oracle E-Business Suite CPU level of your instance, in the format YYYY.MM. For example, a return value of "2021.07" denotes that the current CPU level is July 2021 CPU.

Additionally, starting with the October 2020 CPU, when applied each CPU registers an entry for itself in the AD_TRACKABLE_ENTITIES table. You can use the following SQL*Plus query to find the Oracle E-Business Suite CPU level of your instance:
col CPU format a9
select max(CODELEVEL) “CPU” from AD_TRACKABLE_ENTITIES where ABBREVIATION in (‘ebscpu’);
2020.10

The easiest way to list the installed patches in the current ORACLE_HOME is to use the patch utility.

List of installed patches:
$ORACLE_HOME/OPatch/opatch lsinventory

Grep on the patch description:
$ORACLE_HOME/OPatch/opatch lsinventory|grep “Patch description”
Patch description: “Database Patch Set Update : 11.2.0.3.7 (16619892)”

A more verbose list on the installed patches:
$ORACLE_HOME/OPatch/opatch lsinventory -details

Which Patch has been applied?

The table REGISTRY$HISTORY does contain information on applied patches respectively PSU, SRU or CPU. SinceSince I use this query regularly during the tests of the Critical Patch Update, I have it packed in a handy script ( cpui.sql).

set linesize 200 pagesize 200
col action_time for a28
col version for a10
col comments for a35
col action for a25
col namespace for a12
select * from registry$history;

Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)
Note: You should review this Document 1594274.1 on a regular basis, and install the latest recommended patches as soon as possible — ideally, within the quarter they are released. Applying these critical fixes to your Oracle E-Business Suite environment will help avoid security, functional and performance issues for which fixes are available.

The EBS Technology Codelevel Checker (ETCC) utility provides two scripts you can run to help ensure you have the necessary database and application tier bugfixes installed on your Oracle E-Business Suite Release 12.2 system. Oracle strongly recommends the use of this utility to ensure that all required database and application tier bugfixes have been installed.

ETCC can be downloaded via Patch 17537119 from My Oracle Support. ETCC maps missing bugfixes to the default corresponding patches and displays them in a patch recommendation summary. If your Oracle E-Business Suite 12.2 installation has additional patches installed as well as the recommended patches, you may need to install a merge patch from Oracle Support. As well as installation instructions and basic commands, the readme for this patch includes a number of usage scenarios and examples so should be carefully reviewed before running ETCC.

How to Prepare for and Find the Correct Critical Patch Update Patches for Oracle Fusion Middleware Products (Doc ID 551453.1)
Critical Patch Update (CPU) April 2022 Patch Advisor for Oracle Fusion Middleware (Doc ID 2806740.2)