How to find Components version & Patchset level in R12

Please Visit http://www.conacent.com/?page_id=218

Apache Version
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -v

You will see output like:

Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Dec 6 2005 14:59:13 (iAS 1.0.2.2.2 rollup 5)
Which means you are on iAS Version 1.0.2.2.2 with patchset rollup 5 with Apache Version 1.3.19

Server version: Oracle-Application-Server-10g/10.1.2.0.2 Oracle-HTTP-Server
Above is output If you have installed 10g Application Server with 11i


Jinitiator Version

11i
grep jinit_ver_name $OA_HTML/bin/appsweb_SID_HOSTNAME.cfg

R12
grep jinit_ver_name $OA_HTML/bin/appsweb.cfg

You will see output like:

jinit_ver_name=Version=1,3,1,23
which means Jinitiator version is 1.3.1.23 ;
if your version is 1.3.1.18 you will see entry like 1,3,1,18



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


Java Version
sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"


Jre version
cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version| cut -c 1-35


Forms Version
$ORACLE_HOME/bin/frmcmp_batch|grep Forms| grep Version



Plsql Version
$ORACLE_HOME/bin/frmcmp_batch|grep PL/SQL|grep Version


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"


Oracle Applications R12 Patchset level
As applmgr or environment owner
1. Source environment
2. login as apps
3. run $AD_TOP/sql/adutconf.sql


column BUG format a8;
 column PATCH format a60;
 set linesize 100;
 set pagesize 200;
 select b.bug_number BUG, b.LAST_UPDATE_DATE LDATE, decode(bug_number,
 4440000, 'Oracle Applications Release 12 Maintenance Pack',
 5082400, '12.0.1 Release Update Pack (RUP1)',
 5484000, '12.0.2 Release Update Pack (RUP2)',
 6141000, '12.0.3 Release Update Pack (RUP3)',
 6435000, '12.0.4 RELEASE UPDATE PACK (RUP4)',
 5907545, 'R12.ATG_PF.A.DELTA.1',
 5917344, 'R12.ATG_PF.A.DELTA.2',
 6077669, 'R12.ATG_PF.A.DELTA.3',
 6272680, 'R12.ATG_PF.A.DELTA.4',
 7237006, 'R12.ATG_PF.A.DELTA.6',
 8919491, 'R12.ATG_PF.B.delta.3',
 6728000, '12.0.6 RELEASE UPDATE PACK (RUP6)',
 9239089, 'R12.AD.B.delta.3',
 9114911, 'R12.HR_PF.B.delta.3',
 13418800, 'R12.HR_PF.B.delta.5',
 16000686, 'R12.HR_PF.B.delta.6',
 9239090, '12.1.3',
 9239089, 'R12.AD.B.delta.3',
 17884289, 'R12.AD.B.delta.4',
 19278976, 'R12.AD.B.DELTA.5',
 19277598, 'R12.ADO.B.DELTA.6',
 18004477, 'Release 12.1 HRMS RUP7 ',
 19429224, 'R12.OPM_PF.B.Delta.5 ',
 20363553, 'R12.OPM_PF.B.delta.6',
 18618946, 'R12.WMS.B.delta.9',
 19447782, 'R12.WMS.B.delta.10',
 7651091, 'R12.ATG_PF.B.delta.2',
 8502056, 'R12.AD.B.Delta.2',
 9245674, 'R12.SCM_PF.B.delta.3',
 20745242, 'R12.AD.C.delta.7',
 20784380, 'R12.TXK.C.DELTA.7 '
 ) PATCH
 from AD_BUGS b
 where b.BUG_NUMBER in ('4440000','5082400','5484000','6141000','6435000', '9239090', '9239089', '19278976', '19277598','8919491', '5907545','5917344','6077669','6272680','7237006','6728000', '9239089', '9114911','13418800', '18004477', '16000686', '19429224','18618946','7651091','8502056','19447782', '20363553', '17884289','9245674', '20745242', '20784380')
 order by patch;



http://www.oracle-base.com/dba/scripts.php