IF you are an oracle apps consultant then you must be working on the oracle application, but do you know the exact version of the oracle applications you are using?
Following SQL query can be used to find out the exact version of the oracle applications you are currently working on.
SQL Query To Find The Oracle Apps Current Version:
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')
Most Useful Oracle Apps Articles:
- Types Of Tables In Oracle Applications
- Oracle Applications Technical Questions And Answers
- Oracle Apps AOL and Sysadmin Interview Questions And Answers
- Oracle Apps AR Module Interview Questions And Answers
- Oracle Financials Interview Questions And Answers
- Oracle Purchasing Interview Questions And Answers
- Oracle R12 Tables and Views Changes
- Purpose of MO_GLOBAL.SET_POLICY_CONTEXT
COMMENTS