- OracleApps Epicenter - http://www.oracleappshub.com -

WebAdi : Desktop Integration makes life easier

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 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.

Benefits and advantages

Using this desktop Integration , life is much easier for data operator and accounts executives and this will being following benfits:

Know the fact about Applications Desktop Integrator

Who owned the existing versions of ADI

As per Oracle documentation,Initially webADI are limited to 18 products as listed below:

R12 few more products are using along with the above lists(Adopted Oracle Documentation)

Some of existing ADI template

What is in the box:

The technology Stack of the WEB ADI is consist of

Architecture

The base of the architecture is the Browser or Desktop Application making and receiving calls through the HTTP Server to one of five Services. These services then make calls to the Database tier or to a product team’s java through the java extensibility. The database tier is where the Web ADI Meta Data repository is stored.

Lets follow a typical user flow(adopted)

The user is signed into Oracle Applications in the browser. They click on a link that calls the Application Service showing all or part of the Create Document Page Flow that we saw earlier. Once all of the required information for generating a Desktop Application document has been supplied the Application Service calls off to the Document Service to start the creation process. A document is transferred to the desktop opening the desktop application. Once generation is complete a call may be made to the Download service to retrieve any data that will be displayed in the document.

Once in the document, the user can start working with the data. Performing Data Entry, referencing too and from other documents. Where a List of Values has been enabled, calls are made to the component service to display and return data. The download service can be called again to refresh the data. When ready, the Upload service is called, passing the upload parameters and the data from the sheet encoded in an XML document, where it is processed, validated and uploaded into the database.

What is new in Release 12 Features of Web ADI

Will take some more thoughts on WebADI and ADI related to EBS.

16 Comments (Open | Close)

16 Comments To "WebAdi : Desktop Integration makes life easier"

#1 Comment By David Haimes On May 3, 2008 @ 12:13 am

This is a very popular feature, people like working in Excel and it is good that more and mre products allow people to do that

Financials Common Modules(FUN) integration is AGIS Mnual transaction upload – this is a new feature in R12.

AGIS is part of the FUN product (Financials Common modules)

#2 Pingback By 11i Uploading a Journal using Web ADI : Step by Step On May 6, 2008 @ 4:15 am

[…] Uploading a Journal using Web ADI : Step by StepR12 Oracle Subledger Accounting :Oracle White PaperWebAdi : Desktop Integration makes life easierOracle should do something for ‘Stale cheque ‘ …in newer versionsGet use of […]

#3 Comment By Krishnarao On June 17, 2008 @ 6:44 pm

Using Web ADI custom Integrators how do I submit a concurrent job after all the data from the excel is loaded?

#4 Comment By Pandu On June 22, 2008 @ 10:14 pm

Hi all,
I am not able to configure ADI on my local computer. Can anybody give me step by step process of configuring it to computer ( I have already installed it)

Regards
Pandu

#5 Pingback By How to know Web ADI Version ? On July 17, 2008 @ 2:59 am

[…] WebAdi : Desktop Integration makes life easier […]

#6 Pingback By Pointers to WebADI Information | The Triora Group On October 3, 2008 @ 5:55 am

[…] Anand’s OracleApps Epicenter website includes an excellent description of WebAdi in the post: [1] Also, OracleAppsBlog includes documentation of an architectural and functional comparison between […]

#7 Comment By Steve Warren On October 22, 2008 @ 9:05 am

We’re looking at moving to an Oracle GL – sounds like Web ABI allows us to load data into GL using excel templates, but what should we use to extract and analysis data, I heard that the predessor to WebADI gave us this functionality. Anyone have any comments / experiences ?

#8 Comment By Sanjit Anand On October 23, 2008 @ 7:38 am

Hi Steve ,

WEbADI is used to get use of Office product to key-in data in Oracle, with help of some seeded integrator or custom integrator.

Web ADI is simply replacing data key-in process which can be used by Oracle Forms, which requires some mandatory columns in some cases user have to fill.

WEBADI does not give you any functionality for extract and analysis data(Expect FSG). For extract you can use adhoc query in form of reports and use report manager for publishing need to respective business community.

Similar is true for your analysis ,which is again based out of your adhoc query tighten with Report manager , but the entire reporting need is driven by query embeded in Reports.

If you are looking for additinal product with office product, I must advice use GLWAND which you can use for your financial reporting need.

Adhoc query driven reports tighten with report manager is one of the good options , which required some skill from technical side if business need is changing frequently.

In Financial side there was something called Analysis Wizard mostly for FSG analyis which can be used , none of my client have ever used so i am afraid I cann’t comment on this.

IF you are using R12 , the same is fine tuned by Drill Down funcationality , which you can use this funcationlity.Here is some note;
[2]

You can check one of earlier post on reporting options in EBS.
[3]

Do you have any additional requirement , throw some light would like to share some of pros and cons based out of my past engagement experince.

thanks
sanjit

#9 Comment By Steve Warren On October 27, 2008 @ 9:33 am

Thanks Sanjit, I appreciate your feedback. Our current GL has a really powerful excel looking front end which allos users to both upload into GL and extract and drill down to transaction level. If we move to Oracle GL then users will expect as a minimum not to lose any functionality. Thanks Steve

#10 Comment By Manoj On November 4, 2008 @ 12:18 am

Hi
Fixed asset is not visible in desktop integrator in R12.

can anubody suggest a solution?

Thanks in advance

#11 Comment By Sanjit Anand On November 5, 2008 @ 8:43 pm

Manoj, R12 Asset WebADI is there

try at
Asset Super User -> Mass Additions -> Additions Integrator

#12 Comment By Abhishek On March 23, 2009 @ 10:38 pm

is there any way to check all the journal status uploaded by a single user?

#13 Comment By Sanjit Anand On April 27, 2009 @ 1:12 am

It difficult from front end but too easy from backend.

if you have requirement from backend, just query with created_by .

#14 Comment By Cornelia On October 13, 2009 @ 7:29 am

I have a question on the validation of macro’s in R12.

Are there any validation build into the macros before uploading it into the GL? my experience with the older versions are that the import fails and then you have to correct the account combinations and then re-try

Thanks

#15 Comment By Bonnie Owenby On September 14, 2010 @ 1:47 pm

Can a custom integrator be used as you describe to load GL_INTERFACE to many sob’s with one upload? In other words, can SET_OF_BOOKS be set at the line level using a custom integrator in rel 11.5.10.2 web adi 8.4.1.38?

#16 Comment By Lalitha Subramanian On November 17, 2010 @ 3:28 pm

Hello everyone,

We are currently implementing Oracle Public Sector Budgeting and we did some analysis on PSB and Excel Interface option.. Since more than 180 users needs to be created by our dba and needs to be maintained by them they raised a question stating that why can’t we use Web ADI instead. When i looked at oracle webadi user guide and implementation guide it didn’t say what are all the module we can use it but your forum gives the list of applications which includes Public sector budgeting.. Is there a way can you give us some information on how to do the setups please..

Thanks in advance
Lalitha