Migrating Web ADI template from one Instance to another

Following are the components that are associated to the Web ADI that can be migrated from one instance to another:

• Integrators
• Layouts
• Mappings
• Contents

Integrators:

Identify the Integrator to migrate as below,

select integrator_code, application_short_name
  from apps.bne_integrators_vl  bnv
      ,apps.fnd_application_vl  fav
 where bnv.user_name = &integrator_name
   and fav.application_id = bnv.application_id;

For the Integrators, you can

Download the Integrator:
FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct INTEGRATOR_LDTFILE.ldt BNE_INTEGRATORS INTEGRATOR_ASN="appl_short_name" INTEGRATOR_CODE="integrator_name"

Upload the Integrator:
FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/patch/115/import/bneintegrator.lct INTEGRATOR_LDTFILE.ldt

Layouts:

Identify the Layout to migrate as below,

select layout_code
  from apps.bne_layouts_vl
 where user_name = &integrator_name;

For the Above Layouts, you can

Download the Layout:
FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnelay.lct LAYOUT_LDT.ldt BNE_LAYOUTS LAYOUT_ASN="appl_short_name" LAYOUT_CODE="Layout_code"

Upload the Layout:
FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnelay.lct LAYOUT_LDT.ldt

Mappings:

Identify the Mapping to migrate as below,


select mapping_code
  from apps.bne_mappings_vl
 where integrator_code = &integrator_code

For the Above Mappings, you can,

Download the Mapping:
FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnemap.lct MAPPING_LDT.ldt BNE_MAPPINGS MAPPING_ASN="appl_short_name" MAPPING_CODE="Mapping_code"

Upload the Mapping:
FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnemap.lct MAPPING_LDT.ldt

Contents:

Identify the Contents to migrate as below,

select content_code
   from apps.bne_contents_vl
  where integrator_code = &integrator_code

For the Above Contents, you can

Download the Contents:
FNDLOAD apps/$APPS_PASSWORD 0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnecont.lct CONTENT_LDT.ldt BNE_CONTENTS CONTENT_ASN="appl_short_name" CONTENT_CODE="Content_code"

Upload the Contents:
FNDLOAD apps/$APPS_PASSWORD 0 Y UPLOAD $BNE_TOP/admin/import/bnecont.lct CONTENT_LDT.ldt

Print This Post

Web ADI: Custom Integrators Update Icon

The Update Icon for Custom Web ADI's is greyed out, reason for this is that the Integrator may be associated to the ORACLE Standard User.

For the Custom Web ADI's to be updateable, the Integrators Source should be set to 'C'(Custom) rather than 'O'(Oracle).

If the Custom integrators source is Set to 'O' - Oracle in the table BNE_INTEGRATORS_B , please reset it to 'C' - Custom to make it updateable as below,

update BNE_INTEGRATORS_B
   set SOURCE = 'C'
 where APPLICATION_ID = &application_id
   and INTEGRATOR_CODE = &integrator_code;

Print This Post

Unable to access the 'Web ADI - Update Interface Column Prompts' integrator

The Integrator 'Web ADI - Update Interface Column Prompts' is designed for HR and if HR is not installed/implemented then there is a chance that you will not be able to find it in the list.
To access the integrator, you have to add the Function ‘HR_ADI_CAG_INTERFACE_COLS’ to the Menu ‘Desktop Integration menu’

  Print This Post

Oracle Web ADI: Custom Integrator Prompts Change

If you are creating a custom Integrator, and most of the times you would not like the Default prompts it keeps from the API parameters, here is the process to change the Prompt names.

Login to Application as Web ADI Responsibility

Desktop Integrator --> Create Document

Select the Integrator ‘Web ADI – Update Interface Column Prompts’ and click on the Next Button as below,

 

Select the specified Excel version and Click on next Button,

 

Select any specific Integrator, for which you want to change the prompts, Here I have selected,

Application: PAY
Integrator: PAY RI – Create US Federal Taxability Rules For Earnings
Language: US

 

Click Continue and Create a Document

 

This Opens the Document with the Prompt Details Above, Left etc. Here you Can update the prompts and upload the changes.

The Changes would then be reflected in the respective Documents.


 

Print This Post

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