WebAdi in Oracle apps

WEBAdi :

Web Applications Desktop Integrator is a tool that leverages the standard desktop applications to perform some of the Oracle E-Business Suite task. The Web ADI brings Oracle E-Business suite to the desktop where familiar desktop tool like Excel can be used to create spreadsheet, enter and modify data in the spreadsheet and finally upload the data into the Oracle Applications. Web ADI can be very useful for the users who are experienced with Excel and will like to use Excel to enter the data related to Oracle Applications. These users can use the special features of excel i.e. copy, paste, drag cells to increment and various arithmetic functions to optimize their business task and increase their productivity.

Web Application Desktop Integrator or Web ADI is a tool that brings Oracle E-Business Suite functionality to a spreadsheet, where familiar data entry and modeling techniques can be used to complete Oracle E-Business Suite tasks.

It is one of oracle's tool which connects Oracle Apps with Excel. Helps in uploading of Journal data etc. through excel. You can also create custom WEB ADI and write a custom procedure to do Data Migration through excel into temporary tables through WEB ADI.

You can create your own layouts and even create your own integrator through assigning WEBAdi responsibility.

Why to use WebAdi :

• Increase Productivity
• Minimal Training
• Useful in Large transactions
• Improved user acceptance

Setting in Excel for WebAdi :

For Excel Macro Setting please follow below given steps.

1. Go to Arrow above in excel file and click on “More commands” , Please refer below given screenshot.

2.  It will open Excel Option window

3. Kindly click on Trust Center in Excel Option and then click on Trust Center Setting Button

4.  In This Select Macros Setting Option :

Select "Disable all Macros with notification" .

And in Developer Macro setting select "Trust access to the VBA project Object Model"



WEB Browser Settings for WebAdi :

Go to Internet Explorer Web browser

Tool -> Internet Options

2. Click on Security Tab and then click on Custom Level

3. In this Enabled option for "Allow status bar updates via script"



3. Click on OK , It will show you warning message Click 'Yes' to change setting.

By using above two setup now we can use WebAdi functionality in Oracle apps.

Navigation :

GL SuperUser Responsibility -> Journals -> Launch Journal Wizards

Enter You Layout Name for which you want to upload data.

• Budgets - Multiple
• Budgets - Single
• Foreign Actual - Multiple
• Foreign Actual - Single
• Functional Actual - Multiple
• Functional Actual - Single
• The options are therefore:
• Functional or Foreign currency
  • Actual or Budget Balances
  • Multiple or Single spreadsheet

Click on Create Documents

Enter data in opened Excel sheet  Like given Below

e.g.

Balance Type  : Actual Or Budget

Database :  XXVIS12

Data Access Set : XX_PL

Chart of Account : XX_COA

Ledger : XX_Ledger_name

Category : Billed Unearned

Source : XX_Financial

Currency : USD

Account Date: 15-07-2015

Journal : Unearned Revenue

Journal : Standard

In Line details enter code combinations, debit amount  Credit amount and Line description and Journal Type as Standard.

Once you upload this by it will show you :-) smiley infront of successfull uploaded lines. Please see below given screenshot.

After this posting, you can view the transaction in General Ledger by running program for Trial Balance by passing segment value for account or company.