Skip to main content

Posts

Showing posts from July, 2013

How to check if your 11i exact version -- Specially 11.5.9

To check any 11i version, Oracle provides a standard table APPS.FND_PRODUCT_GROUPS.

Execute the statement below to get the exact version,

1. Following is on a 11.5.9 instance.

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
11.5.9


11.5.9 comes with 2 updates. 11.5.9.CU1 and 11.5.9.CU2.

To check if you are on 11.5.9.2, execute the following statement to check if CU2 update patch has been applied on your instance.

SQL> select 'You are on 11.5.9.2'
from ad_bugs
where bug_number = '3171663';

'YOUAREON11.5.9.2'
-------------------
You are on 11.5.9.2




2. Follwing is on a 11.5.10 instance.


SQL> select release_name from apps.fnd_product_groups;

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


3. Follwing is on a R12 instance.


SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME
--------------------------------------------------
12.1.3