How to find version in Oracle Apps 11i

-->To find apps version

select release_name from apps.fnd_product_groups;

If your are on11i then output will be like 11.5.10 or 11.5.10.2

-->To find Apache/Webserver version

login to web tier as owner of application(applmgr)

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version

-->To find a file version

adident Header <filename>

-->to find database version

sqlplus

connect / as sysdba

The top most line shows the oracle database version

-->to find forms version

f60gen

-->to find reports version

r60gen

-->to find workflow version

select text from WF_RESOURCES where name= ‘WF_VERSION’;

--To find OA Framework version

http://hostname:port/OA_HTML/OAInfo.jsp

or

adident Header $OA_HTML/OA.jsp

adident Header $FND_TOP/html/OA.jsp

Note:both versions from above command should be same

The following conversion chart can be used to identify the version

OA.jsp Version OA Framework Version

115.61 11.5.10.5RUP 5473858
115.60 11.5.10.4RUP 4676589
115.58 11.5.10.3RUP 4334965 / 5125546
115.56 5.10
115.36 5.7
115.27 5.6

--To find Jinitior version
$OA_HTML/bin/appsweb.cfg
locate the following line
jinit_ver_name=Version=1,3,1,18

--To find if the system is multi-org enabled

select multi_org_flag from fnd_product_groups

--To find if system is multilingual

select multi_lingual_flag from fnd_product_groups

--To find MRC is implemented or not

select multi_currency_flag from fnd_product_groups