Versions of Oracle EBS Components

It is pretty coolest thing to remember, the VERSIONS: :)

Whenever you are working in oracle applications you will face some situation where you have to know the version of the products you are using in your Oracle Application. Though the env file help you a lot to reduce the need of the versions as it makes the system user friendly. In some issue solving cases such as upgrade, patching or some specific issues you must have to know the versions.The products we are using can be of almost three types
1. Components related to Application
2. Components related to Database.
3. Components related to some useful utilities and OS
Components related to Application:
a. The version of the oracle application.
Step 1. First open the Oracle Application Frontend
Step 2. Open any form session in it
Step 3. Go to help
Step 4. Click on "About Oracle Application"

b. Version of Oracle Application Forms or Reports.
Step 1. Go to the UNIX box
Step 2. Go to the $CUSTOM_TOP location
Step 3. Then go to /11.5.0/forms/US/
Step 4. Run the following command
$strings -a grep Header
Step 1. Go to the UNIX box
Step 2. Go to the report location
Step 3. Run the following command
$strings -a grep Header
c. Class file version
Step 1. Go to the UNIX box
Step 2. Go to the class file location
$strings -a grep Header
d. Apachhe Version
Step 1. Go to the UNIX box
Step 2. Go to the $iAS or $IAS_CONFIG_HOME
Step 3. Then go to Apachhe/Apache/bin directory
Step 4. run the following Command
$httpd -version
The output will be
$ httpd -version
Server: 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)
e. OA Framework Version
Step 1. Open the following URLhttp://.:/OA_HTML/OAInfo.jsp

The page will show like the following
OA Framework Version Information
OA Framework Version 11.5.10.4
RUP. MDS Version 9.0.5.4.89 (build 555)
UIX Version 2.2.24
BC4J Version 9.0.3.13.93
Generated on Wed Dec 10 20:06:25 GMT+05:00 2008

f. Patch Level or Patch Version
It is the most genegal requirement in oracle apps. It can be found from the following query in sqlplus
select patch_level from fnd_product_installations where patch_level like '%AD%';
The output will be
PATCH_LEVEL
------------
11i.AD.I.4
g. Workflow VersionIt is one of the most genegal requirement in oracle apps.
It can be found from the following query in sqlplus
select text Workflow_version from wf_resources where type = 'WFTKN' and name= 'WF_VERSION';
The output will be
WORKFLOW_VERSION
-----------------
2.6.0h.
XML Publisher Version
Step 1. Go to the UNIX box
Step 2. Go to the $OA_JAVAor JAVA top
Step 3. Then go to oracle/apps/xdo/common directory
Step 4. Open the MetaInfo.classComponents Of oracle Database:
a. Oracle RDBMS VersionRun the following query
select * from v$version;
The output will be
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - ProductionCORE 9.2.0.6.0
ProductionTNS for Solaris: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production

b. OPATCH version
Step 1. Go to the UNIX box
Step 2. Go to the $ORACLE_HOME
Step 3. Then go to OPatch/ directory
Step 4. run the following Command
$ perl opatch.pl version
Oracle Interim Patch Installer version 1.0.0.0.52Copyright (c) 2005 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation underOPatch/docs for usage reference. We also recommend using the latest OPatch version. For the latest OPatch versionand other support related issues,
please refer to document293369.1
which is viewable from metalink.oracle.com
OPatch Version: 1.0.0.0.52