How to check different version in Oracle Apps R12

How to check different version in Oracle Apps R12

1) Database Version

SQL> desc v$version

 Name                                      Null?    Type

 —————————————– ——– —————————-

 BANNER                                             VARCHAR2(80)

SQL> select banner from v$version;

 BANNER

——————————————————————————–

Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production

PL/SQL Release 11.1.0.7.0 – Production

CORE    11.1.0.7.0      Production

TNS for Linux: Version 11.1.0.7.0 – Production

NLSRTL Version 11.1.0.7.0 – Production

2) Application Release.

SQL> select release_name from apps.fnd_product_groups;

 RELEASE_NAME

————————————————–

12.1.1

 3)  Web Server/Apache or Application Server in Apps 11i/R12

A. Log in as Application user, set environment variable and run below query

$IAS_ORACLE_HOME/Apache/Apache/bin/httpd –version

[appl201@prdcl201 bin]$ httpd -version

Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server

Server built:   Jul  7 2008 14:58:00

[appl201@prdcl201 bin]$ pwd

/patches/applprod/apps/tech_st/10.1.3/Apache/Apache/bin

4A)  Forms & Report version (aka developer 6i) in 11i
A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
output 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)
.
4B)  Forms & Report version in R12

A. Log in as Application user, set environment variable and run below query
$ORACLE_HOME/bin/rwrun | grep Release
Output should be like

[appl201@prdcl201 bin]$  rwrun | grep Release

REP-0503: You did not specify the name of a report.

Report Builder: Release 10.1.2.3.0 – Production on Tue Jul 19 10:36:21 2011

[appl201@prdcl201 bin]$ pwd

/patches/applprod/apps/tech_st/10.1.2/bin

5) OracleJinitiator in11i/R12/12i
A. Log in as Application user, set environment variable and run below query
[appl201@prdcl201 bin]$ grep jinit_ver_comma $CONTEXT_FILE

         <jinit_ver_comma oa_var=”s_jinit_ver_comma”>1.6.0_07</jinit_ver_comma>

6) RED HAT RELEASE

[appl201@prdcl201 bin]$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 5.4 (Tikanga)

7) JAVA PLUGIN

[appl201@prdcl201 bin]$ grep plugin $CONTEXT_FILE

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

8) APPLICATION SERVER VERSION

[appl201@prdcl201 12.0.0]$ cat $ORACLE_HOME/config/ias.properties | grep Version

Version=10.1.2.3.0

9) OC4J(Oracle Container for J2EE)

[appl201@prdcl201 home]$ java -jar oc4j.jar -version

Oracle Application Server Containers for J2EE 10g (10.1.2.3.0) (build 080228.2305.2133)

[appl201@prdcl201 home]$ pwd

/patches/applprod/apps/tech_st/10.1.2/j2ee/home