Just to add some more information on ADI.
ADI sets up ODBC to connect to the database. When you define the database connection in the ADI setup screens, you can't find the information saved anwhere in the files the ADI Home on the PC. Therefore you cannot copy this information from one PC to another -- you have to manually set-up the database connect on each PC. We have enabled Database Session Audit and I have found that when a user used ADI and Excel to do a Journal Import from Excel to Oracle GL for 48 Journal Lines, the client made 21 connections to the database as APPLYSPUB and 26 connections as APPS between 14:46:00 and 14:50:18 (in the space of 4 minutes). Just think -- 47 distinct database sessions (connect-disconnect-connect-disconnect....) from one client in 4 minutes (and only for 48 journal lines). The users are happy with ADI as it allows them to use Excel ;). I am not happy with the way it connects to the database -- quite expensive :< Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd DENNIS WILLIAMS <[EMAIL PROTECTED]> 07/02/2002 05:15 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L Bambi - Obviously you've gone in so deep you forgot how dumb some of us are. To stem a tide of questions "what the heck is ADI", here it is. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] ORACLE APPLICATIONS DESKTOP INTEGRATOR 11i OracleŽ ADI is a spreadsheet-based extension to Oracle Applications that offers full cycle accounting and asset management within the comfort and familiarity of a spreadsheet. ADI combines a spreadsheet's ease of use with the power of Oracle Applications to provide true desktop integration during every phase of the accounting cycle. You can create budgets, record transactions, add assets, reconcile inventory, define and publish reports from any application to the web, a spreadsheet, or standard text output, and you can even perform account drilldown and analysis-all without leaving the desktop. -----Original Message----- Sent: Wednesday, February 06, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Friends -- Lately I've been relegated to the deepest recesses of the dark murky depths of Oracle's product line. I see you blithely exchanging DBA mail and look on longingly, pining for the fjords, as it were. But I digress. If you every have to install ADI on a PC, make sure it doesn't have any Oracle products installed on it. Make sure there are no Oracle directories either in C: or in C:\Program Files. If you do, you will not be able to install ADI, and must deinstall all existing Oracle products before installing ADI, which, graciously, comes with SQL*Plus and SQL*Net. Everything else needs to be reinstalled. Oh, and that old TNSNAMES.ora file you have hanging around, it don't mean anything to ADI. I just can't fathom why Oracle would do this to itself. I hope its foot starts feeling better soon. Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
