How to find Oracle Application version/name and their module details?
FND_PRODUCT_INSTALLATIONS
This fnd_product_installations table stores information about Oracle Applications products at your site.
Each row includes-
A value identifying the application (APPLICATION_ID)
A value identifying the database account (ORACLE_ID)
The product's version number (PRODUCT_VERSION)
The product's status at your site (STATUS, where I means installed, L means custom, N means not installed, and S means installed as shared product)
The product's industry (INDUSTRY, where C means for commercial or for-profit use, G means for educational or not-for-profit use, B means Project Billing, and P means Project Costing)
And some other columns like patch level of each application and tablespace etc
Oracle Applications uses this information to display product version numbers when you choose \ Help Version, when installing and upgrading your database, and for other purposes.
select * from apps.fnd_product_installations ;
--realated module specific and its patch level details,application module version etc.
select * from apps.fnd_product_groups ;
-- Oracle Application Version details(like 11.5.10 or 12.0.1)e.g.release name,application short name,application system name(fdev1,fsit1 like tht)
v$version
By running this query, you will able to derive which database enterprise edition, their platform and 32/64 bit etc details.
select * from v$version;
