From oracle-l-bounce@freelists.org Fri Jun 4 09:03:51 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i54E3aU06508 for ; Fri, 4 Jun 2004 09:03:46 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i54E3M606433 for ; Fri, 4 Jun 2004 09:03:32 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DCC0572CC88; Fri, 4 Jun 2004 08:49:45 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11672-68; Fri, 4 Jun 2004 08:49:45 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66D2272D249; Fri, 4 Jun 2004 08:41:04 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 04 Jun 2004 08:39:20 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E305772C435 for ; Fri, 4 Jun 2004 08:39:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 09008-32 for ; Fri, 4 Jun 2004 08:39:18 -0500 (EST) Received: from smtp2.smith.com (smtp2.smith.com [63.149.135.12]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3973372C8AF for ; Fri, 4 Jun 2004 08:29:22 -0500 (EST) Received: from 172.20.30.245 by smtp2.smith.com with ESMTP ( (MMS v5.6.0 )); Fri, 04 Jun 2004 08:47:44 -0500 X-Server-Uuid: F15B3C06-5F8D-415B-84EC-40DC06D86B3E Received: from siihardyxch01.net.smith.com ([172.20.30.241]) by siihardyxch05.net.smith.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 4 Jun 2004 08:47:44 -0500 Received: from midhouhqxch01.net.smith.com ([172.20.80.213]) by siihardyxch01.net.smith.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 4 Jun 2004 08:51:49 -0500 content-class: urn:content-classes:message MIME-Version: 1.0 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 Subject: RE: AD_APPLIED_PATCHES Date: Fri, 4 Jun 2004 08:47:43 -0500 Message-ID: <7E0DB3A126BA9146AC30744E2B7E42451118E0@midhouhqxch01.net.smith.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: AD_APPLIED_PATCHES Thread-Index: AcRKNaoC280Dav61QbOhFczXaXXaAgAAHypw From: "Nelson, Allan" To: oracle-l@freelists.org X-OriginalArrivalTime: 04 Jun 2004 13:51:49.0093 (UTC) FILETIME=[151C7950:01C44A3B] X-WSS-ID: 6CDEA20A1JW1101724-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1983 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: anelson@miswaco.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org You are correct. APPLSYS is an Oracle Financials userid who owns all the AD stuff. In financials AD loosley corresponds to admininistrative functions. AD_APPLIED_PATHCHES in particular contains Oracle Financials patches applied to the application stack using the adpatch utility which updates that table. It does not include RDBMS patches. Just to be nitpicky and anal, if you use admerge and merge multiple patches into a single patch, AD_APPLIED_PATCHES does not magically tell you the content of your merged patches. You have to track that for yourself. You should report to your management that you have, as is far too often the case, an ignorant person running off a script that they don't understand. You will likely get generic auditor crap recommendations that will have something to do with your business only through coincidence. for your reference: desc applsys.ad_applied_patches Name Null? Type ----------------------------------------- -------- ---------------------------- APPLIED_PATCH_ID NOT NULL NUMBER RAPID_INSTALLED_FLAG VARCHAR2(1) PATCH_NAME NOT NULL VARCHAR2(120) PATCH_TYPE NOT NULL VARCHAR2(30) MAINT_PACK_LEVEL VARCHAR2(30) SOURCE_CODE NOT NULL VARCHAR2(3) CREATION_DATE NOT NULL DATE CREATED_BY NOT NULL NUMBER LAST_UPDATE_DATE NOT NULL DATE LAST_UPDATED_BY NOT NULL NUMBER IMPORTED_FLAG VARCHAR2(1) IMPORTED_FROM_DB VARCHAR2(30) IMPORTED_ID NUMBER -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mike Hennesy Sent: Friday, June 04, 2004 7:53 AM To: oracle-l@freelists.org Subject: AD_APPLIED_PATCHES I am running an Oracle 8.1.7.3 database and have an auditor who is requesting that I produce a listing of all the rows in the table APPLYSY.AD_APPLIED_PATCHES. The problem I have is that table doesn't exist. We do NOT have Oracle applications and I believe that this is a table that comes with Oracle Apps 11i. The auditor is insistent that the table should be there and is wondering what I'm trying to hide. If you can confirm this is an Oracle Apps table for me or let me know what I should run if it is just a script that I should have run that I missed. All replies will remain confidential; I'm just trying to verify my sanity. Thanks - Mike Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger ______________________________________________________________________________ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------