The Oracle WebADI brings all of the Oracle E-business Suite’s functionality to your desktop from where you can use familiar applications such as Microsoft Word, Excel, and Project. You can use each of the applications to complete specific tasks related to Oracle E-business. For instance, integrating WebADI with Excel allows the user to move the data from the Oracle E-business Suite Apps to a spreadsheet. The spreadsheet’s familiar data entry and modeling techniques through formatted spreadsheets allow you to view, edit, download, and create Oracle E-business data. You can either use data entry shortcuts or Excel formulas to improve productivity. Moreover, the validation functionality in the Oracle WebADI can validate the data before uploading it, while the validation messages allow you to correct any invalid data.

You can customize the fields with the Layout functionality. Using the features of WebADI enhances the work environment as it removes unwanted fields and organizes the spreadsheet to promote greater efficiency.

Features of Oracle WebADI

The key features available in Oracle WebADI include:

Works through Internet

By using Internet computing architecture, the Oracle WebADI cuts down the cost of ownership as the product is installed and maintained centrally. It doesn’t require client machines to work. Instead, a web browser and Microsoft Excel are all you need.

Spreadsheet Interface

Users are familiar with the Excel interface with all its myriad editing capabilities and can handle large volumes of data. It also enables recurring data entry that can be saved and uploaded when required. The additional flexibility of getting the data reviewed and approved is particularly useful even when working without the Internet.

Data validation

All data can be validated against descriptive flexfields and against accounts, cross-validation rules, and segment security rules. This functionality allows you to correct errors when error messages are returned to the spreadsheet before successfully uploading the data.

Customizable

The layout functionality is customizable and allows the user to determine the fields, their location, and if they have default values. These are also reusable or modified based on the user’s need.

Automatic data import

Oracle WebADI automatically imports data into the spreadsheets from the Oracle E-business suite or a text file. After the data import, it can be modified and validated before uploading it to the Oracle E-business Suite. Automatic data upload is particularly useful when migrating data from legacy systems.

How To Use Oracle WebADI

You can determine the integrator in the Oracle WebADI for each task performed in the Oracle E-business Suite. The seeded integrator provides the functionality for the specific product integrated with the desktop. You can also develop custom integrators using the Oracle E-business Suite’s desktop integration framework. Access to the Oracle WebADI functionality is made available through a self-service link on your home page.

How To Upload Data To Oracle E-business Suite

The process flow to upload data is preceded by the desktop integration responsibility. System administrators use the desktop integration responsibility to access:

  • Create documents
  • Define layouts
  • Setup necessary options
  • Define stylesheets
  • Manage the document links.

Through the desktop integration responsibility, System Administrators can edit the layouts and mappings for every integrator. And the end-user access depends on the individual products.

Process Flow to Upload Data

Oracle WebADI has a process flow that allows you to upload data to the Oracle E-business Suite. Here’s how:

  • Define the layout to determine the fields that you wish to see in your spreadsheet. A few layouts may be pre-defined for the spreadsheet, but you can verify if you need to define a different layout.
  • Define the mapping specification for data import to the spreadsheet. Again, a mapping may already be defined. The product-specific documentation can verify if a new mapping needs to be defined.
  • Create the spreadsheet that you will be working on
  • Upload the data to the Oracle E-business suite if the spreadsheet integration allows uploading.
  • The final step is monitoring the progress of the upload.

Make The Most of WebADI

Oracle WebADI brings the power of Excel to Oracle E-business Suite tasks. WebADI’s functionality depends on the information that is stored in the integrator. An integrator holds relevant information on downloads and uploads of data.

The end user can select an appropriate integrator when creating a word processing document or a spreadsheet and let the integrator validate and transfer the data accordingly.

End-user Access

Oracle WebADI is integrated with the Oracle E-business suite according to the product-specific business flow, and the end-user can access it based on specific product implementations.

Typically, Oracle WebADI runs in the background to generate a spreadsheet functionality within the functional page flow. Or the self-service menu invokes the WebADI’s Create Document page flow.

Benefits of WebADI

Simply put, WebADI connects Excel with Oracle applications and enables data uploading.

  • Minimal training required
  • Useful for large transactions
  • User-friendly
  • Increased productivity

Oracle WebADI enables productivity even when disconnected from the Internet. There are no session time-outs when you can download the template, work on it offline, and save it to upload later. Clearly, WebAdi, or web applications desktop integrator, is the ideal tool to leverage standard desktop applications to bring the Oracle E-business Suite to your desktop.

To Learn More about Oracle E-Business Suite(EBS) Apps

Abhijit Ramachandran