Monday, December 13, 2010

Find Components version in R12 ?

Apache Version

$cd $IAS_ORACLE_HOME/Apache/Apache/bin
$httpd -version
o/p:
Server version: Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server
Server built:   Jul 16 2008 05:34:34

Forms Version

$ cd $ORACLE_HOME/bin
$ frmcmp_batch |grep Forms| grep Version
O/p:
Forms 10.1 (Form Compiler) Version 10.1.2.3.0

Forms Communication mode

cat $FORMS_WEB_CONFIG_FILE|grep serverURL=echo
If the serverURL parameter has no value then Forms is implemented in socket mode else it is servlet

Report version

$ORACLE_HOME/bin
$rwrun | grep Release
O/p:
Report Builder: Release 10.1.2.3.0

Perl Version

$IAS_ORACLE_HOME/perl/bin/perl -v|grep built

Apps Version

sql> select release_name from apps.fnd_product_groups;

Patch Level Version

sql > select PATCH_LEVEL from fnd_product_installations;

Patch Level Version of AD

sql > select PATCH_LEVEL from fnd_product_installations where PATCH_LEVEL like '%AD%';

o/p:

PATCH_LEVEL
------------------------------
R12.AD.B.1