Oracle Fusion Online Free Articles!!Technical

Oracle Web Adi : Explained step by step with diagrams and case study

What is Web Adi

What is web adiWeb Applications Desktop Integrator (WebADI) is a self-service Oracle application accessed using a browser. The WebADI software does not need to be installed on individual client machines. Processing takes place on the server rather than on individual client PCs. Web ADI generates Microsoft Excel or Word documents on your desktop, and uploads the data you have selected to upload. The appearance of the spreadsheet or word processing document is determined by configurable layouts. System administrators can restrict the fields that end users work within the spreadsheet, and can create different layouts for different users. Experienced users can also create their own layouts to include just the fields they need to work with.


Business Requirement (to understand web adi)

To create a sample Wed ADI let’s assume that we have a business requirement to enter the out of office (ooo) contact details for employee. This ooo contact detail is stored in Extra person information window.  Following are the three mandatory fields that need to be stored for an employee before going on leave.

  1. Personal Email address
  2. Personal Contact Number
  3. Return Date

Business Solution (web adi setup)

WEB ADINow we have a requirement in place the next steps would be to design a soloution for this using Wed ADI. Though there are different ways to achieve this (for example link the EIT to Self-Service) we are going to meet the requirement by Wed ADI.  Following are the basic steps to create a WED ADI to upload OOO contact details for employee.

Step 1 :  Compile the given sample package.

Code in the package is very simple and easy to understand. Using an api “hr_person_extra_info_api.create_person_extra_info” this makes entry into the EIT. Just make sure you have already create EIT to store OOO information for employee.


Step 2 :  Set the profile option “BNE Allow No Security Rule” to yes as given in the fig1.



Step 3 :  Select the responsibility “Desktop Integration”


Step 4 :  Click on “Create Document” link.


Step 5 : Following window will appear. Select Excel 2003 as viewer as shown in the fig.2



Step 6 :  Click on next. Following window will appear. Select “HR Integrator Setup” as an integrator. This is the integrator given by oracle to create any new integrator. As shown in the Fig.3.



Step 7 : Click on next. Following screen will appear.  Select “Integrator Setup” as a layout as shown in the fig.4.



Step 8 : Click on next. Select “None” as content as shown in the Fig.5.



Step 9 : Click on the next.  A review page will appear as shown in the Fig.6. Click on “Create Document



Step 10 :  Open the excel sheet that pops- up and then enter the details as follows in the excel sheet. And then click on upload, as given in the fig.7 below

» Please see the troubleshooting in case of any issue.

Metadata Type CREATE
Application Short Name PER
Integrator User Name XX – Out Of Office Contact Details
API Package Name  XX_AVI_OOO_CD
API Procedure Name Enter_OOO_CD
Interface User Name XX – Out Of Office Contact Details
Interface Parameter List Name XX – OOO Details



Step 11 : Select “Validate Before Upload ” and then click on the “Upload” in the next screen.

Step 12 : Once successfully uploaded you will get following confirmation. See fig.8



Step 13 : Now we need to define the layout.

Navigate to “Desktop Integration” » “Define Layout”. A screen will appear. Select the integrator “XX – Out Of Office Contact Details” we have just created as shown in the fig.9


Step 14:  Click on go and then click on define layout.


Step 15 : Enter the layout Name and layout Key as shown in the Fig.10



Step 16 : Click on continue and enter the details as shown in the Fig.11. And click on apply.


Step 17:  Now we need to create a function so that same can be accessed by responsibility.

Navigate to Application Developer à Application à Function and create a function with following details.

DescriptionPropertiesFormWeb HTML

Function : XX_AVI_OOO_CD

User Function name : Enter OOO Contact Details

Type : SSWA servlet function

Parameter : bne:page=BneCreateDoc&bne:viewer=BNE:EXCEL2003&bne:reporting=N&bne:integrator=USER_NAME:XX – Out Of Office Contact Details&bne:noreview=Yes


Step 18 :  Now attach this function to responsibility from where you want to access this.

Step 19 :  Now click on the function from the responsibility(where you have attached it).

Following screen will appear (Fig.12).



Step 20 : Click on next and enter the details as shown in the fig.13

and click on Add-Ins » Oracle » Upload.



Step 21 :  You will get following confirmation.


Step 22 : To make sure it has been entered in oracle (as extra information)

login to oracle » Select the employee Number 258837 (or the one you have entered) » Others » Extra Information » Select EIT “Out Of Office Contact Details”. You will get the information entered as given in the fig.15



Trouble shooting for Web ADI

Please resolve the following error to continue. You do not have permission to access this functionality

If you are getting this error while creating integrator please follow the below steps

  1. Goto System Administrator–>Application–>Menu and query for “DESKTOP INTEGRATION MENU
  2. for this menu add the function “HR Integrator Step

Unable to open excel sheet.

You might need to enable the Macros before performing the steps. You may perform this as your first step.

  1. Open an empty Excel sheet
  2. Click on Excel Option
  3. Click on trust center setting
  4. Click on macros setting
  5. Select the option “Enable all macros (not recommended; potentially dangerous code can run)” and “Trust access to the VBA project object model”

Read Web ADI Troubleshooting : Solve all excel related problems like “Run-time error 91″  for comprehensive knowledge on web ADI troubleshooting.

» You will also be interested to read second part on WEB ADI Oracle Web Adi : Explained step by step with diagrams and case study Part – 2

Show More

Related Articles

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker