Oracle Web ADI: Creating a Custom Integrator

Just to give you a quick overview of Oracle Web ADI(Oracle Web Application Desktop Integrator), it brings E-business suite functionality to desktop where familiar Microsoft, Excel, Word and Project applications that can be used to complete your Oracle E-Business Suite tasks.

The Oracle Web Applications Desktop Integrator integration with Microsoft Excel enables you to bring your Oracle E-Business Suite data to a spreadsheet where familiar data entry and modeling techniques can be used to complete Oracle E-Business Suite tasks. You can create formatted spreadsheets on your desktop that allow you to download, view, edit, and create Oracle E-Business Suite data. Use data entry shortcuts (such as copying and pasting or dragging and dropping ranges of cells) or Excel formulas to calculate amounts to save time.

Here in this topic I will give some quick steps to create a Custom Integrator:

Firstly, with Web ADI you get the following 2 Standard responsibilities:

1. Desktop Integration Manager

2. Desktop Integrator

 

Desktop Integration manager involves creating/Managing Integrators and parameters

Desktop Integrator lets you create Document, layout, Mapping, Setup options etc.,

Now to create a Custom integrator you need to,

a. Create an integrator
b. Create a Layout

Desktop Integration Manager - > Create Integrator

Define the Integrator as below, and make sure to check the checkbox across ‘Display in Create Documents Page’ and click on the Next Button

 

 And now define the Interface Name, here I am using the Interface Type of Function, and you can return the Error Information from the Function. The Package and Function names are provided. The Function I have used is a Sample insert into a Table function as shown below,

create table test_adi(sno number, sname varchar2(2000));

create or replace package test_adi_pkg as
function test_adi_func(p_sno    in number, p_sname in varchar2) return varchar2;
end test_adi_pkg;
/

create or replace package body test_adi_pkg as
function test_adi_func(p_sno    in number, p_sname in varchar2) return varchar2
is
begin
insert into test_adi values(p_sno, p_sname);
return 'Y';
end;
end test_adi_pkg;
/

Click on the Apply button and the Next button after until you reach the Last Page and Submit the Definition as shown below,

    

 Now you have defined an Integrator and the next step is to Define a Layout to insert data in to the Integrator

Desktop Integrator --> Create a Layout




As shown below select the Test ADI Integrator and click on Go button as there are no Layouts defined it does not display any Layouts.

Now click on create Button, and the next Page asks you the Layout Name and the Number of Headers required for the Spreadsheet,
 

Select the number of Headers and click on next Button and you can now select which fields to appear at Header Level and which fields to appear at Line level. And there are different Types you can use. 

 Now in the Layout Screen you can do all necessary Layout changes, such as you can make a field Read Only, order them, Select the Prompt name etc.,

And once you click on the Apply button it saves the Layout and the spreadsheet is now ready to be entered data for.

And now we will go to the Final Step of creating a document,

Desktop Integrator -> create Document

Select the Integrator and the Layout defined and click on the create Document button to create an Excel Spreadsheet.

 Enter data for SNO and SNAME fields defined and upload them to Oracle Data Table.

An Excel document would be created with name Wen ADI(n).xls

Once the data is entered you can initiate the Upload Macro by clicking Oracle -> Upload

And the successful upload would like as shown below with the number of rows uploaded

 The data is now inserted to the underlying Table as shown below.

 Custom Integrator not only loads the data, you can do much more things to process the data by initiating a concurrent program from the API etc.,

Print This Post