Tag Archives: ADI

Running Custom Reports in ADI 7.3

This documents the process of running a custom report in ADI.

Step 1:        Log on to ADI (ILLUMINAT/******@TEST)

Step 2:        Submit Ledger Process > Report

Step 3:        Existing Report: MGFL%

Step 4:        “MGFL Unaudited Revenue Stmt”

Step 5:        Period: MAR-06

Step 6:        Click Publishing Button

Step 7:        Spreadsheet, New Workbook

Step 8:        Publish To:

Step 9:        Report Type: Financial Statement

Step 10:   Green button: Submit and Clear the Form

Step 11:    Then click Publish Report

Setting Up Oracle Applications Desktop Integrator (ADI) 7.2

This documentation covers locating the latest version of ADI on Metalink, downloading it, installing it on the client machine and configuring it to access an Oracle Applications instance.

Step 1:        Log on to Oracle Metalink using your logon information (email address and password).

Step 2:        Search for and read “Application Desktop Integrator (ADI) – FAQ” (Doc ID: Note:106667.1) to obtain instructions to download the latest version of ADI.

(Adapted from the FAQ):

QUESTION: Where can I download ADI from?

Download ADI from Metalink

Log on to http://metalink.oracle.com
Click the Patches & Updates tab.
On the Patches & Updates page, click Advanced Search.
Enter:
Product or Product Family: Click the Torchlight icon to search for Applications Desktop Integrator (adi).
Release: ADI 7.2
Platform or Language: Microsoft Windows (32-bit) Client
Patch Type: Any
Press Go and the 7.2 base release will be available for download.

Step 3:        The results of the search are returned at the bottom of the page.

Click the link ‘3966101’ to locate the patchset.

Step 4:        You may be required to enter a username and password to access the file. Enter the email address and password that you used to log onto Metalink.

Step 5:        Details about the patchset are displayed on screen.

Click Download to begin downloading the file. Note that the download size is 71MB.

Step 6:        Click Save in the File Download dialog box, and then choose a location to save the file.

Step 7:        After downloading, execute the patchset by double-clicking on it.

Step 8:        Enter a location to unzip the files to, and then click Unzip.

Step 9:        Ensure that all files were unzipped correctly (you should see ‘5179 file(s) unzipped successfully’), and then click Ok.

Then click Close to close the WinZip Self-Extractor program.

Step 10:   In the folder that ADI was unzipped to, read the README.TXT file. It points the user to the ADI Installation Guide (ADI.PDF), which should be read before proceeding.

Step 11:    After reading the installation guide, double-click Setupadi.exe to begin installation.

Caution: Remove headphones while installing this product since it uses a lot of extremely annoying sound effects.

Step 12:   The Oracle ADI Installer loads.

Click Oracle Applications Desktop Integrator for Excel 2000/XP/2003.

Step 13:   Click Yes to begin installation.

Step 14:   The Oracle Installer Settings form is displayed. In the Company Name field, enter the name of the company. Then click Ok.

Step 15:   The Software Asset Manager appears.

Install all of the products listed under Available Products. The products can be installed individually (one at a time), or all products can be selected and installed.

Note: The ADI Online Help will require you to choose a language to install.

Step 16:   After installing the products, click Exit to exit the installer. You will be required to reboot the machine after exiting the installer.

Step 17:   After the computer restarts, load Applications Desktop Integrator by clicking on the Start button, All Programs, Oracle ADI, and finally Applications Desktop Integrator.

Note: Let the client log on to the machine so that you can configure ADI under the user’s id. This is necessary since signon details are not shared between users.

Step 18:   When the application is first loaded, a message appears informing the user to select an Applications database.

Step 19:   After reading the message by the Office Assistant, click on the Signon button.

Step 20:   The Signon form appears. Since there are no predefined databases, click Define Databases to define a new Applications database.

Step 21:   The Select Database form appears. Click Add to add a database.

Step 22:   Fill out the fields in the Add Database Details form, and then click OK.

Copy sqlnet.ora and tnsnames.ora from the “806 NET80” directory in the Project Folder to c:orantnet80admin and c:orantnetworkadmin. Note that these files contain configuration information for the production instance only.

In addition, each instance has a unique server ID. To obtain the server ID for the production instance, navigate to the Project Folder, and then open the file “Server ID.txt”. Copy the hexadecimal string under MFGP and paste it into the Server ID field in the Add Database Details form.

Step 23:   After setting up the database details, save the information and log on to ADI using an Oracle Applications username:

After logging on, perform the following:

  • Choose a Responsibility (for example, GL Super User)
  • From the ADI Toolbar, click Submit Report
  • Click Financial Statement
  • Click in the Report Name, enter % as criteria, click OK and then select a report (for example, Unaudited Balance Sheet)
  • Choose Period (for example, APR-07)
  • Click the Publishing button
  • Select Spreadsheet
  • Click Submit

The job is submitted and completes within a few minutes. It will automatically open in Excel on completion.

Errors Encountered

Error Message: “No Listener”

Solution: Either instance on server does not exist or entry in TNSNAMES.ORA is incorrect. If TNS entry in the local TNSNAMES.ORA file is correct, then listener or database is not started on the server.

Error Message: “ORA-12571: TNS Packet Writer Failure”

Solution: Cannot send packets to the server. A firewall is blocking packets on the client machine.

Error Message: “ORA-12154: TNS: could not resolve service name”

Solution: Ensure that the service name is in c:orantnet80admintnsnames.ora

Check that c:orantnet80adminsqlnet.ora has names.default_domain and name.default_zone commented off.

Check %WINDIR%system32driversetchosts file has hostname and ip address.

Error Message: “An error occurred while attempting to establish an Applications File Server connection. There may be a network configuration problem, or the TNS listener may not be running. Nodename : ORACLESRV”

Solution: Incorrect FNDFS entry is in the TNSNAMES.ORA file. Recopy sqlnet.ora and tnsnames.ora from server onto client machine.

Metalink References

Subject: Tns Packet Writer Failure When Trying To Connect To ADI Ora-12571 (Doc ID: Note:264952.1)

Subject: Unable To Start ADI ORA-12571:TNS:Packet Writer Failure (Doc ID: Note:351088.1)

Subject: Troubleshooting the “Error Occurred While Attempting to Establish an Applications File Server Connection” (Doc ID:  Note:117012.1)

[amazon asin=0071779728&template=iframe image&chan=default]     [amazon asin=1849680620&template=iframe image&chan=default]     [amazon asin=0071622292&template=iframe image&chan=default]

Excel Not Launching Properly from Web ADI

Problem: When Web ADI launches Microsoft Excel, the output Excel spreadsheet does not run.

Solution: This problem seems to be occurring only in Microsoft Excel 2003. In Excel 2003, Enable Trust VB Projects.

Step 1:        After launching Excel 2003, navigate to Tools > Options.

Step 2:        Click the Security tab.

Step 3:        Click the Macro Security button.

Step 4:        Click the Trusted Publishers tab.

Step 5:        Ensure that Trust access to Visual Basic project is checked.

Step 6:        Click OK to exit the option. Click OK again.

Refer to Metalink Doc ID:  Note: 106528.1 (Subject:  Application Desktop Integrator – Product Documentation)

Refer to Metalink Doc ID:  Note: 376976.1 (Subject:  WEB ADI “Run-Time Error ‘50290’ Method ‘Run’ Of Object ‘_application Failed”)

Refer to Metalink Doc ID:  Note: 295901.1 (Subject:  No Excel File Created When Using Excel 2002; Excel 2002 Does Not Appear In Viewers LOV)

See also http://support.microsoft.com/default.aspx?scid=kb;en-us;282033

Installing Web ADI

This documentation covers how to install Web ADI. To download Web ADI, refer to Metalink Doc ID: 230801.1.

Step 1:        Log on to Metalink and click on the Patches & Updates.

Step 2:        Click on Advanced Search.

Step 3:        Search by Product of Product Family for ‘Web’. ‘Web Applications Desktop Integrator (bne)’ appears.

Step 4:        View readme of the latest BNE patchset (11i.BNE.D). See also Note ID 287080.1.

Step 5:        The latest patchset is 3218526, about 8.4MB. Download it.

Setting up TNSNAMES.ORA for ADI

In Oracle Applications 11.5.10, there is a security feature which prevents users from logging on to the database using SQL tools such as SQL*Plus or TOAD. Refer to Note: 291897.1 (11.5.10 New Features: Managed SQL*Net Access from Hosts) for information on resolving this problem.

To get information pertaining to the host, log on to Oracle Applications Manager, click on Site Map, Administration, and then Hosts. Click the Show link to see the host name, domain and IP address. To determine the port numbers associated with the instance, click View Configuration.

All information is available to place entries into the TNSNAMES.ORA.

NEWTEST = (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESERVER.company.local)(PORT=1521))
                (CONNECT_DATA=(SID=PROD))
            )
FNDFS_ORACLESERVER=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=ORACLESERVER.company.local)(PORT=1626))
            (CONNECT_DATA=
                (SID=FNDFS)
            )
        )

Finding Server ID for ADI

This documentation shows how to get the server ID string for the machine.

Navigate to the following directory:

%APPL_TOP%fnd11.5.0secure<SID>_<nodename>

e.g.

cd D:TESTTestapplfnd11.5.0secureTEST_oraclesrv

Open the <SID>.dbc (TEST.dbc) file using Notepad and you should see a line:

APPL_SERVER_ID=FE15648D7571C5C9E030005A1B00247727514667901730551185199646909747