0 Replies Last post: Jan 16, 2012 3:25 PM by Community Admin  
Novice 44 posts since
Mar 30, 2009
Currently Being Moderated

Jan 16, 2012 4:53 PM

Oracle Applications Determine Family Pack Versions

When applying Oracle E-Business suite patch or patch sets, occasionally the patch will state that you need to be on certain version, e.g. FIN_PF.G or greater.  You could dig through your notes, view previous patches applied, use license manager, or some other method to find the family pack version you are on.  Or you can use the patchsets utility to find out Family Pack Version (you can use it for versions 10.5, 11i, and 12i).

 

Go to a directory, e.g. $AD_TOP/bin

$ wget ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL/patchsets.sh

Grant execute access

$ chmod +x patchsets.sh

Run the utility

$ ./patchsets.sh  (provide apps/password@SID when prompted)

Sit back, grab a cup of coffee (it is going to tak a while) and watch it run.  It will create a text version of what you are seeing on the screen.

 

$cat Report_11i.txt to see the result.  Below is a sample of the report.

 

=============================================================================
        Report Generated: Mon Jan 16 14:13:43 CST 2012               Tool Version:  4.53
  Patchsets List Updated: Jan 15 22:30
              Machine/OS: SunOS s66kb2 5.10 Generic_139555-08 sun4v sparc SUNW,Sun-Blade-T6320
                  Domain: oracle.com
         applptch Source: Patch.csv
   Version from APPLPTCH: 11.5.10.2
                Database: ORASID       Limited Report to: APPLFULL and APPLSHAR products
                APPLFULL: AK ALR AP AR AS ASO AST AX AZ BIC BIL BIS BIV BOM CRP CSC CSF CS CSI CZ EDR ENG FA FND GL HZ IBE IBY ICX IEO IES IEU INV IZU JE JG JTF JTM MRP MWA ONT PA PJM PO POS QA QOT QP RG WIP WSH XDO
                APPLSHAR: AD AMS AMV ASF ASG AU BIM BIX CCT CE CN CSD CSP CSS CUA DT EC FF IBA IBU IEM MFG MSC OE OKC OKS PAY PER SHT XLA
         Pseudo Products:  ADX AME AML BLC BPA CAC CDR CLE CSK CSZ CTB EDW EWS FTP FWK HCP HCT IGP IGR IPATCH IRC ISX ITA ITM JTA JTH JTO JTP JTT JTU JTY MSX OAM OCM OIE OIR OIT OWF PFT PJR POV RCM TXK UMX
              Written By: Oracle Support, SSANDREW
                 WARNING: DOWNLOAD CHANGING NOVEMBER 3rd, 2006
         Program Updates: ftp://ftp.oracle.com/support/outgoing/PATCHSET_COMPARE_TOOL
      Download Patchsets: Go to link below or click on Patches
     http://metalink.oracle.com/metalink/plsql/dis_download.startup
=============================================================================

Applied Patchsets that Match ARU:
FAMILY PACKS
Prod      Patchset             Bug     RELEASED Release Status      Distribution
================================================================================ =======
atg_pf    11i.ATG_PF.H        3438354 04/11/11 10:48:56 Checkin Released     By_Metalink                               
atg_pf    11i.ATG_PF.H.5      5473858 07/04/30 17:23:24 Checkin Released     By_Metalink                               
bis_pf    11i.BIS_PF.D.1      4054609 05/01/21 11:55:39 Checkin Released     By_Metalink                               
bis_pf    11i.BIS_PF.E.2      4458450 05/10/21 12:03:56 Checkin Released     By_Metalink                               
bis_pf    11i.BIS_PF.E        4143498 05/05/19 10:56:40 Checkin Released     By_Metalink                               
cc_pf     11i.CC_PF.A         2208036 02/02/01 21:32:44 Checkin Released     By_Metalink                               
cc_pf     11i.CC_PF.C         2374818 02/07/15 16:07:25 Checkin Released     By_Metalink                               
cc_pf     11i.CC_PF.Q         2644375 03/06/18 17:10:03 Checkin Released     By_Metalink                               
cc_pf     11i.CC_PF.R         3202573 04/11/05 10:22:22 Checkin Released     By_Metalink                               
dmf_pf    11i.DMF_PF.G        2133107 02/02/01 11:00:44 Checkin Released     By_Metalink                               
dmf_pf    11i.DMF_PF.H        2248408 02/08/17 08:03:30 Checkin Released     By_Metalink                               
dmf_pf    11i.DMF_PF.I        2697753 03/06/23 10:28:07 Checkin Released     By_Metalink                               
dmf_pf    11i.DMF_PF.J        2771139 04/09/17 18:17:22 Checkin Released     Not_Distributed                           
fin_pf    11i.FIN_PF.C        2380068 02/08/16 18:45:45 Checkin Released     By_Metalink                               
fin_pf    11i.FIN_PF.D        2629235 03/04/01 13:30:33 Patchset Closed      Not_Distributed                           
fin_pf    11i.FIN_PF.E        2842697 03/12/12 15:34:58 Checkin Released     By_Metalink                               
fin_pf    11i.FIN_PF.F        3153675 04/11/05 10:54:38 Checkin Released     By_Metalink                               
hr_pf     11i.HR_PF.A         2115771 02/02/24 08:16:26 Checkin Released     By_Metalink                               
hr_pf     11i.HR_PF.C.1       2502761 02/08/08 07:15:02 Checkin Released     By_Metalink                               
hr_pf     11i.HR_PF.E         2803988 03/05/30 01:39:19 Checkin Released     By_Metalink                               
hr_pf     11i.HR_PF.G         3116666 03/12/05 17:02:06 Checkin Released     By_Metalink                               
hr_pf     11i.HR_PF.I         3127777 04/11/04 21:17:15 Checkin Released     Not_Distributed                           
mas_pf    11i.MAS_PF.A        3386886 04/11/05 10:16:48 Checkin Released     By_Metalink                               
mkt_pf    11i.MKT_PF.A        2459266 02/10/11 22:22:36 Checkin Released     By_Metalink                               
mkt_pf    11i.MKT_PF.B        2630927 03/06/24 18:05:32 Checkin Released     By_Metalink                               
ok_pf     11i.OK_PF.B         2180833 02/01/25 12:23:43 Checkin Released     By_Metalink                               
ok_pf     11i.OK_PF.H         2440054 02/09/13 16:38:14 Checkin Released     By_Metalink                               
ok_pf     11i.OK_PF.I         2661036 03/06/20 17:37:49 Checkin Released     By_Metalink                               
ok_pf     11i.OK_PF.J         3195181 04/09/17 18:32:35 Checkin Released     Not_Distributed                           
om_pf     11i.OM_PF.G         2118482 02/02/05 14:31:26 Checkin Released     By_Metalink                               
om_pf     11i.OM_PF.H         2250333 02/08/22 13:27:09 Checkin Released     By_Metalink                               
om_pf     11i.OM_PF.I         2698175 03/06/20 17:24:21 Checkin Released     By_Metalink                               
om_pf     11i.OM_PF.J         3210616 04/09/18 02:27:18 Checkin Released     Not_Distributed                           
opm_pf    11i.OPM_PF.H.1      2220884 02/02/12 15:38:50 Checkin Released     By_Metalink                               
opm_pf    11i.OPM_PF.I        2216258 02/07/30 19:07:47 Checkin Released     By_Metalink                               
opm_pf    11i.OPM_PF.J        2433137 02/12/30 12:27:05 Checkin Released     By_Metalink                               
opm_pf    11i.OPM_PF.L        2916642 04/09/17 16:14:39 Checkin Released     Not_Distributed                           
pj_pf     11i.PJ_PF.J         2381317 02/08/30 13:30:32 Checkin Released     Not_Distributed                           
pj_pf     11i.PJ_PF.K         2484626 03/04/23 23:07:17 Checkin Released     By_Metalink                               
pj_pf     11i.PJ_PF.L.10      3397153 04/11/05 11:03:47 Checkin Released     By_Metalink                               
pj_pf     11i.PJ_PF.M         3485155 05/05/16 00:45:55 Checkin Released     By_Metalink                               
plm_pf    11i.PLM_PF.A        2720739 03/06/12 11:07:56 Checkin Released     By_Dev                                    
plm_pf    11i.PLM_PF.B        3016576 03/07/31 18:03:30 Checkin Released     By_Dev                                    
plm_pf    11i.PLM_PF.C        3298676 04/11/03 17:47:21 Checkin Released     By_Dev                                    
prc_pf    11i.PRC_PF.G        2141229 02/02/01 18:15:11 Checkin Released     By_Metalink                               
prc_pf    11i.PRC_PF.H        2320032 02/08/15 18:41:30 Checkin Released     By_Metalink                               
prc_pf    11i.PRC_PF.I        2700001 03/06/20 16:20:21 Checkin Released     By_Metalink                               
prc_pf    11i.PRC_PF.J        3219529 04/09/17 18:25:32 Checkin Released     Not_Distributed                           
scm_pf    11i.SCM_PF.J        3384350 04/11/05 10:52:10 Checkin Released     By_Metalink                               
scp_pf    11i.SCP_PF.G        2143725 02/01/30 19:18:18 Checkin Released     By_Metalink                               
scp_pf    11i.SCP_PF.H        2250399 02/08/15 17:42:35 Checkin Released     By_Metalink                               
scp_pf    11i.SCP_PF.I        2696797 03/06/23 11:00:16 Checkin Released     By_Metalink                               
scp_pf    11i.SCP_PF.J        3200668 04/09/17 18:22:33 Checkin Released     Not_Distributed                           
sls_pf    11i.SLS_PF.D        2221190 02/02/17 18:45:28 Checkin Released     By_Dev                                    
sls_pf    11i.SLS_PF.F        2435494 02/10/11 20:11:22 Checkin Released     By_Metalink                               
sls_pf    11i.SLS_PF.G        2645935 03/06/24 20:10:30 Checkin Released     By_Metalink                               
srv_pf    11i.SRV_PF.B        2192849 02/02/01 11:49:38 Checkin Released     By_Metalink                               
srv_pf    11i.SRV_PF.H        2477294 02/09/14 19:04:39 Checkin Released     By_Metalink                               
srv_pf    11i.SRV_PF.I        2713120 03/06/23 12:02:13 Checkin Released     By_Metalink                               
srv_pf    11i.SRV_PF.J        3169650 04/09/17 15:16:00 Checkin Released     Not_Distributed                          

More Like This

  • Retrieving data ...