R12 patching tables

Tables
ad_applied_patches
ad_bugs

select bug_number from ad_bugs where bug_number in ('&bug_number');

If this query returns at least one row, that means that the particular bug has been fixed or a patch of the same number was applied.

---

Details of specific patch that was applied:

col PATCH_NAME format a10
col PATCH_TYPE format a10
col DRIVER_FILE_NAME format a15
col PLATFORM format a10
select AP.PATCH_NAME, AP.PATCH_TYPE, AD.DRIVER_FILE_NAME, AD.CREATION_DATE,  AD.PLATFORM,AL.LANGUAGE
from AD_APPLIED_PATCHES AP, AD_PATCH_DRIVERS AD, AD_PATCH_DRIVER_LANGS AL
where AP.APPLIED_PATCH_ID = AD.APPLIED_PATCH_ID
and AD.PATCH_DRIVER_ID = AL.PATCH_DRIVER_ID
and AP.PATCH_NAME = '4502962';

select applied_patch_id, last_update_date
from ad_applied_patches
order by last_update_date; 

---

Run script $AD_TOP/sql/adutconf.sql. adutconf.lst will be generated where you can see actual patchlevels of each product.

---

Run patchset.sh utility. Explained in detail in note R11i / R12.0 / R12.1 / R12.2: Oracle Applications Current Patchset Comparison Utility - patchsets.sh (Doc ID 139684.1)

select * from AD_TRACKABLE_ENTITIES

Oracle Notes:
How To List Patches Applied In Pre-Install Mode? (Doc ID 1495138.1)
How To Verify Application Of Pre-install Patches As They Are Not Recorded In Tables AD_APPLIED_PATCHES Or AD_BUGS (Doc ID 1541054.1)

SELECT aat.applications_system_name DATABASE, aat.NAME Server, apps.patch_name, apps.patch_type,
DECODE (apps.rapid_installed_flag, NULL, ‘No’, ‘Yes’) Rapid_install,
apps.source_code, apd.driver_file_name, apr.patch_top,
apr.patch_action_options, apr.start_date, apr.end_date,
apd.platform, apr.server_type_node_flag NODE, apr.server_type_admin_flag ADMIN,
apr.server_type_forms_flag FORMS, apr.server_type_web_flag WEB
FROM applsys.ad_applied_patches apps,
applsys.ad_appl_tops aat,
applsys.ad_patch_drivers apd,
applsys.ad_patch_runs apr
WHERE apps.applied_patch_id = apd.applied_patch_id
AND apd.patch_driver_id = apr.patch_driver_id
AND apr.appl_top_id = aat.appl_top_id
AND TRUNC(apps.CREATION_DATE) > TRUNC(TO_DATE(’06/04/2006′, ‘DD/MM/YYYY’))
— AND patch_name LIKE ‘%3442800%’
ORDER BY apr.start_date ASC;

You might be interesting and about if specific bugs have been solved from which patches

SELECT apps.patch_name,q.patch_top
FROM applsys.ad_patch_run_bugs a,applsys.ad_bugs z,
applsys.ad_patch_runs q,applsys.ad_patch_drivers apd, applsys.ad_applied_patches apps
WHERE a.bug_id= z.bug_id
AND z.bug_number = ‘3442800’
AND q.patch_run_id = a.patch_run_id
AND apps.applied_patch_id = apd.applied_patch_id
AND apd.patch_driver_id = q.patch_driver_id;

Find the patch level

select a.application_name, decode(b.status,’I’,’Installed’,’S’,’Shared’,’N/A’) STATUS, PATCH_LEVEL
from APPS.fnd_application_vl a, APPS.fnd_product_installations b
where a.application_id = b.application_id
–and application_name like ‘Receivables%’