It is a Oracle 11i table, and APPLSYS is an Oracle11i schema.
Your auditor needs to read the documentation for Oracle8i and Oracle
E-Business Suite 11i before he demands what you can 't possibly deliver... or
better yet, give him access to an id with select any table rights and have
him find it.
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@ >-- >-- >--
"Few people really enjoy the simple pleasure of flying a kite "
Adam Wells age 11
"Imagination is the highest kite one can fly. "
Lauren Bacall
-- --Original Message-- --
From: Mike Hennesy [mailto:orcl9ps8dba@(protected)]
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. <?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office " / >
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! <http://messenger.yahoo.com/ >
Messenger
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD >
<META HTTP-EQUIV= "Content-Type " CONTENT= "text/html; charset=iso-8859-1 " >
<META content= "MSHTML 5.00.3813.800 " name=GENERATOR > </HEAD >
<BODY >
<DIV > <FONT color=#0000ff face=Arial size=2 > <SPAN class=016311813-04062004 >It is
a Oracle 11i table, and APPLSYS is an Oracle11i
schema. </SPAN > </FONT > </DIV >
<DIV > <FONT color=#0000ff face=Arial size=2 > <SPAN
class=016311813-04062004 > </SPAN > </FONT > </DIV >
<DIV > <FONT color=#0000ff face=Arial size=2 > <SPAN class=016311813-04062004 >Your
auditor needs to read the documentation for Oracle8i and Oracle E-Business Suite
11i before he demands what you can 't possibly deliver... or better yet, give him
access to an id with select any table rights and have him find
it. </SPAN > </FONT > </DIV >
<DIV > </DIV >
<P > <FONT face= "Comic Sans MS " size=2 >April Wells </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Oracle DBA/Oracle Apps DBA </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Corporate Systems </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Amarillo Texas </FONT > <BR > <FONT
face= "Times New Roman " > </FONT > <FONT face= "Comic Sans MS "
size=2 >@>-->-->-- </FONT > <BR > <FONT face= "Comic Sans MS " size=2 >“Few
people really enjoy the simple pleasure of flying a kite” </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 >Adam Wells age 11 </FONT > <BR > <FONT
face= "Comic Sans MS " size=2 > "Imagination is the highest kite one can
fly. " </FONT > <BR > <FONT face= "Comic Sans MS " size=2 >Lauren Bacall </FONT > </P >
<BLOCKQUOTE >
<DIV align=left class=OutlookMessageHeader dir=ltr > <FONT face=Tahoma
size=2 >-- --Original Message-- -- <BR > <B >From: </B > Mike Hennesy
[mailto:orcl9ps8dba@(protected)] <BR > <B >Sent: </B > Friday, June 04, 2004 7:53
AM <BR > <B >To: </B > oracle-l@(protected) <BR > <B >Subject: </B >
AD_APPLIED_PATCHES <BR > <BR > </DIV > </FONT >
<P > <SPAN
style= "COLOR: black; FONT-FAMILY: Courier; FONT-SIZE: 10pt; mso-bidi-font-family: Courier " >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. </SPAN > <SPAN
style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " > <?xml:namespace prefix = o ns =
"urn:schemas-microsoft-com:office:office " / > <o:p > </o:p > </SPAN > </P >
<P > <SPAN
style= "COLOR: black; FONT-FAMILY: Courier; FONT-SIZE: 10pt; mso-bidi-font-family: Courier " >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. </SPAN > <SPAN
style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " > <o:p > </o:p > </SPAN > </P >
<P > <SPAN
style= "COLOR: black; FONT-FAMILY: Courier; FONT-SIZE: 10pt; mso-bidi-font-family: Courier " >All
replies will remain confidential; I 'm just trying to verify my
sanity. </SPAN > <SPAN
style= "FONT-FAMILY: Arial; FONT-SIZE: 10pt " > <o:p > </o:p > </SPAN > </P >
<P >Thanks - Mike </P >
<P >
<HR SIZE=1 >
<FONT face=arial size=-1 >Do you Yahoo!? <BR >Friends. Fun. <A
href= "http://messenger.yahoo.com/ " >Try the all-new Yahoo!
Messenger </A > </FONT > </BLOCKQUOTE > </BODY > </HTML >
<table > <tr > <td bgcolor=#ffffff > <font color=#000000 >The information contained in this communication, <br >including attachments, is strictly confidential <br >and for the intended use of the addressee only; <br >it may also contain proprietary, price sensitive, <br >or legally privileged information. Notice is hereby <br >given that any disclosure, distribution, dissemination, <br >use, or copying of the information by anyone other <br >than the intended recipient is strictly prohibited <br >and may be illegal. If you have received this communication <br >in error, please notify the sender immediately by <br >reply e-mail, delete this communication, and destroy <br >all copies. <br > <br >Corporate Systems, Inc. has taken reasonable precautions <br >to ensure that any attachment to this e-mail has been <br >swept for viruses. We specifically disclaim all liability <br >and will accept no responsibility for damage sustained <br >as a result of software viruses and advise you to carry <br >out your
own virus checks before opening any attachment. <br > </font > </td > </tr > </table >
