- OracleApps Epicenter - http://www.oracleappshub.com -
Extending and managing Web ADI (Integrator) – Part I
Posted By Sanjit Anand On May 9, 2008 @ 12:32 am In Oracle General Ledger,Web ADI | 14 Comments
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.
Basic User Procedure we have seen for a webADI is
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
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.
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.
Article printed from OracleApps Epicenter: http://www.oracleappshub.com
URL to article: http://www.oracleappshub.com/general-ledger/extending-and-managing-web-adi-integrator-part-i/
URLs in this post:
 #1: http://www.oracleappshub.com/oracle-application/desktop-integration-makes-life-easier/
 #2: http://www.oracleappshub.com/general-ledger/11i-uploading-a-journal-using-web-adi-step-by-step/
 #3: http://www.oracleappshub.com/general-ledger/r12-webadi-step-by-step/
 File: http://www.oracleappshub.com/wp-content/uploads/2008/05/hubdemo.txt
Disclaimer The opinions expressed here represent solely my own represent personal conjecture based upon experience, practice and observation and does not represent the thoughts, intentions, plans or strategies of my current & previous employers and their clients. Copyright © 2007-2010 OracleApps Epicenter. All rights reserved.