Friday, August 10, 2012

How to know version of Oracle Applications from backend

Printing Oracle Apps versions:

Use the below select statement to know the currently installed version of all your modules.

SELECT substr(a.application_short_name, 1, 5) code,
       substr(t.application_name, 1, 50) application_name,
       p.product_version version
FROM   fnd_application a,
       fnd_application_tl t,
       fnd_product_installations p
WHERE  a.application_id = p.application_id
AND    a.application_id = t.application_id
AND    t.language = USERENV('LANG');


Sample Output:

CODE   APPLICATION_NAME   VERSION
------------------------------------------------
AP       Payables                    12.1.0
PO       Purchasing                 12.1.0
AR       Receivables                12.1.0

No comments:

Post a Comment