Finding Patch Level of a Product in Oracle Application
If we need to find the latest patch level for a particular product then we can use the below query.
Syntax:
select patch_level
from fnd_product_installations where patch_level like upper('%&product_name%')
Output:
PATCH_LEVEL
------------------------------
11i.AD.I.7
Syntax:
select patch_level
from fnd_product_installations where patch_level like upper('%&product_name%')
Output:
PATCH_LEVEL
------------------------------
11i.AD.I.7
Subscribe to:
Post Comments
(
Atom
)
Very good, I think I found the knowledge I needed.
ReplyDelete