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
ACTION PLAN ============
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 Oracle > 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;
**DISCLAIMER 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 http://www.orawin.info -- //www.freelists.org/webpage/oracle-l