Product Installation Status, Version Info and Patch Level

How to find product install status and version info and patch level.



Login to UNIX as applmgr user: set the env
[appsuser@panchal bin]$cd $AD_TOP/sql
[appsuser@panchal bin]$ sqlplus apps/apps @adutconf.sql

This will show the output on screen and also generate a spool file in the same directory.

This will have a lot of information: Here is part of the output.



Product Installation Status, Version Info and Patch Level

Product Appl Status Version Patchset Level Update Date
-------- -------------- -------- -------------------- -----------------
AD Shared 12.0.0 R12.AD.A.4 16-Jan-2008
AHL Installed 12.0.0 R12.AHL.A.4 16-Jan-2008
AK Installed 12.0.0 R12.AK.A.4 16-Jan-2008
ALR Installed 12.0.0 R12.ALR.A.4 16-Jan-2008
AME Installed 12.0.0 R12.AME.A.4 16-Jan-2008
AMS Installed 12.0.0 R12.AMS.A.4 16-Jan-2008
AMV Shared 12.0.0 R12.AMV.A.4 16-Jan-2008
AMW Installed 12.0.0 R12.AMW.A.4 16-Jan-2008
AP Installed 12.0.0 R12.AP.A.4 16-Jan-2008
AR Installed 12.0.0 R12.AR.A.4 16-Jan-2008
AS Installed 12.0.0 R12.AS.A.4 16-Jan-2008
ASF Installed 12.0.0 R12.ASF.A.4 16-Jan-2008
ASG Shared 12.0.0 R12.ASG.A.4 16-Jan-2008
ASL Installed 12.0.0 R12.ASL.A.4 16-Jan-2008
ASN Installed 12.0.0 R12.ASN.A.4 16-Jan-2008
ASO Installed 12.0.0 R12.ASO.A.4 16-Jan-2008
ASP Installed 12.0.0 R12.ASP.A.4 16-Jan-2008
AST Installed 12.0.0 R12.AST.A.4 16-Jan-2008
AU Installed 12.0.0 -- Not Available -- 16-Jan-2008
AX Installed 12.0.0 11i.AX.J 16-Jan-2008
AZ Installed 12.0.0 R12.AZ.A.4 16-Jan-2008
BEN Installed 12.0.0 R12.BEN.A.4 16-Jan-2008
BIC Installed 12.0.0 R12.BIC.A.4 16-Jan-2008
BIL Installed 12.0.0 R12.BIL.A.4 16-Jan-2008
BIM Installed 12.0.0 R12.BIM.A.4 16-Jan-2008
BIS Installed 12.0.0 R12.BIS.A.4 16-Jan-2008
BIV Installed 12.0.0 R12.BIV.A.4 16-Jan-2008
BIX Installed 12.0.0 R12.BIX.A.4 16-Jan-2008
BNE Installed 12.0.0 R12.BNE.A.4 16-Jan-2008
BOM Installed 12.0.0 R12.BOM.A.4 16-Jan-2008
BSC Installed 12.0.0 R12.BSC.A.4 16-Jan-2008
CCT Installed 12.0.0 R12.CCT.A.4 16-Jan-2008
CE Installed 12.0.0 R12.CE.A.4 16-Jan-2008
CHV Installed 12.0.0 R12.CHV.A.4 16-Jan-2008
CLN Installed 12.0.0 R12.CLN.A.4 16-Jan-2008
CN Installed 12.0.0 R12.CN.A.4 16-Jan-2008
CRP Installed 12.0.0 R12.CRP.A.4 16-Jan-2008
CS Installed 12.0.0 R12.CS.A.4 16-Jan-2008
CSC Installed 12.0.0 R12.CSC.A.4 16-Jan-2008
CSD Installed 12.0.0 R12.CSD.A.4 16-Jan-2008
CSE Installed 12.0.0 R12.CSE.A.4 16-Jan-2008
CSF Installed 12.0.0 R12.CSF.A.4 16-Jan-2008
CSI Installed 12.0.0 R12.CSI.A.4 16-Jan-2008
CSL Installed 12.0.0 R12.CSL.A.4 16-Jan-2008
CSM Installed 12.0.0 R12.CSM.A.4 16-Jan-2008
CSP Installed 12.0.0 R12.CSP.A.4 16-Jan-2008
CSR Installed 12.0.0 R12.CSR.A.4 16-Jan-2008
CUA Shared 12.0.0 -- Not Available -- 16-Jan-2008
CUF Installed 12.0.0 -- Not Available -- 16-Jan-2008
CUG Installed 12.0.0 R12.CUG.A.4 16-Jan-2008
CUI Shared 12.0.0 -- Not Available -- 16-Jan-2008
CUP Shared 12.0.0 -- Not Available -- 16-Jan-2008
CUS Installed 12.0.0 -- Not Available -- 16-Jan-2008
CZ Installed 12.0.0 R12.CZ.A.4 16-Jan-2008
DDD Installed 12.0.0 R12.DDD.A.4 16-Jan-2008
DNA Installed 12.0.0 R12.DNA.A.4 16-Jan-2008
DOM Installed 12.0.0 R12.DOM.A.4 16-Jan-2008
DT Shared 12.0.0 R12.DT.A.4 16-Jan-2008
EAM Installed 12.0.0 R12.EAM.A.4 16-Jan-2008
EC Installed 12.0.0 R12.EC.A.4 16-Jan-2008
ECX Installed 12.0.0 R12.ECX.A.4 16-Jan-2008
EDR Installed 12.0.0 R12.EDR.A.4 16-Jan-2008
EGO Installed 12.0.0 R12.EGO.A.4 16-Jan-2008
ENG Installed 12.0.0 R12.ENG.A.4 16-Jan-2008
ENI Installed 12.0.0 R12.ENI.A.4 16-Jan-2008
FA Installed 12.0.0 R12.FA.A.4 16-Jan-2008
FEM Installed 12.0.0 R12.FEM.A.4 16-Jan-2008
FF Shared 12.0.0 R12.FF.A.4 16-Jan-2008
FII Installed 12.0.0 R12.FII.A.4 16-Jan-2008
FLM Installed 12.0.0 R12.FLM.A.4 16-Jan-2008
FND Installed 12.0.0 R12.FND.A.4 16-Jan-2008
FPA Installed 12.0.0 R12.FPA.A.4 16-Jan-2008
FRM Installed 12.0.0 R12.FRM.A.4 16-Jan-2008
FTE Installed 12.0.0 R12.FTE.A.4 16-Jan-2008
FTP Installed 12.0.0 R12.FTP.A.4 16-Jan-2008
FUN Installed 12.0.0 R12.FUN.A.4 16-Jan-2008
FV Installed 12.0.0 R12.FV.A.4 16-Jan-2008
GCS Installed 12.0.0 R12.GCS.A.4 16-Jan-2008
GHR Installed 12.0.0 R12.GHR.A.4 16-Jan-2008
GL Installed 12.0.0 R12.GL.A.4 16-Jan-2008
GMA Installed 12.0.0 R12.GMA.A.4 16-Jan-2008
GMD Installed 12.0.0 R12.GMD.A.4 16-Jan-2008
GME Installed 12.0.0 R12.GME.A.4 16-Jan-2008
GMF Installed 12.0.0 R12.GMF.A.4 16-Jan-2008
GMI Installed 12.0.0 R12.GMI.A.4 16-Jan-2008
GML Installed 12.0.0 R12.GML.A.4 16-Jan-2008
GMO Installed 12.0.0 R12.GMO.A.4 16-Jan-2008
GMP Installed 12.0.0 R12.GMP.A.4 16-Jan-2008
GMS Installed 12.0.0 R12.GMS.I 16-Jan-2008
GR Installed 12.0.0 R12.GR.A.4 16-Jan-2008
HRI Installed 12.0.0 R12.HRI.A.4 16-Jan-2008
HXC Installed 12.0.0 11i.HXC.C 16-Jan-2008
HXT Installed 12.0.0 R12.HXT.A.4 16-Jan-2008
IA Installed 12.0.0 R12.IA.A.4 16-Jan-2008
IBC Installed 12.0.0 R12.IBC.A.4 16-Jan-2008
IBE Installed 12.0.0 R12.IBE.A.4 16-Jan-2008
IBP Installed 12.0.0 -- Not Available -- 16-Jan-2008
IBU Installed 12.0.0 R12.IBU.A.4 16-Jan-2008
IBW Installed 12.0.0 R12.IBW.A.4 16-Jan-2008
IBY Installed 12.0.0 R12.IBY.A.4 16-Jan-2008
ICX Installed 12.0.0 R12.ICX.A.4 16-Jan-2008
IEB Installed 12.0.0 R12.IEB.A.4 16-Jan-2008
IEC Installed 12.0.0 R12.IEC.A.4 16-Jan-2008
IEM Installed 12.0.0 R12.IEM.A.4 16-Jan-2008
IEO Installed 12.0.0 R12.IEO.A.4 16-Jan-2008
IES Installed 12.0.0 R12.IES.A.4 16-Jan-2008
IEU Installed 12.0.0 R12.IEU.A.4 16-Jan-2008
IEX Installed 12.0.0 R12.IEX.A.4 16-Jan-2008
IGC Installed 12.0.0 -- Not Available -- 16-Jan-2008
IGF Installed 12.0.0 -- Not Available -- 16-Jan-2008
IGI Installed 12.0.0 R12.IGI.A.4 16-Jan-2008
IGS Installed 12.0.0 R12.IGS.A.2 16-Jan-2008
IGW Installed 12.0.0 R12.IGW.A.4 16-Jan-2008
IMC Installed 12.0.0 R12.IMC.A.4 16-Jan-2008
INV Installed 12.0.0 R12.INV.A.4 16-Jan-2008
IPA Shared 12.0.0 R12.IPA.A.4 16-Jan-2008
IPM Installed 12.0.0 -- Not Available -- 16-Jan-2008
IRC Installed 12.0.0 R12.IRC.A.4 16-Jan-2008
ISC Installed 12.0.0 R12.ISC.A.4 16-Jan-2008
ITA Installed 12.0.0 R12.ITA.A.4 16-Jan-2008
ITG Installed 12.0.0 R12.ITG.A.4 16-Jan-2008
IZU Installed 12.0.0 R12.IZU.A.4 16-Jan-2008
JA Installed 12.0.0 R12.JA.A.4 07-Oct-2002
JE Installed 12.0.0 R12.JE.A.4 07-Oct-2002
JG Installed 12.0.0 R12.JG.A.4 16-Jan-2008
JL Installed 12.0.0 R12.JL.A.4 07-Oct-2002
JMF Installed 12.0.0 R12.JMF.A.4 16-Jan-2008
JTF Installed 12.0.0 R12.JTF.A.4 16-Jan-2008
JTM Installed 12.0.0 R12.JTM.A.4 16-Jan-2008
JTS Installed 12.0.0 11i.JTS.E 28-Oct-2005
LNS Installed 12.0.0 R12.LNS.A.4 16-Jan-2008
MFG Shared 12.0.0 R12.MFG.A.4 16-Jan-2008
MRP Installed 12.0.0 R12.MRP.A.4 16-Jan-2008
MSC Installed 12.0.0 R12.MSC.A.4 16-Jan-2008
MSD Installed 12.0.0 R12.MSD.A.4 16-Jan-2008
MSO Installed 12.0.0 R12.MSO.A.4 16-Jan-2008
MSR Installed 12.0.0 R12.MSR.A.4 16-Jan-2008
MST Installed 12.0.0 R12.MST.A.4 16-Jan-2008
MWA Installed 12.0.0 R12.MWA.A.4 16-Jan-2008
OE Shared 12.0.0 R12.OE.A.4 16-Jan-2008
OKC Installed 12.0.0 R12.OKC.A.4 16-Jan-2008
OKE Installed 12.0.0 R12.OKE.H 16-Jan-2008
OKI Installed 12.0.0 R12.OKI.A.4 16-Jan-2008
OKL Installed 12.0.0 R12.OKL.A.4 16-Jan-2008
OKS Installed 12.0.0 R12.OKS.A.4 16-Jan-2008
OKX Installed 12.0.0 R12.OKX.A.4 16-Jan-2008
ONT Installed 12.0.0 R12.ONT.A.4 16-Jan-2008
OPI Installed 12.0.0 R12.OPI.A.4 16-Jan-2008
OTA Installed 12.0.0 R12.OTA.A.4 16-Jan-2008
OZF Installed 12.0.0 R12.OZF.A.4 16-Jan-2008
PA Installed 12.0.0 R12.PA.A.4 16-Jan-2008
PAY Installed 12.0.0 R12.PAY.A.4 16-Jan-2008
PER Installed 12.0.0 R12.PER.A.4 16-Jan-2008
PFT Installed 12.0.0 R12.PFT.A.4 16-Jan-2008
PJI Installed 12.0.0 R12.PJI.A.4 16-Jan-2008
PJM Installed 12.0.0 R12.PJM.A.4 16-Jan-2008
PMI Installed 12.0.0 R12.PMI.A.4 16-Jan-2008
PN Installed 12.0.0 R12.PN.A.4 16-Jan-2008
PO Installed 12.0.0 R12.PO.A.4 16-Jan-2008
POA Installed 12.0.0 R12.POA.A.4 16-Jan-2008
POM Installed 12.0.0 R12.POM.A.4 16-Jan-2008
PON Installed 12.0.0 R12.PON.A.4 16-Jan-2008
POS Installed 12.0.0 R12.POS.A.4 16-Jan-2008
PQH Installed 12.0.0 R12.PQH.A.4 16-Jan-2008
PQP Installed 12.0.0 R12.PQP.A.4 16-Jan-2008
PRP Installed 12.0.0 R12.PRP.A.4 16-Jan-2008
PSA Installed 12.0.0 R12.PSA.A.4 16-Jan-2008
PSB Installed 12.0.0 R12.PSB.A.4 16-Jan-2008
PSP Installed 12.0.0 R12.PSP.A.4 16-Jan-2008
PV Installed 12.0.0 R12.PV.A.4 16-Jan-2008
QA Installed 12.0.0 R12.QA.A.4 16-Jan-2008
QOT Installed 12.0.0 R12.QOT.A.4 16-Jan-2008
QP Installed 12.0.0 R12.QP.A.4 16-Jan-2008
QRM Installed 12.0.0 R12.QRM.A.4 16-Jan-2008
RG Installed 12.0.0 R12.RG.A.4 16-Jan-2008
RLM Installed 12.0.0 R12.RLM.A.4 16-Jan-2008
SHT Shared 12.0.0 R12.SHT.A.4 16-Jan-2008
SSP Installed 12.0.0 R12.SSP.A.4 16-Jan-2008
SYSADMIN Installed 12.0.0 -- Not Available -- 16-Jan-2008
VEA Installed 12.0.0 R12.VEA.A.4 16-Jan-2008
WIP Installed 12.0.0 R12.WIP.A.4 16-Jan-2008
WMS Installed 12.0.0 R12.WMS.A.4 16-Jan-2008
WPS Installed 12.0.0 R12.WPS.A.4 16-Jan-2008
WSH Installed 12.0.0 R12.WSH.A.4 16-Jan-2008
WSM Installed 12.0.0 R12.WSM.A.4 16-Jan-2008
XDO Installed 12.0.0 R12.XDO.A.4 16-Jan-2008
XDP Installed 12.0.0 R12.XDP.A.4 16-Jan-2008
XLA Installed 12.0.0 R12.XLA.A.4 16-Jan-2008
XLE Installed 12.0.0 R12.XLE.A.4 16-Jan-2008
XNB Installed 12.0.0 R12.XNB.A.4 16-Jan-2008
XNP Installed 12.0.0 R12.XNP.A.4 16-Jan-2008
XTR Installed 12.0.0 R12.XTR.A.4 16-Jan-2008
ZFA Installed 12.0.0 -- Not Available -- 28-Oct-2005
ZPB Installed 12.0.0 R12.ZPB.A.4 16-Jan-2008
ZSA Installed 12.0.0 -- Not Available -- 28-Oct-2005
ZX Installed 12.0.0 R12.ZX.A.4 16-Jan-2008
id 692 Installed 12.0.0 -- Not Available -- 21-Dec-1999
id 693 Installed 12.0.0 -- Not Available -- 21-Dec-1999

198 rows selected.