CRITICAL PATCH UPDATE CHECKER (ECPUC) (Patch): has error
CRITICALPATCH UPDATE CHECKER (ECPUC) (Patch): p35583866_R12_GENERIC
for EBS 12.2 has error in ECPUC.sql
The first line in the query is:
SELECT '37237361:12.2.0' PATCH_TO_APPLY from ad_trackable_entities where upper(abbreviation) = '' and codelevel = '' and ad_patch.is_patch_applied('12.2.0',-1,'37237361') = 'NOT_APPLIED'
It should select from dual, see older versions of this script.
I also always have to put commas in CODELEVEL line in my environment.
and CODELEVEL > '&ebs_cpu_checker_level';
Just wanted to share this, don't know how to report this errror to Oracle