Oracle Web ADI

WEB ADI  (Web Applications Desktop Integrator)

The Web ADI integration with Microsoft Excel enables you to bring your E-Business Suite data to a spreadsheet where familiar data entry and modeling techniques can be used to complete Oracle E-Business Suite tasks. You can create formatted spreadsheets on your desktop that allow you to download, view, edit, and create Oracle E-Business Suite data. Use data entry shortcuts (such as copying and pasting or dragging and dropping ranges of cells) or Excel formulas to calculate amounts to save time. You can combine speed and accuracy by invoking lists of values for fields within the spreadsheet.

 After editing the spreadsheet, you can use Web ADI's validation functionality to validate the data before uploading it to the Oracle E-Business Suite. Validation messages are returned to the spreadsheet, allowing you to identify and correct invalid data.

Key Features :

• Works Via Internet
• Presents E-Business Suite Data in a Spreadsheet Interface
• Validates Data
• Enables Customizations
• Automatically Imports Data

Changing Macro Security Settings for Excel 2002 or 2003 :

For Web ADI to work with Microsoft Excel 2002/2003, you must change the macro settings for Excel 2002/2003. To do so: 

1. In Excel, from the Tools menu, select Macro, then Security, then Security Level.

2. Select the "Medium" option. 

3. Select the Trusted Sources tab. 

4. Select the "Trust access to Visual Basic Project" option. 

Click on the Lanch Journal Wizard

From General Ledger Responsibility

Select the Parameters for WEB ADI as below and Click on Create Document

You can select 

Below screen will appear…

For Office 2010 Press the “SAVE” Button to save the document.

And document will save.

Click “Open” to open the WEB ADI file.

The WEB ADI File will open.  Close the Front screen by clicking “close” Button.

Enter the data by double clicking the WEBADI Excell file. And enter the data as mentioned below.

• ·         Enter Ledger
• ·         Enter Category
• ·         Enter Source as “Spread Sheet”
• ·         Enter currency
• ·         Enter Accounting date
• ·         Enter Code Combination ..One segment on one Column
• ·         Enter Debit Amount
• ·         Enter Credit Amount

If some rows required to add or delete from the spread sheet, first un protect sheet by clicking unprotected sheet option.

After un protecting sheet rows are deleted as below.

After entering the data in the spreadsheet, Click on Add-Ins button as highlighted below.

Click on Oracle 

Press Upload Button to upload the Journal.

Selec the parameter for uploading as below.

·         Select Flagged Rows .. “ All Rows can also be selected”

·         Check the box “ Validate Before Upload”

·         Check the Box “Automatically Submit jounal Import”

·         Check the option for “Do Not Import” Upload unbalance Journals

Press Upload Button to upload the Journal.

Journal will upload and show the following message.

To view the uploaded Journal click on “ Journal” in Genernal Ledger responsibility.