Oracle WebADI Setup in EBS R12

Oracle Web Application Desktop Integrator (Web ADI) is Oracle E-Business Suite's solution for integrating E-Business Suite applications with desktop applications such as Microsoft Excel, Word and Projects.Following are the steps to create custom integrator in R12

Creation of the custom integrator

Custom integrator will be used to upload the excel values into database tables.
For Example the user wants to upload the data from an excel sheet with a formatted way, and when it uploads, the data should be validated and should be returned back if any error occurs or data should do some other calculation with other tables, that can be done.
The template excel can have defaulted values, LOV values and POPList values to select the values.
Once we have the custom integrator we can define as a function and assign to the FND_USER

Steps to create the custom integrator.
Step 1.Create the Integrator

Step 2.Create the Interface

Step 3.Create the Layout

Step 4.Create Lov Columns

  

These steps mentioned above will be done by System Administrator

Step 5. Change the excel column prompts, by default the column headers will come as Database column name

Set the following profiles at site level

1. BNE Allow No Security Rule – Yes
2. BNE Allow Set Parameters – Yes

IE Setup for  WEBADI

1. Launch IE,Select Tools->Internet Options->Security->Internet->Custom Level
2. Enable scripting for all options

 Microsoft Excel Setup

1. Launch Microsoft Excel and select File->Excel Options
2. Enable “Show developer Tab in the Ribbon"
3. Select Developer Tab and click on Macro Security 
4. Select “Enable all Macros”  and “Trust Access to VBA Project Object Model” and Click OK.