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@xxxxxxxxx] Sent: Friday, June 04, 2004 7:53 AM To: oracle-l@xxxxxxxxxxxxx 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.