FIND Different Component Version In Oracle Applications 11i/R12   Leave a comment

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

—————

10.1.2.0.2

Advertisements

Posted October 7, 2013 by balaoracledba.com in 11i/R12, OracleAppsR12

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: