| 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: ADI Warning
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 <DWILLIAMS_at_LIFETOUCH.COM> 07/02/2002 05:15 AM Sent by: root_at_fatcity.com
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.
dwilliams_at_lifetouch.com
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: BBellows_at_usg.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: hemantchitale_at_charteredsemi.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (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). Received on Thu Feb 07 2002 - 23:01:54 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |