[Oracle EBS] 2. Patch Information

Find apply the patch & Mini Patch: Select patch_name, patch_type
From ad_applied_patches
Order by creation_date

-----------------------
2644657 one-off
2641718 one-off

Select app_short_name, max (patch_level) as patch_level
From applsys. ad_patch_driver_minipks
Group by app_short_name;

----------------------
Ad 11i. Ad. I .2
Ar 11i. ar. o
Ax 11i. Ax. j

Find the details of apply patch (R12 is queried here, And application_short_name becomes lower case): Select B. patch_name, G. orig_bug_number, E. bug_number, F. Name machine,
A. patch_top, G. application_short_name app, G. applied_flag,
Min (A. start_date), max (A. end_date), B. patch_type,
B. maint_pack_level
From applsys. ad_patch_runs,
Applsys. ad_applied_patches B,
Applsys. ad_patch_drivers C,
Applsys. ad_comprising_patches D,
Applsys. ad_bugs e,
Applsys. ad_appl_tops F,
Applsys. ad_patch_run_bugs g
Where a. patch_driver_id = C. patch_driver_id
And B. applied_patch_id = C. applied_patch_id
And D. patch_driver_id (+) = A. patch_driver_id
And E. bug_id (+) = D. bug_id
And F. appl_top_id (+) = A. appl_top_id
And G. patch_run_id (+) = A. patch_run_id
And a. creation_date> =
To_date ('2017-01-01 ', 'yyyy-MM-DD ')
And G. applied_flag (+) = 'y'
Group by B. patch_name,
B. patch_type,
B. maint_pack_level,
F. Name,
A. patch_top,
E. bug_number,
G. application_short_name,
G. applied_flag,
G. orig_bug_number
Order by min (A. start_date)

 
----------------------------------------------------
4502962 4502962 testsererer/D1/R12/AB/apps/prodxb19comn/autobuild/patch/4502962 ad y 13:58:45 14:21:12 patch-Set
4440000 4440000 testsererer/D1/R12/AB/apps/prodxb19comn/autobuild/patch/4440000 au y 15:02:03 14:21:09 maintenance-pack 12.0.0
5436860 5436860 testsererer/D1/R12/AB/apps/prodxb19comn/autobuild/patch/5436860 FND y 2007-1-4 21:45:38 2007-1-4 21:46:23 one-off

Obtain Patch Level: Select patch_level from fnd_product_installations.

--------------------------------------------------
11i. qrm.
11i. Pon. h
11i. okl. d
11i. IBC.

If you want to know the specific patch level, you need to use the patchset Comparison Utility tool provided by Oracle,
Ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh
But this stuff is not running fast!

Patch history database tables list:
Ad_appl_tops stores information about all appl_tops utilizing this instance.
Ad_applied_patches stores information about all distinct updates applied.
If there are two patches with the same name but different content, two records will appear. For example, merge patch or multi-node.
Ad_bugs stores information about all distinct bug fixes applied.
Ad_drivers stores information about the drivers that comprise an update.
Some driver information, including several drivers, such as cxxxxx, dxxxxx, gxxxxx, or uxxxxx.
Ad_file_versions stores version information for files.
Ad_files stores information about files in the system.
Ad_patch_common_actions stores information about actions in update driver files.
Ad_patch_driver_langs stores information about the specified ages encoded in an update driver file.
Ad_patch_driver_minipks stores information about mini-packs.
Ad_patch_run_bug_actions stores detailed information about actions applied by an update.
Ad_patch_run_bugs stores information about all bug fixes pinned in an update, applied or not. records the information applied at the time, but for a bug.
Ad_patch_runs stores information about all invocations of autopatch for all of the varous updates applied. records the information of the apply driver at the time, such as the position, start, and end time, which corresponds to the number of drivers.
Ad_releases stores release information about the Oracle Applications system.