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.
