Find out the patch level of any product you have installed in e-Business Suite by running the following query via SQL

Find out the patch level of any product you have installed in e-Business Suite by running the following query via SQL:

$ sqlplus apps /

SQL> SELECT substr(APPLICATION_SHORT_NAME,1,8) product,
substr(PRODUCT_VERSION,1,14) version,
substr(PATCH_LEVEL,1,11) patch_level,
FROM fnd_application a, fnd_product_installations p
WHERE a.application_id = p.application_id
ORDER BY application_short_name
/

If you know the product code, you can obtain output for individual products with the following SQL:

SQL> SELECT patch_level
FROM fnd_product_installations
WHERE patch_level LIKE ''
/
for example: WHERE patch_level LIKE 'BIS'

As a double check that the database knows that the product is installed, you can run the following query. It should produce the same answer:

SQL> SELECT fa.application_id id, fa.application_short_name app, fa.application_name, fpi.status,
fpi.patch_level
FROM fnd_application_all_view fa, fnd_product_installations fpi
WHERE fa.application_id = fpi.application_id
AND fpi.patch_level LIKE ''
/