Query to find whether a product is installed/licensed or not.

Lists all products and their Installation Status

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
SELECT fat.application_name, 
       fa.application_id, 
       fpi.patch_level, 
       Decode(fpi.status, 'I', 'Licensed', 
                          'N', 'Not Licensed', 
                          'S', 'Shared', 
                          'Undetermined') STATUS 
FROM   fnd_product_installations fpi, 
       fnd_application fa, 
       fnd_application_tl fat 
WHERE  fpi.application_id = fa.application_id 
       AND fat.application_id = fa.application_id 
       AND fat.language = 'US'; 

Query to find the Short Name for a Particular Application

1
2
3
4
SELECT application_short_name, 
       application_id 
FROM   fnd_application_vl 
WHERE  application_name LIKE '%Payables%'

Query to find Installation Status of a Particular Product

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
SELECT fat.application_name, 
       fa.application_id, 
       fpi.patch_level, 
       Decode(fpi.status, 'I', 'Licensed', 
                          'N', 'Not Licensed', 
                          'S', 'Shared', 
                          'Undetermined') STATUS 
FROM   fnd_product_installations fpi, 
       fnd_application fa, 
       fnd_application_tl fat 
WHERE  fpi.application_id = fa.application_id 
       AND fat.application_id = fa.application_id 
       AND fa.application_short_name = 'ZX' 
          --Here ZX Represnts EBTax, Short Name for EBusiness Tax
       AND fat.language = 'US'; 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s