Oracle WebADI - I

Oracle Integrator (WEB-Adi) – Part I

Oracle Webadi is a solution for integrating E business suite application with Desktop applications like MS Excel. Oracle EBS Integrator provides a graphical user interface which you can use to define integrators and associate supporting objects.

The desktop integration framework allows you to:-

• ·         Create integrators using wizard-base user interface.
• ·         Define integrators to upload data through PLSQL API or directly to Tables.
• ·         Define Integrators to download data from text files or using SQL Queries.
• ·         Define data validation rules.
• ·         Define layouts and mappings for custom integrators.

Responsibilities Required:-   

Steps to define a new Integrator:-

Navigation:-  Desktop Integration Manager à Manage Integrators

Click Create Integrator Button

Insert the Integrator name and application name.

Note:- Do not forget to click on check box of “Display in create Document Page”.

Now you need to add these two functions by clicking on “Add functions” button.

Click next and navigate to interfaces where you need to enter Interface name and Interface Type.

Interface type is classified as:-

• API-Procedure. Here we need to create a custom API of Procedure type and handled the Exceptions and Error by using “RAISE_APPLICATION_ERROR”.
• API- Functions. Here we need to create a custom API of function type and handled the Exceptions and Error by using “RAISE_APPLICATION_ERROR”.
• Table. Here we need to Register the Table and columns  by using AD_DD package.

I am showing an example with API-Procedure.

Note: - API Returns must be FND Message code to print the error on Excel sheet.

Click APPLY button. You will get a confirmation message.

Click on Select (Radio Button).  You will get all the parameters which are present in you procedure.

Click next. You will navigate to Contents. Just ignore this as it is use for Reporting Purpose.

Click next. Choose Uploader  “From Template”   .

Here you can delete or add parameter OR use it as it is.

Click submit button. You will get a confirmation message for new Integrator.

Define Layout

Now, you need to create Layout of integrator.

Navigation: - Desktop integrator à define Layout.

Choose the Integrator name from Drop down list.

Note: - You will find the name of Integrator only when you have added the

Desktop Integration – define layout function.

Click Go.

Enter the name of Layout. Click next

Assign the placement of fields as line to show it in tabular manner.   

Click Next.

Click Apply.

Now, you just need to check the Integrator.

Navigation:- Desktop Integrator à Create Document.

Click next until you not get Create document Button.

Click Create Document Button and Open excel  file directly.

Excel file will shown like this:- 

 Note: - If you get any error or it takes too much time to open file then check the Excel setting for WEBADI.

Click Add-Ins

Click Oracleà Upload

Click Upload.

You will get a green smiley if Uploaded successfully or get a Red smiley with Error message.

Thanks All...:) 

In next part I will try to update the LOV Validation on Org_ID(Table type), Vendor Name(JAVA LOV) and Vendor site name (Double dependent JAVA LOV).