Installation and Configuration of Applications Desktop Integrator (ADI)

What is ADI ?

      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. Oracle ADI combines a spreadsheet’s ease of use with the power of Oracle Applications, to provide true desktop integration during every phase of your accounting cycle. You can create budgets, record transactions, add assets, reconcile inventory, and run financial statements and inventory reports all without leaving your spreadsheet.
      You can run Oracle ADI as a stand-alone application, without installing the full client version of Oracle General Ledger (GL) or Oracle Assets on your PC. This gives you the ability to confirm and reconcile inventory, revise budgets, create journal entries, and define financial and asset reports from any location, without being connected to your server. You only need to connect when you want to transfer data to or from Oracle Applications.

How to install and configure ADI ?

      In this paper, I am going to focus on installing ADI to the 32-bit Windows XP environment. Since nearly all end-users use Windows XP operating systems, I think this will be useful.Addtionally, I will force the program to work with Turkish characters. All configurations are same for all extra languages. The only thing you should know is the character set of your language.

(*) If you are using only English, you do not have to additional character set configurations.

Steps to install Oracle ADI Software

1- First of all; you should download the latest base release of ADI software and the last patch-set. At the moment, the last base release of ADI is 7.2 (metalink patch number: 3966101) and the last update is ADI 7.2 ROLLUP 11 (metalink patch number: 7286213).

2- All installation processes have to be performed by a priviledged user such as local administrator and at least Excel has to be installed to the computer.

3- After downloading the right software for your environment, extract first the base release on a folder and run Setupadi.exe.

4- Select Oracle Applications Desktop Integrator for Excel 2000/XP/2003 (It works for Excel 2007 as well) and confirm by pressing Yes.

5- Type your Company Name(eg. oracle), Name (eg. oracle), Location (eg. C:\ADI) and select English as the language. Press Ok.

6- In the Software Asset Manager screen, select all the products available on the left side. Press Install.

    ADI Online Help (HTML Format) 7.2.0.09.12

    +Applications Desktop Integrator Products 7.2.0.09.12

    Oracle Installer

    +Optional Components Install

7- Confim the Information message box by pressing Yes and select English(United States) as the language. Press Ok.

8- Select All the optional components from the list. Press Ok twice.

    Oracle Net8 Client 8.0.6.0.0

    Oracle Objects for OLE - Runtime 8.0.6.3.9

    Oracle Trace Collection Services 7.3.4.0.0

    Oracle Trace Collection Services 8.0.6.0.0

    Required Support Files 8.0.6.0.0

    Required Support Files 7.3.4.1.1

    SQL*Net Client 2.3.4.0.2

9- On the ADI Online Help screen press Next and Finish.

10- First part of the installation is finished. Verify the installed programs on the right side, press Exit and restart the computer manually.

11- Extract the ROLLUP patch to a folder and select Oracle Intaller from Start>Programs>Oracle for Windows NT

12- Press the From button and select NT.PRD file from the rollup extracted folder.

13- Select Applications Desktop Integrator Products 7.2.11.07.29 from Available products pane and press Install button. After installation, press Exit and restart the computer.

Steps to configure Oracle ADI Software

1- Copy tnsnamer.ora and sqlnet.ora from the database server to the ADI client under C:\ADI\NET80\ADMIN and C:\ADI\NETWORK\ADMIN

2- Open ADI from Start>Programs>Oracle ADI>Applications Desktop Integrator. An alter will prompt to define a database. Pres Ok.

3- Press Signon>Define Databases>Add button.

4- Type _database as name, APPLSYSPUB/PUB as GWYUID, APPS as FNDNAM and database tns name for connect string which is in thetnsnames.ora file.

5- Click Ok twice and enter the credentials to test the connectivity.

Steps to configure the regional language settings

1- When you enter the program, if you use non-English characters in entries, you will have some difficulties to understand the words.

2- Type Regedit to Run command and go [HKLM\SOFTWARE\ORACLE\NLS_LANG] expandable string value and change to the appropriate character set value. Try your database character set. You also have to change the language for non-Unicode programs appropriately.

3- Restart the computer.

Now, the ADI software has to be ready.

Congratulations.