Apps DBA Concepts

Just another WordPress.com weblog

Archive for January 31st, 2008

How to find an AD patchset level ?

Posted by vasselva on January 31, 2008

SQL> select PATCH_LEVEL from fnd_product_installations where APPLICATION_ID=50;

PATCH_LEVEL
——————————
11i.AD.I

This query works for both 11i and R12 instance

Posted in General | Leave a Comment »