Getting your EBS version and patch level

Getting the version and patchset level of an EBS instance, i.e. which patchsets have been applied, is covered in Oracle Support document ID 390864.1, which includes scripts for single and multi-tier instances.

There are a couple of ways of getting at this information. The support note gives the most thorough and is highly recommended.

To get the version (a/k/a “release name”), do this query in sqlplus:

SQL> select release_name from apps.fnd_product_groups;

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

To get the patch levels for each product installed, use this query:

SQL> select product_version,patch_level
from fnd_product_installations;

PRODUCT_VERSION                PATCH_LEVEL
------------------------------ ------------------------------

11.5.0                         11i.FND.H
11.5.0
11.5.0                         11i.AX.J
11.5.0                         11i.AK.G
11.5.0                         11i.XLA.I
11.5.0                         11i.GL.K
11.5.0                         11i.FA.P
11.5.0                         11i.PER.N
11.5.0                         11i.PAY.M

* * *

Finally, here is the script to grab the RUP level for an EBS 11i single node installation:

SET head off Lines 120 pages 100
col n_patch format A65
col bug_number format A10
col patch_name format A10
spool atg_pf_ptch_level.txt
select ' atg_pf ' FROM dual;
/

select bug_number, decode(bug_number,
'3438354', '11i.ATG_PF.H',
'4017300', '11i.ATG_PF.H.RUP1',
'4125550', '11i.ATG_PF.H.RUP2',
'4334965', '11i.ATG_PF.H RUP3',
'4676589', '11i.ATG_PF.H RUP4',
'5382500', '11i.ATG_PF.H RUP5 HELP',
'5473858', '11i.ATG_PF.H.5',
'5674941', '11i.ATG_PF.H RUP5 SSO Integrat',
'5903765', '11i.ATG_PF.H RUP6',
'6117031', '11i.ATG_PF.H RUP6 SSO 10g Integration',
'6330890', '11i.ATG_PF.H RUP6 HELP',
'6241631', '11i.ATG_PF.H.RUP7',
'8248307', '11i.ATG_PF.H RUP7 HELP'
) n_patch, last_update_date
FROM ad_bugs
WHERE bug_number
IN ( '3438354', '4017300', '4125550', '4334965', '4676589', '5382500', '5473858', '5674941', '5903765', '6117031', '6330890', '6241631', '8248307' );

Running this should result in a response like:

SQL> @ebs11_getlevel.sql

 atg_pf


 atg_pf


3438354    11i.ATG_PF.H                                                      15-JUL-05
4017300    11i.ATG_PF.H.RUP1                                                 16-JUL-05
4125550    11i.ATG_PF.H.RUP2                                                 16-JUL-05
4334965    11i.ATG_PF.H RUP3                                                 23-FEB-07
4676589    11i.ATG_PF.H RUP4                                                 23-FEB-07
5382500    11i.ATG_PF.H RUP5 HELP                                            13-FEB-10
5473858    11i.ATG_PF.H.5                                                    05-SEP-07
5674941    11i.ATG_PF.H RUP5 SSO Integrat                                    05-SEP-07
5903765    11i.ATG_PF.H RUP6                                                 13-FEB-10
6117031    11i.ATG_PF.H RUP6 SSO 10g Integration                             13-FEB-10
6241631    11i.ATG_PF.H.RUP7                                                 17-JUL-10
6330890    11i.ATG_PF.H RUP6 HELP                                            13-FEB-10
8248307    11i.ATG_PF.H RUP7 HELP                                            17-JUL-10

13 rows selected.