find version in 11i/R12

How to find version in 11i/R12

-->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



No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...