How to find out if a product is installed in e-Business Suite?

Goal
How to find out if a product is installed in e-Business Suite?

Solution

E-Business Suite 11i users can find out what products are installed in e-Business Suite, and their patch levels, via Oracle Applications Manager. See the note reference at the end of this note for details.

A list of the installed products may also be obtained by running the script $AD_TOP/sql/adutconf.sql, or by querying the file $APPL_TOP/admin/applprod.txt. These methods are documented in the notes referenced below.

Users can find out the patch level of any installed e-BS product 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 the product code is known, the following query may be run for individual products:

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

The product code is the 2- or 3-letter code you see when you search for a patch in Metalink by product family, and in the name of the patchset, e.g. 11i.BIS.L.

As a double check that the database knows that the product is installed, the following query 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 ''
/

Bear in mind that it is possible to have most e-Business Suite products installed without applying a patch, because they are shipped with our base rapidinstall releases of e-Business Suite.

Remember too that having a product installed is one thing, being licensed to use it is another. You need to ask your Oracle Account Manager if you are licensed to use a product. Oracle Product Support does not hold customer licensing information