SQL Query - Database and Application Info

Below are some of the queries that can be used to get the database and Application information.

>> Get Product Version

SELECT product
     , VERSION
     , status
FROM   product_component_version

>> Get Applications Version and Patch Information



SELECT   SUBSTR (a.application_name, 1, 60) Application_Name
       , SUBSTR (i.product_version, 1, 4) Version
       , i.patch_level
       , i.application_id
       , i.last_update_date
FROM     apps.fnd_product_installations i
       , apps.fnd_application_all_view a
WHERE    i.application_id = a.application_id
ORDER BY a.application_name

>> Patch Information
AD_APPLIED_PATCHES table stores information about all the patches installed in the system.

SELECT applied_patch_id
     , patch_name
     , patch_type
     , source_code
     , creation_date
     , last_update_date
FROM   ad_applied_patches

>> Multi-Org Setup
To check if the application is setup for Multi-Org

SELECT multi_org_flag
FROM   fnd_product_groups

PREVIOUS POST || NEXT POST