Patches

- AD_BUGS: holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation.

- AD_APPLIED_PATCHES: holds information about the "distinct" Oracle Applications patches that have been applied. If 2 patches happen to have the same name but are different in content (eg. "merged" patches), then they are considered distinct and this table will therefore hold 2 records.

- Patchsets.sh: This program (a unix shell script) was created to help customers evaluate the currently installed Oracle Applications patchsets and Family Packs. The program compares the currently installed patchsets and family packs to the most recently available ones generated by Oracle Development. This program utilizes the the applptch.txt file for 10.7-11.0. For 11i and R12, it utilizes a combination of tables such as AD_BUGS and AD_APPLIED_PATCHES to create the installed patch list. If the 11i release does not use these AD tables (11.5.4 or lower and have not applied 11i.AD.E or higher) it still supports using applptch.txt for 11i.

- adutconf.sql: This script provides a wealth of information, including the following:
Product Group(s)
Multi-Org status
Multi-lingual status
Installed product status
Registered schemas
Installed languages


1 - 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;

2 - SELECT patch_name, patch_type, maint_pack_level, creation_date
FROM applsys.ad_applied_patches
ORDER BY creation_date DESC


Query FND_PRODUCT_INSTALLATIONS table (PATCH_LEVEL) column, you should find what you are looking for.

You could also use patchsets.sh or $AD_TOP/sql/adutconf.sql script -- See (Note: 443699.1 - How to check if certain Oracle Applications product/module is implemented?) for details.