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.
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.
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
Who owned the existing versions of ADI
As per Oracle documentation,Initially webADI are limited to 18 products as listed below:
Advanced Product Catalog
- Financial Intelligence
- General Ledger
- Human Resources
- Incentive Compensation
- Internal Controls Manager
- Public Sector Budgeting
- Public Sector Financials International
- Public Sector HR
- Public Sector Payroll
- Sales Offline
- Student Systems
- 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
- Operations Intelligence
- Supply Chain Intelligence
- Transfer Pricing
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.
What is in the box:
The technology Stack of the WEB ADI is consist of
- Client Side
- Office 97 / 2000 / XP / 2003
- 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 188.8.131.52.2
- Oracle Database
- Oracle 8.1 Database or Later
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
- 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.