11 October 2011

How to Check the Pach Level in Oracle Apps

This will be required for Oracle tar with Oracle corp. The following statement is mostly used by DBA

/* Formatted on 10/11/2011 5:46:09 PM (QP5 v5.163.1008.3004) */
  SELECT patch_level, application_name
    FROM fnd_product_installations a, fnd_application_tl b
   WHERE patch_level IS NOT NULL AND a.application_id = b.application_id
ORDER BY application_name;

Output:-

PATCH_LEVEL,APPLICATION_NAME
11i.MST.A, ????? ?????
11i.ABM.G.4,Activity Based Management
11i.BEN.O.2,Advanced Benefits
11i.IEC.R,Advanced Outbound Telephony
11i.QP.J,Advanced Pricing
11i.EGO.C,Advanced Product Catalog
11i.MSC.I,Advanced Supply Chain Planning
11i.ALR.G,Alert
11i.AZ.H.2,Application Implementation
11i.FND.H,Application Object Library
11i.RG.I,Application Report Generator
11i.BIS.L.6,Applications BIS
11i.AD.I.6,Applications DBA
11i.JA.I,Asia/Pacific Localizations
11i.FA.P,Assets
11i.VEA.J,Automotive
11i.BSC.H,Balanced Scorecard
11i.FPT.D,Banking Center

No comments: