Get EBS Version and Module Patch Levels

-- ##############################################################################
--     GET CURRENT EBS RELEASE VERSION
-- ##############################################################################

SELECT * FROM apps.fnd_product_groups;

-- ##############################################################################
--       DATABASE VERSION
-- ##############################################################################

SELECT SUBSTR (release_name, 1, 7) version
     , SUBSTR (RPAD (multi_org_flag, 2, ' '), 1, 2) multi_org_flag
     , SUBSTR (RPAD (multi_currency_flag, 3, ' '), 1, 3) multi_currency_flag
  FROM apps.fnd_product_groups;

-- ##############################################################################
--       PATCHSET LEVEL FOR MODULES
-- ##############################################################################

  SELECT app_short_name
       , MAX (patch_level)
    FROM applsys.ad_patch_driver_minipks
   WHERE app_short_name = 'AR'
GROUP BY app_short_name
ORDER BY app_short_name;

  SELECT *
    FROM applsys.ad_patch_driver_minipks
   WHERE app_short_name = 'SQLAP'
ORDER BY app_short_name
       , creation_date DESC; 

-- ##############################################################################
--         PRODUCT PATCH LEVEL 
-- ##############################################################################

  SELECT fa.application_short_name app
       , fat.application_name
       , fat.creation_date
       , fat.description
       , fpi.creation_date
       , fpi.product_version
       , fpi.status
       , fpi.patch_level
    FROM applsys.fnd_product_installations fpi
    JOIN applsys.fnd_application_tl fat ON fpi.application_id = fat.application_id 
    JOIN applsys.fnd_application fa     ON fa.application_id =  fat.application_id
   WHERE 1 = 1
     AND fa.application_short_name = 'CE'
--     AND fat.application_name = 'Projects'
ORDER BY 1;

-- applications / modules list and whether they are installed

SELECT  fa.application_id
     ,  fa.application_short_name
     ,  fa.creation_date
     ,  fa.basepath
     ,  fpi.patch_level
     ,  fa.product_code
     ,  fat.application_name
     ,  DECODE(fpi.status,'I','Licensed','S','Shared','N','Not Licensed') status
  FROM  applsys.fnd_application fa
  JOIN  applsys.fnd_application_tl fat        ON fa.application_id = fat.application_id
  JOIN  applsys.fnd_product_installations fpi ON fa.application_id = fpi.application_id
ORDER BY fat.application_name;

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*