Re: Patches details

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: rstauffer@xxxxxxxxxxxxxxxxxxxx
  • Date: Mon, 11 Sep 2006 20:20:52 +0100

or you can log an SR, on almost any subject, and you'll get one of the
many ways already mentioned - or a new one (run diagnostics seems to
be the favourite currently) requested as part of the



On 9/11/06, Stauffer, Robert G <rstauffer@xxxxxxxxxxxxxxxxxxxx> wrote:
You can also use Oracle Applications Manager's Patching and Utilities.

Bob Stauffer DBA D&E Communications Ephrata, PA, USA 717-738-8737 rstauffer@xxxxxxxxxxxxxxxxxxxx

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Radoulov, Dimitre
Sent: Sunday, September 10, 2006 02:46
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Patches details

> opatch is used to see applied patches at database level.
> What command or how to check what are patches have been applied to
> E-Business Suite?

1. MetaLink Note:162498.1


2. By querying the database:

SELECT bug_number
FROM ad_bugs
WHERE bug_number IN ('patch_number', 'patch_number', . . .)
ORDER BY bug_number DESC;

Regards Dimitre


This e-mail message and any files transmitted with it are intended for the use of 
the individual or entity to which they are addressed and may contain information 
that is privileged, proprietary and confidential. If you are not the intended 
recipient, you may not use, copy or disclose to anyone the message or any 
information contained in the message. If you have received this communication in 
error, please notify the sender and delete this e-mail message. The contents do not 
represent the opinion of D&E except to the extent that it relates to their 
official business.


Niall Litchfield
Oracle DBA

Other related posts: