How to check Oracle Apps/EBS version

Run following SQL from apps user;

select RELEASE_NAME from fnd_product_groups;

You should see output like:

RELEASE_NAME
-----------------------
11.5.10.2

Make sure you run the above command using the apps user. If you are using SYS or any other user, you may use below query:

select RELEASE_NAME from apps.fnd_product_groups;

You should see output like:

RELEASE_NAME
-----------------------
11.5.10.2