Find component Version in Apps 11i/R12/12i

SQL> select release_name from apps.fnd_product_groups;

A. Connect to database as user apps

Output like 12.0.4 or 11.5.10.2

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

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.0.0Oracle-HTTP-Server

Server built:   Dec  4 2006 14:44:38

Q. 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)

.

Q. Forms & Report version in R12/12i

A. Log in as Application user, set environment variable 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.

Q. Database Version in 11i/R12/12i

A. Go to database section below.

Q. Oracle Jinitiator in 11i/R12/12i

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

grep jinit_ver_comma $CONTEXT_FILE

Q. Oracle Java Plug-in in 11i/R12/12i

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

grep plugin $CONTEXT_FILE.

Q. File Version on file system

adident Header

or

strings | grep Header

Here adident is AD Utility (Oracle Apps) and strings is Unix utility.

Q. Workflow Version with Apps

A. Connect to Database as apps user

SQL> select TEXT Version from   WF_RESOURCES where  NAME = ‘WF_VERSION’;

Output like 2.6.0 means workflow version 2.6.0  Version for Fusion Middleware Component

Q.To find database version

SQL> select * from v$version;

Q.To find OS version

Solaris -> cat /etc/release

Red Hat Linux -> cat /etc/redhat-release