Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ADI Warning

RE: ADI Warning

From: <hemantchitale_at_charteredsemi.com>
Date: Thu, 07 Feb 2002 21:01:54 -0800
Message-ID: <F001.004099D3.20020207203327@fatcity.com>

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 Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM
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: 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).

--

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 Lists

--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US