| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: AD_APPLIED_PATCHES
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mike Hennesy
Sent: Friday, June 04, 2004 7:53 AM
To: oracle-l_at_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
 |
 |