Oracle Apps Version

select release_name from apps.fnd_product_Groups;

Application AD patch set

select patch_level from fnd_product_installations where patch_level like '%AD%';

Version of Applications Forms (fmb,fmx) or reports (rdf)

To find the version of any oracle applications files
strings -a ICQTYED.fmx | grep Header

adident Header ICQTYED.fmx

Version of a Java class File
$ strings | grep '$Header'

Version of JDBC

In your middle tier, edit the jserv.properties file located in the iAS_ ORACLE_HOME/Apache/Jserv/etc directory
Locate the wrapper.classpath that is pointing to the jdbc zip file
/u01/oracle/viscomn/java/jdbc14.zip

http://.:port/OA_HTML/jsp/fnd/aoljtest.jsp
String ” JDBC driver version” under Connection String

Version of Apache
$ httpd -version

Version Of The OA Framework
Option 1
http://.:port/OA_HTML/OAInfo.jsp

Option 2
adident Header %FND_TOP%/html/OA.jsp
adident Header %OA_HTML%/OA.jsp

Version of Discoverer

cd $APPL_TOP/admin
grep -I s_disco_ver_comma **xml

ojsp version

http://application:8000/OA_HTML/jtflogin.jsp
OJSP Version: 1.1.3.5.2

Version of JSP

Log on to your HTTP Server node, and change to the OA_HTML directory.
Using a text editor, create a file called test.jsp with only the following line:


Access this JSP from a web browser, using the URL:
http://[your web server]:[your port]/OA_HTML/test.jsp

Version of Portal
select fnd_oracle_schema.getouvalue(’PORTAL’) from dual;

FND_ORACLE_SCHEMA.GETOUVALUE(’PORTAL’)

PORTAL30 select WF_EVENT_XML.XMLVersion() XML_VERSION from sys.dual;
XML_VERSION
------------------------------------------ --------------------------------------
Oracle XDK Java 9.0.4.0.0 Production

Version of XML Publisher

To check weather XML publisher is installed or not you can query the FND_PRODUCT_INSTALLATIONS table or you can lookup the
reports in Oracle Applications Manager. You can find out the version for your XML publisher from the output of your report or from MetaInfo.class file.

$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class.

Version of WorkFlow

You can find out the version of your workflow using the following query
SQL> select TEXT Version from WF_RESOURCES where TYPE = 'WFTKN' and NAME = 'WF_VERSION';
VERSION
------------------------------------------ --------------------------------------
2.6.0

Developer patchset level

source environment file

f60gen

Forms 6.0 (Form Compiler) Version 6.0.8.25.2 (Production)