Monday 9 May 2011

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

Posted by at

4 comments:

  1. Unknown12 January 2016 at 14:44

    Hello, I think it should be "select RELEASE_NAME from apps.fnd_product_groups;" When I tried your query, it gives error.

    ReplyDelete
    Replies
    1. Unknown11 October 2016 at 00:41

      It happened because you might have tried it from SYS or any other user, he mentioned it already from "apps" user.

      Delete
  2. santhosh16 January 2017 at 01:24

    This comment has been removed by the author.

    ReplyDelete
  3. Santosh2 April 2021 at 06:14

    Thanks for sharing valuable info to find the component version of Oracle E-Business Suite. I was looking for Oracle E-Business Suite
    version check and I got it.

    ReplyDelete

Subscribe to: Post Comments (Atom)

Number of Visitors