20111004 getting your ebs version and patch level - plembo/onemoretech GitHub Wiki
title: Getting your EBS version and patch level link: https://onemoretech.wordpress.com/2011/10/04/getting-your-ebs-version-and-patch-level/ author: lembobro description: post_id: 1218 created: 2011/10/04 17:17:27 created_gmt: 2011/10/04 21:17:27 comment_status: closed post_name: getting-your-ebs-version-and-patch-level status: publish post_type: post
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.
`
Copyright 2004-2019 Phil Lembo