Hi all,

In 11.5.2 how do we know what products have been patched and at what level are they ?

Thanx in advance..
Manjunath

You may try this.
select patch_level, application_name
from fnd_product_installations fpi
, fnd_application_tl fat
where patch_level is not null
and fpi.application_id = fat.application_id
order by application_name

A lot of patch information is available through Oracle Applications Manager.  Unfortunately, I don’t believe the bug database and OAM pacth advisor functionality was available for your release of the software (11.5.2).  You may need to mine the information you are looking for out of the text file that older releases used to track patches and bugs (this file will be imported into a bug database with an upgrade) Consider an upgrade

Regards,
Michael Siebert