Oracle Apps File Version

This Post helps you to find out versions of different components in 11i/R12:
How to find Apps Version (11i/R12/12i)?
Log in as Application user, source the environment and run below query:
sqlplus apps/<password>
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
————————————————–
12.1.3
How to find Web Server/Apache or Application Server in Apps 11i/R12?
Log in as Application user, source the environment and run below query:
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Output for 11i should be like:
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5)
Output for R12 should be like:
Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server
Server built: Jul 21 2009 11:12:22
How to find Forms & Report version (aka developer 6i) in 11i ?
Log in as Application user, source the environment and run below query:
sqlplus apps/<password>
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
Output should be like:
Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production)
Check fourth character in version 25 which means Forms 6i patchset 16 (25-9)
How to find Forms & Report version in R12/12i?
Log in as Application user, source the environment and run below query:
$ORACLE_HOME/bin/rwrun | grep Release
Output should be like:
Report Builder: Release 10.1.2.2.0
You can safely ignore warnings
How to find Database Version in 11i/R12/12i?
Log in as Application user, source the environment and run below query:
SQL> select * from v$version;
Output should be like:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Prod
PL/SQL Release 10.2.0.3.0 – Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 – Production
NLSRTL Version 10.2.0.3.0 – Production
How to find Oracle Jinitiator version in 11i/R12/12i?
Log in as Application user, set environment file under $ APPL_TOP and run below query from current directory:
grep jinit $CONTEXT_FILE
Output for 11i should be like:
<jinit_ver_comma oa_var=”s_jinit_ver_comma”>1,3,1,21</jinit_ver_comma>
Output for R12 should be like:
<jinit_ver_comma oa_var=”s_jinit_ver_comma”>1.6.0_07</jinit_ver_comma>
How to find Oracle Java Plug-in version in 11i/R12/12i?
Log in as Application user, source the environment file under $ APPL_TOP and run below query from current directory:
grep plugin $CONTEXT_FILE
Output for 11i should be like:
<!– JDK plugins –>
<sun_plugin_ver oa_var=”s_sun_plugin_ver”>1.4.2_04</sun_plugin_ver>
<sun_plugin_type oa_var=”s_sun_plugin_type”>jinit</sun_plugin_type>
Output for R12 should be like:
<!– JDK plugins –>
<sun_plugin_ver oa_var=”s_sun_plugin_ver”>1.6.0_07</sun_plugin_ver>
<sun_plugin_type oa_var=”s_sun_plugin_type”>jdk</sun_plugin_type>
How to find File Version on file system?
Goto the location of file.
adident Header <filename>
or
strings <file_name> | grep Header
Here adident is AD Utility (Oracle Apps) and strings is Unix utility.
Example:
cd $AU_TOP/forms/US
adident Header GMDFMHSM.fmb
GMDFMHSM.fmb:
$Header GMDFMHSM.fmb 115.23 2003/05/12 11:59 jbaird ship
strings GMDFMHSM.fmb | grep Header
FDRCSID(‘$Header: GMDFMHSM.fmb 115.23 2003/05/12 11:59 jbaird ship
How to find Version of pld file?
*.pld are source code of *.pll which are inturn source of *.plx. *.pll is in $AU_TOP/resource and to find its version check.
adident Header $AU_TOP/resource/<filename>.pll
or
strings $AU_TOP/resource/<filename>.pll | grep -i header
Output should be like:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship
How to find OA Framework Version ?
http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i)
Log in as Application user, set environment variable and run below query
adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp
Output should be like:
$Header OA.jsp 115.60 2006/03/31 00:47:28 atgops1 noship $
120.21 means OA Framework Version
115.60 means OA Framework Version
115.56 means OA Framework Version
115.36 means OA Framework Version 5.7
115.27 means OA Framework Version 5.6E
115.26 means OA Framework Version 5.5.2E
How to find Discoverer Version for 11i (3i or 4i)?
Log in as Application user, set environment variable and run below query:
$ORACLE_HOME/bin/disc4ws | grep -i Version
How to find Workflow Version with Apps?
Connect to Database as apps user:
SQL> select text ,name from wf_resources
where name like ‘%WF_VERSION%’;
Output should be like:
TEXT           NAME
———————-
2.6.0  WF_VERSION
How to find portal version with Apps
Connect to database as sysdba
sqlplus “/as sysdba”
SQL> select version from portal.WWC_VERSION$;
Output should be like:
Version
—————