Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

No items, feed is empty.

WebAdi : Desktop Integration makes life easier

Posted on May 2nd, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

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.

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

adi evalaution

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

greyBarrow Benefits and advantages

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

  • Increase Productivity : with the great flexibility of Excel based application.
  • Reduce Training Costs : Hardly any required any training as just provide the template for ADI.
  • Improve User Acceptance
  • Work in Disconnected Environments : There is no issue like session out , where user feel frustrated.

greyBarrow Know the fact about Applications Desktop Integrator

  • The first version was General Ledger Data Interchange, GLDI, which was a GL specific tool that allowed the loading of journals and budgets from Excel.
  • GLDI was expanded into a client-server Application Data Interchange, ADI, product. This allowed the loading of some asset information from Excel as well and allowed for the submission and publishing of FSGs and standard reports into Excel, html and other formats.
  • In release 11i10 Released With Over 100 Solutions used by 18 different product applications where are in R12 there are more than 200 Solutions with addition of few more application in the list. You can see the list in separate section .
  • As mention above this based out of Enterprise Framework for Desktop Integration, that mean driven by Metadata Client Side Application Generator.
  • Zero Client Install in webADI simply reduces the total cost of ownership.
  • This can be utilize in the R12 theme ie Work Globally which significantly reduced Bandwidth Requirements to Client
  • The good is that most of processing is Performed on the Middle-Tier, will discuss in Architecture section.
  • You have also do some customization based out of your local business need, . You can do customization in term of Layouts changes as well as style Sheets changes.
  • You can implement and integrate this with office product like Excel, Word and Projects

greyBarrow Who owned the existing versions of ADI

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

  • Advanced Product Catalog
  • Assets
  • Financial Intelligence
  • General Ledger
  • Human Resources
  • Incentive Compensation
  • Internal Controls Manager
  • Projects
  • Public Sector Budgeting
  • Public Sector Financials International
  • Public Sector HR
  • Public Sector Payroll
  • Sales Offline
  • Student Systems
  • Territories
  • Trade Management
  • Training Administrator
  • Web Applications Desktop Integrator

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

  • Advanced Benefits
  • Application Report Generator
  • Financial Consolidation Hub
  • Financials Common Modules
  • Information Technology Audit
  • Learning Management
  • Marketing
  • Operations Intelligence
  • Payroll
  • Sales
  • Supply Chain Intelligence
  • Transfer Pricing

greyBarrow Some of existing ADI template

  • Journal Wizard – create GL – Journal entries which are uploaded and imported ready for posting.
  • Budget Wizard – download Budget data for an organization, adjust the values and then upload and import back to general ledger.
  • Report Wizard – Create and maintain FSG reports in a spreadsheet interface
  • Analysis Wizard – from a FSG report published to a spreadsheet, drill down on a value of interest to find the transactions that made up this value.
  • Create Assets – create Assets and upload them to Fixed Assets.
  • Record Physical Inventory – speed up your inventory process, by entering or importing text files for an inventory check into a spreadsheet, load and then initiate the concurrent programs to compare with the actual assets and generate a comparison report.

greyBarrow What is in the box:

The technology Stack of the WEB ADI is consist of

  • Client Side
    • Office 97 / 2000 / XP / 2003
  • Browser
    • Internet Explorer, Netscape, Firefox, Mozilla( All are certified
  • Oracle Application
    • Oracle Applications 11.5.3 or Later
  • Oracle SSFrame work
    • Oracle Self Service Framework Version 5.6E or Later
  • Oracle Application Server
    • Oracle 9iAS Release 1.0.2.2.2
  • Oracle Database
    • Oracle 8.1 Database or Later

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

Architecture

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

greyBarrow What is new in Release 12 Features of Web ADI

  • Its Support for all E-business Suite certified browsers , that mean you use Netscape, Mozilla and Firefox with all other self service applications.
  • Layout Definition Enhancements , this simply means further customize your spreadsheets & Formulas
  • Add extra logic to the spreadsheet
  • Security is greatly enhanced
  • Can manage large amounts of data
  • Can manage multiple Worksheets
  • Logically separate data for update, analysis, and distribution.
  • Larger Downloads (remove 64k limit)

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

Related Posts

Posted in Oracle General Ledger, Web ADI | 16 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
16 Responses
  1. David Haimes Says:

    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. 11i Uploading a Journal using Web ADI : Step by Step Says:

    […] 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. Krishnarao Says:

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

  4. Pandu Says:

    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. How to know Web ADI Version ? Says:

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

  6. Pointers to WebADI Information | The Triora Group Says:

    […] Anand’s OracleApps Epicenter website includes an excellent description of WebAdi in the post: http://www.oracleappshub.com/general-ledger/desktop-integration-makes-life-easier/ Also, OracleAppsBlog includes documentation of an architectural and functional comparison between […]

  7. Steve Warren Says:

    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. Sanjit Anand Says:

    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;
    http://www.oracleappshub.com/release12/r12/r12-report-manager-goes-user-friendly/

    You can check one of earlier post on reporting options in EBS.
    http://www.oracleappshub.com/oracle-application/is-reporting-a-separate-module-in-oracle-e-business-suite/

    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. Steve Warren Says:

    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. Manoj Says:

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

    can anubody suggest a solution?

    Thanks in advance

  11. Sanjit Anand Says:

    Manoj, R12 Asset WebADI is there

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

  12. Abhishek Says:

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

  13. Sanjit Anand Says:

    It difficult from front end but too easy from backend.

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

  14. Cornelia Says:

    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. Bonnie Owenby Says:

    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. Lalitha Subramanian Says:

    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

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.