- OracleApps Epicenter - http://www.oracleappshub.com -

Extending and managing Web ADI (Integrator) – Part I

As mention in earlier post (#1 [1],#2 [2],#3 [3] ) , WebAdi is tool that can be used to load many different types of data from spreadsheet based excel application into various application of Oracle APPS. There are number of Seeded Integrator comes with Oracle, but still Oracle provides the capability to its expandability. Various Integrators to load different types of information. However, you can do setups new, custom spreadsheet can be created to load different types of information into Oracle.

Basic User Procedure we have seen for a webADI is

  1. Use the webADI page Consist of creating spreadsheet by
    1. Specific to data type which we called as integrator
    2. Specific to Layout which is for controlling purpose of the spreadsheet.
  2. Adding Data to the excel Spreadsheet.
  3. In spreadsheet, you need to select the Oracle/Upload menu option.This is menu option that you can use from WebAdi added from Excel menu.
  4. Than the data get uploaded to Oracle target table, which might be custom, or base. Any error will be flagged and the error reason will be placed on corresponding row in the spreadsheet.

More on WebADI elements

You need to understand two main elements of WebADI.

What you need you normally requires custom program.

Developing a custom Integrator in EBS

You need to follow these steps for creating custom Integrator of webADI

  1. Write a custom Program.
  2. Perform one time WebADI setup and some security setups.
  3. Compile your Custom Program in apps database.
  4. Next is to do setup the integrator, which consist of
    1. Create the integrator
    2. Create a function for your integrator
    3. Add the function to your menu
    4. associate the function to the integrator
  5. Define the layout
  6. Then use the Integrator for generating the spreadsheet
  7. Once Spreadsheet get generated, you can do some cosmetic changes to moving data at header or line level from standard page
  8. Then Upload the data in Oracle
  9. Verify the data in base table either through TOAD/SQL*Plus or through Oracle Screen
  10. If required , you can also tighten your Seeded Oracle Import program with WebADI itself.

Step by Step - Guide for your First Custom Integrator

1. You need to write a custom program.While developing you should be very clear what table you are going to use for targeting table.

These example is based out of these target of GL_INTERFACE table.

Here is File [4] , that can be used for custom Integrator Program.

2. Now you need to log into application , and with Responsibility, you need to start calling the integrator which you have created in step1.

Once Integrator is successfully register , you can see the name appears in the list.

3. Once you select , you might get some error because of security setup.In case of errors your screen looks like as below:

Therefore, you need to check two profile options set at Site level. These profile option setting can be varied from version to version, the higher you will have less setup.

4. Select the Integrator

Select the layout

Review the Document Creation

 

Once you are sure , then you need to press Create Document, this will create a new document.

Once Document get created you prompt for download

 

5. You can get the document created.

This document is based out of single table ie GL_INTERFACE.

6. Try to load data through it by invoking upload menu.

7. Once data get loaded you can see the final confirmation.

8. You can check the information from the backend.

This way you can create custom Integrator to fit any kind of business need.Next post we will learn more on modifying the integrator layout.

Suggested Reading

14 Comments (Open | Close)

14 Comments To "Extending and managing Web ADI (Integrator) – Part I"

#1 Pingback By Extending and managing Web ADI (Integrator Layout) – Part II On May 9, 2008 @ 3:45 am

[…] and managing Web ADI (Integrator Layout) – Part IIExtending and managing Web ADI (Integrator) – Part IR12 : Uploading a Journal using Web ADI : Step by Step11i Uploading a Journal using Web ADI : Step […]

#2 Comment By Rajiv On May 9, 2008 @ 5:27 am

You mention about the profile setting at the site level, can you mention the two profiles. I am using Apps version 11.5.10.2. I get the same error as in step 3.

Thanks

Rajiv

#3 Comment By Sanjit Anand On May 9, 2008 @ 6:18 am

I am not sure, what is the patch level you have applied in Oracle.

Appart from existed applied patches, two profile options need to turn on at site leval.
1)ADI: Use Function Security
2)BNE Allow No Security Rule

What is value you are finding for these two.

#4 Comment By venkat On May 10, 2008 @ 11:51 pm

Hi,
You mentioned that we can call Oracle API through web ADI.
Can you please tell how can we do this.

Thanks,
venkat

#5 Comment By Neal Coe On June 26, 2008 @ 12:42 am

Hi Sanjit,

Thanks for the great content on Web ADI.

Just a quick question regarding your hubdemo.txt file (Here is File link above).
It includes a call to BNE_INTEGRATOR_UTILS.CREATE_DEFAULT_LAYOUT.
We’re currently using 11.5.10.2 and the procedure CREATE_DEFAULT_LAYOUT does not exist within this package.

Is this correct?

Regards,
Neal.

#6 Comment By Sanjit Anand On June 26, 2008 @ 1:04 am

Neal,

I think you Package version is bit older.

check the version of package.
If you are 11i10.2 then must have on and higher of this

Header: bneintgs.pls 115.59.1013.3 2006/07/26 04:04:19 dagroves noship

Please verify:

see the screen shots.

#7 Comment By Neal Coe On July 1, 2008 @ 4:56 pm

Thanks again.
We’re currently on bneintgs.pls 115.57 2003/08/29 01:34:37
I’ll get our DBA on the case.
Cheers,
Neal.

#8 Pingback By How to know Web ADI Version ? On July 18, 2008 @ 5:25 am

[…] Extending and managing Web ADI (Integrator) – Part I […]

#9 Comment By Anudeep On October 3, 2008 @ 9:59 am

Hello Sanjit,
Is there a way to restrict the layouts with the responsibility. We have different people for budgets and actuals, and we want to show only those layouts which they are eligible to enter.
Pls advise !!

–Anudeep

#10 Comment By Hasra On December 2, 2008 @ 4:02 pm

Can anyone provide me with some guidance on how I can build validation on a custom integrator.

I have built an integrator to load requisitions. I want to ensure the data uploaded to the application (11.5.10 CU2) is correct. Example, I would like to create a LOV in some of the columns

#11 Comment By Vishala On April 13, 2009 @ 11:47 pm

I need to call a function from in WEB ADI excel sheet

My requirement is that I have to provide the drop down for CONVERSION_TYPE and CONVERSION_DATE and when the user selects the value from the drop down list, the value in the Exchange Rate should pop up.
So I was thinking to make a function at database which will do the calculations on the basis of conversion_rate and conversion_date provided and will give the Exchange_Rate as output.
I want to know how can I call a function in WEN ADI.

Regards

Vishala

#12 Comment By Venkatesh On May 18, 2009 @ 8:04 am

Hello Vishala,

The similar functionality is achieved in std GL journals upload webadi sheeet using java component. You can refer the same for achieving this conversion date and rate functinality.
Regards,
Venky

#13 Comment By Arnab On May 12, 2010 @ 2:03 pm

This is an excellent article. It gives all the right clues about how to go about creating a custom web adi integrator. Thanks a ton for this.

#14 Comment By need some help web adi version 11.5.9 i want to add parameter like time period On November 6, 2010 @ 11:33 pm

i have version 11.5.9 oracle apps. want to use web adi data dowloading but user want to enter time period (parameter) how to do this parameter can you please suggest me its very urgent