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 ----------------------