We are using oracle application 11i (11.5.5) and database 8.1.7 how to find out the patch level.
The patches already has been applied on database as well as application level.
is there any way to find out the patch level.Please let me know.
Thanks in advance ....
Please refer to the doc "Oracle Applications Current Patchsets Comparison Utility" in MetaLink
You can look at the v$version view inside the database.
Patchset level on 11i
Run the following query on your 11i instance:
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;
You can spool it to text and save it for multiple instances......
Hope this helps.
Excellent stuff, a reply to a 1.5 year old post. That a late Christmas present is it?