How to know 'Web ADI' Version in EBS?

You have two options to find the version of WebADI , if you do not want to get any help from DBA.

Option 1(a) Release 12

1. You need to logon in EBS
2. Once you get the Homepage, you need to paste the url in the same browser window.
   http://hostname:portnumber/OA_HTML/BneAdminServlet
3. You replace the hostname,domain and port number
4. Once you enter these details, An html/xml return page list out the 'Web ADI' versions.
5. Look for the attribute named "Bne Release Label".

Read the rest of this entry »

This is yet another extension of previous post, will discuss how to manage and define layout of the WebADI integrator.

Managing/Defining Layout

You can also manage /Define layouts, means you can build the spreadsheet by modifying the Layouts.

You must be in responsibility with access to the integrator to define the layout.

• Responsibility: Desk Integration
• Menu Options : Define Layout

Read the rest of this entry »

As mention in earlier post (#1,#2,#3 ) , WebAdi is tool that can be used to load many different types of data from spreadsheet based excel application into various application of Oracle APPS. There are number of Seeded Integrator comes with Oracle, but still Oracle provides the capability to its expandability. Various Integrators to load different types of information. However, you can do setups new, custom spreadsheet can be created to load different types of information into Oracle.

Basic User Procedure we have seen for a webADI is

1. Use the webADI page Consist of creating spreadsheet by
   1. Specific to data type which we called as integrator
   2. Specific to Layout which is for controlling purpose of the spreadsheet.
2. Adding Data to the excel Spreadsheet.
3. In spreadsheet, you need to select the Oracle/Upload menu option.This is menu option that you can use from WebAdi added from Excel menu.
4. Than the data get uploaded to Oracle target table, which might be custom, or base. Any error will be flagged and the error reason will be placed on corresponding row in the spreadsheet.

Read the rest of this entry »

In last two post we have seen , Web ADI is a Browser based application, which enables users to log into the Oracle database and upload ADI spreadsheets, without having the ADI application installed onto the users machine.We have already seen step by step setup in 11i , now this post is extension of previous post with a case of R12.

1. Responsibility: As mention earlier WebADI User linked to the correct Set of Books for your business. In R12 , the starting point would be responsibility called Desktop Integration

Read the rest of this entry »

Lets take about one of the great office productive tool based application which is called "Web ADI" that being used within the E-Business Suite to provide end-users with a familiar user interface.Key end users are highly accepted this productive tool , because of there own advantages and great office capability.

ADI & Web ADI...

ADI stands for Applications Desktop Integrator, and is an Excel based interface through which users can upload and view data in the Oracle system.To access the database, users must use their standard Oracle User name, and password.

Web ADI is a Browser based application, which enables users to log in to the Oracle Database, and upload ADI spreadsheets, without having to have the ADI application loaded locally on the users machine, or having it set up on a central server and users accessing it through Citrix.

For Web ADI to work, interfaces are set up. These interfaces are Macro driven spreadsheets, in which specific cells are linked to database table columns, and match to fields in the Standard Oracle Forms. Through them data is fed into the database, which can subsequently be viewed in the Core Oracle Forms.

• The leveraging of Desktop Application functionality for performing E-business Suite tasks.
• Web ADI is a java based tool used to load many different types of data from Excel into varied application modules.
• This tool resembles the client-server ADI in name only. It has no concurrent manager or publication functionality. It also requires no client code to be loaded on the PC.

The difference between ADI and WebADI

The main big between ADI and Web ADI, is that Web ADI is now based out of framework for building Desktop Integration applications in the EBS.That means we can designed and extend with a combination of meta-data and java. There is no requirement for these teams to know Visual Basic for Applications or the techstack requirements to get Office to interact with the Oracle Middle Tier or any of a hundred different nuances in the desktop environment.

Read the rest of this entry »