• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Ebuisness Suite » how to check ebs version : Apache, Java, FMW, WebLogic , forms

how to check ebs version : Apache, Java, FMW, WebLogic , forms

September 25, 2022 by techgoeasy Leave a Comment

We are often asked how to check ebs version, How to find the EBS R12 components Version. This includes all R12.0/R12.1 and R12.2. I will try to explain how to find out that with various EBS R12 versions with commands and reports.

Table of Contents

  • Apache Version/how to check oracle application server version in r12
  • Perl Version
  • Java Version/JDK Version
  • JRE version
  • Forms Version
  • Plsql Version
  • Forms Communication mode
  • how to check database version in oracle
  • Version collection script provided by Oracle
  • Weblogic version in R12.2
  • Fusion Middle Ware (FMW) version in EBS R12.2 /how to check fmw version
  • how to check oracle apps version from the backend (11i/R12/12.2)/how to check oracle ebs version
  • How to check the version of the file on the filesystem
  • How to check Unix Operating system Version
  • How to check the AD & TXK version in R12.2
  • How to find Workflow Version with Apps
  • what is the latest version of oracle ebs

Apache Version/how to check oracle application server version in r12

We can log in to the Application server and source the environment and then run the below command to check the oracle application server version

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

Output for 11i should be like:

Server version: 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)

Output for R12 should be like:

Server version: Oracle-Application-Server-10g/10.1.3.0.0Oracle-HTTP-Server
Server built: Dec 4 2006 14:44:38

Perl Version

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

Java Version/JDK 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”

how to check database version in oracle

Connect to the Oracle database with sqlplus as sysdba and run the next query:

SQL> select * from v$version;

Version collection script provided by Oracle

We collect versions of technology stack components using oracle provided script as  described in MOS article 601736.1

Application Tier

perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=$CONTEXT_FILE -appspass=<apps password> -outfile=$APPLTMP/Report_App_Inventory.html

Database Tier

$ADPERLPRG $ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp
-contextfile=$CONTEXT_FILE
-appspass=<apps password>
-outfile=$ORACLE_HOME/appsutil/temp/Report_DB_Inventory.html

Weblogic version in R12.2

Weblogic Version can be found using the below command

cat $FMW_HOME/wlserver_10.3/.product.properties | grep WLS_PRODUCT_VERSION

Fusion Middle Ware (FMW) version in EBS R12.2 /how to check fmw version

Source Fusion Middle Ware oracle home and then run the below opatch command

$ORACLE_HOME/OPatch/opatch lsinventory

how to check oracle apps version from the backend (11i/R12/12.2)/how to check oracle ebs version

Connect to the database as user apps

SQL> select release_name from apps.fnd_product_groups;

How to check the version of the file on the filesystem

Login to the application Node ,Source the environment file. Then Goto the location of file.

adident Header <file name>
or
strings <file_name> | grep Header

How to check Unix Operating system Version

Solaris -> cat /etc/release
Red Hat Linux -> cat /etc/redhat-release

How to check the AD & TXK version in R12.2

sqlplus apps/appspass

column codelevel format a30
column name format a40
select  ABBREVIATION, NAME, codelevel FROM AD_TRACKABLE_ENTITIES where abbreviation in ('txk','ad');

ABBREVIA NAME                                     CODELEVEL
-------- ---------------------------------------- ------------------------------
ad       Applications DBA                         C.7
txk      Oracle Applications Technology Stack     C.7

How to find Workflow Version with Apps

Connect to Database as apps user:

SQL> select text ,name from wf_resources where name like '%WF_VERSION%';
Output should be like:
TEXT NAME
----------- -----------
2.6.0 WF_VERSION

what is the latest version of oracle ebs

EBS 12.2.11

Please take a look at the following post for more information

what is oracle EBS R12
Oracle R12 INST_TOP
E-Business Suite 11i/R12/R12.1/R12.2
Oracle E-Business Suite Architecture in 12.2
how to apply weblogic patch in R12.2

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: How to find R12 components Version

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)
  • How to check encrypted tablespace in the Database
  • How To Export -Import TDE Master Encryption Key
  • How to Configure Auto Login TDE Wallet

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us