Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Extending and managing Web ADI (Integrator) – Part I

Posted on May 9th, 2008 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

As mention in earlier post (#1,#2,#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.

dgreybarrow-2 Basic User Procedure we have seen for a webADI is

Loading

  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.

dgreybarrow-2 More on WebADI elements

You need to understand two main elements of WebADI.

  • WebADI Integrator : This is create through setup
  • Web ADI Layout : This you can create through a setup.

What you need you normally requires custom program.

dgreybarrow-2 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.

dgreybarrow-2 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 , 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.

Integrator

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

2

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

3

Select the layout

4

Review the Document Creation

7

 

7

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

8

Once Document get created you prompt for download

10

11

12

 

5. You can get the document created.

13

This document is based out of single table ie GL_INTERFACE.

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

14

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

15

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.

dgreybarrow-2 Suggested Reading

Related Posts

Posted in Oracle General Ledger, Web ADI | 14 Comments »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
14 Responses
  1. Extending and managing Web ADI (Integrator Layout) - Part II Says:

    […] 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. Rajiv Says:

    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. Sanjit Anand Says:

    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. venkat Says:

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

    Thanks,
    venkat

  5. Neal Coe Says:

    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. Sanjit Anand Says:

    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.
    fnd

  7. Neal Coe Says:

    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. How to know Web ADI Version ? Says:

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

  9. Anudeep Says:

    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. Hasra Says:

    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. Vishala Says:

    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. Venkatesh Says:

    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. Arnab Says:

    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. need some help web adi version 11.5.9 i want to add parameter like time period Says:

    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

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.