The following process will give you the answers for the most of the components in R12
1. Login to as applmgr
2. cd $FND_TOP/patch/115/bin
perl TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=
This step will create a techstack_info.html file under $OA_HTML directory
3. You can access the techstack_info.html using from the browser using
http(s)://servername.domain:port/OA_HTML/techstack_info.html
The output looks similar to the following
TXK Technology Inventory Report for EBS Release 12
Report Header
Date Tue Aug 19 10:50:42 2008
Hostname lxs3er06.solutions.glbsnet.com
Enabled Services Root Service, Web Entry Point Services, Web Application Services, Batch Processing Services
Instance R12VIS_lxs3er06
Platform LINUX 32-bit
Tier APPS
OS release 2.6.9-67.ELsmp
DB Host lxs3er06.solutions.glbsnet.com
Context File /data/R12VIS/inst/apps/R12VIS_lxs3er06/appl/admin/R12VIS_lxs3er06.xml (120.217.12000000.43)
Report File /data/R12VIS/apps/apps_st/comn/webapps/oacore/html/techstack_info.html
XML Definition File /data/R12VIS/apps/apps_st/appl/fnd/12.0.0/html/txkInventory.xml (120.5.12000000.5)
HTTP Service Properties (lxs3er06.solutions.glbsnet.com):
Technology Components / Properties Component Version/Value
Oracle HTTP Server version 10.1.3.0.0
Sun JDK client version 1.5.0_13
JDK version on HTTP server node 1.5.0_08
Oracle JDBC driver version using JAVA API (oracle.jdbc.driver.OracleDriver) 10.2.0.3.0
Oracle AOLJ version Roll Up Patch J
Oracle BC4J version 10.1.3.41.57
Oracle BiBeans version 3.1.1.5
Oracle HTTP client version 10h
Java object cache 10.1.3
Oracle JRAD libraries version 10.1.3
Oracle MDS version 9.0.6.0.0_26
OA Framework version 12.0.4
Oracle help web version 2.0.8
Oracle XML driver version 10.1.3.0.0
Oracle UIX version 2_3_6_2
OJSP version 10.1.3.0.0
JDK version used by AD utilities on HTTP node 1.5.0_08
Number of symbolic links found under directories served by oracle HTTP server 0
Version of OWA packages 10.1.2.0.5
Package OWA_MATCH exists in SYS schema TRUE
OPatch version on 10.1.3 Oracle Home 1.0.0.0.57
Forms Service Properties (lxs3er06.solutions.glbsnet.com):
Technology Components / Properties Component Version/Value
Developer 10g version 10.1.2.2.0
DB client (RSF) library version in 10.1.2 oracle home 10.1.0.5.0
Forms runtime configuration from context file servlet
JDK version used by AD utilities on forms node 1.5.0_08
Oracle Application Server patchset version 10.1.2.2.0
OPatch version on 10.1.2 Oracle Home 1.0.0.0.57
Concurrent Processing Service Properties (lxs3er06.solutions.glbsnet.com):
Technology Components / Properties Component Version/Value
JDK on concurrent processing node 1.5.0_08
JDK version used by AD utilities on CP node 1.5.0_08
Code Inventory of C-Oracle Home (/data/R12VIS/apps/tech_st/10.1.2)
One-Off Patches Applied on C Oracle Home (/data/R12VIS/apps/tech_st/10.1.2)
5586892 Fri Dec 29 21:22:33 EST 2006
5637184 Wed Jan 16 08:59:00 EST 2008
5985840 Wed Jan 16 09:06:38 EST 2008
5841985 Wed Jan 16 08:57:52 EST 2008
5985861 Wed Jan 16 08:58:20 EST 2008
6083646 Wed Jan 16 09:01:17 EST 2008
5527100 Wed Jan 16 09:05:46 EST 2008
3559326 Fri Dec 29 21:10:37 EST 2006
5893392 Wed Jan 16 09:04:19 EST 2008
5466491 Wed Jan 16 09:04:58 EST 2008
6363690 Wed Jan 16 08:59:27 EST 2008
5650051 Wed Jan 16 09:03:28 EST 2008
5394728 Fri Dec 29 21:19:54 EST 2006
5456500 Wed Jan 16 09:07:06 EST 2008
6002686 Wed Jan 16 09:01:48 EST 2008
5753922 Wed Jan 16 09:02:39 EST 2008
Code Inventory of Java Oracle Home (/data/R12VIS/apps/tech_st/10.1.3):
One-Off Patches Applied on Java Oracle Home (/data/R12VIS/apps/tech_st/10.1.3)
4880540 Fri Dec 29 21:33:48 EST 2006
5586892 Fri Dec 29 21:48:37 EST 2006
5389204 Fri Dec 29 21:34:11 EST 2006
5389100 Fri Dec 29 21:36:26 EST 2006
5017026 Fri Dec 29 21:32:36 EST 2006
4912149 Fri Dec 29 21:35:59 EST 2006
4992357 Fri Dec 29 21:45:29 EST 2006
6083647 Wed Jan 16 09:19:02 EST 2008
5198652 Fri Dec 29 21:35:13 EST 2006
4952820 Fri Dec 29 21:41:15 EST 2006
5336264 Fri Dec 29 21:34:34 EST 2006
4997187 Fri Dec 29 21:33:11 EST 2006
5526722 Fri Dec 29 21:45:08 EST 2006
4930447 Fri Dec 29 21:31:14 EST 2006
5527265 Fri Dec 29 21:44:49 EST 2006
5348943 Fri Dec 29 21:34:52 EST 2006
5035740 Fri Dec 29 21:35:33 EST 2006
5475997 Fri Dec 29 21:40:47 EST 2006
5513480 Fri Dec 29 21:45:52 EST 2006
5576216 Fri Dec 29 21:46:24 EST 2006
5220710 Fri Dec 29 21:44:07 EST 2006
5132392 Fri Dec 29 21:40:21 EST 2006
5499395 Fri Dec 29 21:46:47 EST 2006
