How to Check the Version of Oracle E-Business Suite

April 2, 2021

You can use simple SQLPlus query to find the version of Oracle E-Business Suite. Recently the latest Oracle EBS version R12.2.10 has been released to download as a patch.

If you are planning for EBS Oracle Applications upgrade and patching, then you must check version of Oracle Apps R12 before upgrade.

Trending Topic:

Tablespace Utilization In Oracle Multitenant Database

Query to Check Version of Oracle Apps R12 E-Business Suite

Login as apps user and execute the below query:
SQL> SELECT RELEASE_NAME FROM FND_PRODUCT_GROUPS;
 RELEASE_NAME
 12.2.9

If you are login using sys, you can use below query:
SQL> select release_name from apps.fnd_product_groups;
 RELEASE_NAME
 12.2.9
Query to find the version of Oracle E-Business Suite EBS R12.

Conclusion: You can find EBS Oracle Apps R12 Version by querying on fnd_product_groups table.

Must Read: