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@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of Mike Hennesy
Sent: Friday, June 04, 2004 7:53 AM
To: oracle-l@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
