• Register

HEADLINING: We will be launching Oracle trainings next month contact us for more details

User Rating: 5 / 5

Star activeStar activeStar activeStar activeStar active
 
Creating custom Web ADI Integrators.
Using custom Web-ADI integrators, you can create custom excel spreadsheets that can be integrated with Oracle Applications Menus. The structure of this excel will be as per your business needs. This excel will have fields validated by LOV, DropDown Lists etc. The data entered into this excel will then be further validated and gives errors in Excel. Once the valid values entered the data will be loaded into tables via PL/SQL. This is a great feature in Oracle Applications, and many of the functional & business users would love to have this functionality. Using this article, you will be able to implement a custom web-adi integrator to meet the data entry requirements of your business users via excel screen. Standard Web ADI gives General Ledger Journals for 11.0 and 11i.

This document explains about how to create custom integrators, and how to integrator with the functions. After added the custom integrators how to use the custom integrators and insert the data into database through the integrators. This document assumes that the reader has a basic knowledge of PL/SQL procedure and functions.


Background
Web ADI gives functionality with desktop productivity applications to create a more effective working environment.
Traditional enterprise application users can leverage productivity tools such as Microsoft Excel to complete their tasks. This proves helpful when users have a large number of records to enter into the system. Rather than creating records row by row in an HTML form or using a back-end data loader, a formatted Excel worksheet can be created that allows the free-form entry of data - all Excel functionality such as copy/paste, fill-down and data import. And extra functionalities like drop down, List of values are available to help one quickly create, view and edit Information.
Users are made more productive, yet the accuracy of their work is not compromised. All business rules these users encounter in the main application are enforced within the Web ADI worksheet. For example, if the wrong cost center is entered for a journal, the data will not be "committed" to the database; a message will be returned directly to the worksheet where the invalid data exists; the user can then quickly make the correction and save their Excel data to Oracle General Ledger. If a column has more values you can start the search from excel sheet, the results you can get in a OAFramework page and select the value will return to excel sheet.
Web ADI uses the Internet Computing Architecture (ICA). This means no client side install and great performance over WAN, VPN and even dial up connections.

Steps:

1) Develop an Integrator for your own excel template and assign it to the user.

2) User login and launch the excel from Web ADI and enters the values in excel directly (he can enter the values, choose the values from Poplist or List of Values.

3) Choose oracle->upload option in excel and upload the data into the database. When the data gets uploads you can write a PL/SQL to insert the data directly into database or you can do some process of the entered data and then update the database table accordingly.

This document should be used to develop custom integrators. Custom integratos will be used for a case of having a requirement of launching an excel templete from apps and fill the values in the excel file and we will get an option to upload the values into the database table. At the time of uploading the data we can define that where the data should go and we can manupulate the entered data and insert into the database table.


.
Creation of the custom integrator
Usage of custom integrator
Custom integrator will be used to upload the excel values into database tables.
For Example the user wants to upload the data from an excel sheet with a formatted way, and when it uploads the data should be validated and should be returned back if any error occurs or data should do some other calculation with other tables, that can be done.
The template excel can have defaulted values, LOV values and POPList values to select the values.
Once we have the custom integrator we can define as a function and assign to the FND_USER.


Steps to create the custom integrator
.
Step 1. Using bne_integrator_utils.CREATE_INTEGRATOR package create the custom integrator
Step 2. Using bne_integrator_utils.CREATE_INTERFACE_FOR_API package create the interface for the created integrator.
Step 3. Using bne_integrator_utils.CREATE_DEFAULT_LAYOUT package create the default layout for the created integrator with the interface.
Step 4. Adding POPList for the required columns.
Step 5. Change the excel column prompts, by default the column headers will come as Database column name.


Now lets see the above steps in detail
Step 1. Create Integrator
Using the standard package bne_integrator_utils.CREATE_INTEGRATOR we can create the integrator, with the following parameters,
PROCEDURE CREATE_INTEGRATOR
(P_APPLICATION_ID IN NUMBER,
P_OBJECT_CODE IN VARCHAR2,
P_INTEGRATOR_USER_NAME IN VARCHAR2,
P_LANGUAGE IN VARCHAR2,
P_SOURCE_LANGUAGE IN VARCHAR2,
P_USER_ID IN NUMBER,
P_INTEGRATOR_CODE OUT NOCOPY VARCHAR2);
P_APPLICATION_ID
--Is the application Id of the application where we are going to create the integrator.
--Use the query, SELECT application_id FROM fnd_application WHERE application_short_name = '<CUSTOM_SHORT_NAME>';
P_OBJECT_CODE – Integrator Code, which will be used internally.
P_INTEGRATOR_USER_NAME – Integartor Name, which will be displayed in the application.
P_LANGUAGE, P_SOURCE_LANGUAGE are the language codes, (US for english).
P_USER_ID – FND_USER id, (0 for sysadmin)
P_INTEGRATOR_CODE – Return parameter, which will be used for the furter steps.



Step 2. Create Interface
PROCEDURE CREATE_INTERFACE_FOR_API
(
P_APPLICATION_ID IN NUMBER,
P_OBJECT_CODE IN VARCHAR2,
P_INTEGRATOR_CODE IN VARCHAR2,
P_API_PACKAGE_NAME IN VARCHAR2,
P_API_PROCEDURE_NAME IN VARCHAR2,
P_INTERFACE_USER_NAME IN VARCHAR2,
P_PARAM_LIST_NAME IN VARCHAR2,
P_API_TYPE IN VARCHAR2,
P_API_RETURN_TYPE IN VARCHAR2 DEFAULT NULL,
P_UPLOAD_TYPE IN NUMBER,
P_LANGUAGE IN VARCHAR2,
P_SOURCE_LANG IN VARCHAR2,
P_USER_ID IN NUMBER,
P_PARAM_LIST_CODE OUT NOCOPY VARCHAR2,
P_INTERFACE_CODE OUT NOCOPY VARCHAR2);

P_APPLICATION_ID – Application Id, which we are creating the custom integrator.
P_OBJECT_CODE – Interface Code for internal use.
P_INTEGRATOR_CODE – Code for the integrator, which we created in the step1.
P_API_PACKAGE_NAME - When the user uploads the excel sheet this package being called.
P_API_PROCEDURE_NAME - When the user uploads the excel sheet this procedure being called.
In this procedure the columns will be mapped with the excel sheet. From this procedure the data needs to be inserted into the database table.
P_INTERFACE_USER_NAME – Name of the Interface, which we are creating now.
P_PARAM_LIST_NAME - Parameter list.
P_API_TYPE - API type, PROCEDURE or FUNCTION.
P_API_RETURN_TYPE - What is being returned from the API
P_UPLOAD_TYPE
Type of upload, (Set to 0, 1 or 2. 0 = Custom Upload Type (uses
BNE_INTERFACES_B.UPLOAD_OBJ_NAME to obtain class name to load). 1= upload to Table.
2 = Upload to PL/SQL API)

P_LANGUAGE, P_SOURCE_LANG - Language being used in the upload(US-English)
P_USER_ID - User Id for the reference (0 – Sysadmin)
P_PARAM_LIST_CODE - Return code for the parameter list.
P_INTERFACE_CODE - Return code for the created Integrator.





Step 3. Creating default layout.
PROCEDURE CREATE_DEFAULT_LAYOUT
(
P_APPLICATION_ID IN NUMBER,
P_OBJECT_CODE IN VARCHAR2,
P_INTEGRATOR_CODE IN VARCHAR2,
P_INTERFACE_CODE IN VARCHAR2,
P_USER_ID IN NUMBER,
P_FORCE IN BOOLEAN,
P_ALL_COLUMNS IN BOOLEAN,
P_LAYOUT_CODE IN OUT NOCOPY VARCHAR2);
P_APPLICATION_ID –Application Id, which we are creating the custom integrator.
P_OBJECT_CODE – Default Layout code, for internal use.
P_INTEGRATOR_CODE - Integrator code which we have created in the step1.
P_INTERFACE_CODE - Interface code, which we have created in the step2.
P_USER_ID - User Id (0 – Sysadmin)
P_FORCE - If the layout name exists over write or error out(true or false)..
P_ALL_COLUMNS - Layout to be created for all the columns (true or false).
P_LAYOUT_CODE - Out parameter for the created default layout.





Step 4. Creating POPLIST for the required columns.
Now we are ready with the custom integrator, if we want to create POPLIST, User hint for any of the created integrator columns, use the following sql,

Create POPLIST for a column UNIT_OF_MEASURE
UPDATE bne_interface_cols_b
SET val_id_col = 'UNIT_OF_MEASURE',
val_mean_col = 'UNIT_OF_MEASURE',
val_type = 'TABLE',
lov_type = 'POPLIST',
val_obj_name = 'MTL_UNITS_OF_MEASURE_VL',
val_addl_w_c = 'DISABLE_DATE > sysdate or DISABLE_DATE is null'
WHERE interface_col_name = 'P_UNIT_OF_MEASURE'
AND application_id = lc_application_id_result
AND interface_code = lc_interface_code;
val_obj_name is the table name where the values should come from and val_addl_w_c is the where clause for the POPLIST restriction.

Check bne_integrator_utils for more details about creating LOV, Calender LOV and Chapter 5 of Web ADI Integrator Developer’s Guide for Java LOV.

Adding User Hints
UPDATE bne_interface_cols_tl
SET user_hint = '*(Eg.Miscellaneous)'
WHERE prompt_left IN ('CATEGORY_NAME')
AND application_id = <CUSTOM_APPLICATION_ID>
AND interface_code = <CREATED_INTERFACE_CODE>;



Step 5. Changing the PROMPTS for the columns
UPDATE bne_interface_cols_tl
SET prompt_above = 'Item Description',
prompt_left = 'Item Description'
WHERE prompt_above = 'ITEM_DESCRIPTION'
AND application_id = lc_application_id_result
AND interface_code = lc_interface_code;
bne_interface_cols_tl, bne_interface_cols_b are the main tables used for the above changes and for holding integrators info.




Prerequisities.
The following are the prerequisites for Web ADI (11i.BNE.D):
One of the following operating systems must be installed on the client PC
Windows ME
Windows NT 4.0 with Service Pack 3 or later
Windows 2000
Windows XP
Windows 98
Windows Server 2003

Internet Explorer 5.0 or greater installed on your machine.
Set the browser security settings to allow a document to be created on the desktop
Navigate to Tools -> Internet Options and choose the Security tab
Select Local Intranet and choose the Custom Level button
Set the option ‘Initialize and script Active X controls not marked as safe’ to Prompt

One of the following versions of Excel is required if using the General Ledger - Journals Integrator:
Microsoft Excel 97
Microsoft Excel 2000
Microsoft Excel XP
Microsoft Office 2003


For Web ADI to work with Excel XP and 2003 users will have to:
Open Excel
Go to Tools -> Macro -> Security -> Trusted Sources
Check the "Trust access to Visual Basic Project"


Setting the layout and create the Integrator as a function.
We can create our own layout for the excel sheet, Please check the following screen shots. To do the following steps the user should have System Adminstrator responsibility and Web ADI Responsibility or Web ADI’s Main menu.


Manual Setup for Created Integrator Layout and Create Document Function:
This document describes about creating Required Layout from the existing Default Layout. Login into the instance and select the Web ADI responsibility.


Click Define Layout, and select our XXT NCR Upload integrator in the poplist.
You can see the Integrator, which we have created just now in the poplist.


You will get the existing default Layout; take a copy of the layout by clicking the Duplicate button.


Click Update button for the newly copied layout(Eg. NCR Catalog Upload6).




Click Continue.


That will display all the columns available in the table.


Select only required columns(which will be in UnitCap) , the following columns needs to be put into Header Placement.

1) Please enter ----(User Hint)
2)
--------------------(Header Underline)
3)
Currency
4)
Exchange Rate
5)
Requisition Description

And Set Default Value for

1) Currency as
SELECT
gsb.currency_code
FROM gl_sets_of_books gsb, hr_operating_units hou
WHERE gsb.set_of_books_id = hou.set_of_books_id
AND
hou.organization_id = fnd_profile.VALUE ('ORG_ID')

 

And Default Type as SQL
And then click apply.



Now our required layout is ready.



Assigning “Create Document” function to the Menu Tejari POR NCR Catalog Upload (Code: XXT_NCR_UPLOAD_MENU)

The following screenshots will give the steps to create the function and shortcut to create the NCR Upload function.

Click Create Document.


You will get viewer as Excel 2000, Click Next. And the next will give option to select the Integrator, select our custom integrator (Eg. XXT NCR Upload)



Next screen will give the Layout selection, and you will get the newly defined Layout. Select the newly created layout and click next.



Select None as the Content. And click next. The next screen will give the Summary of the current Create Document.



Click on save to save the defined Create Documents so that we can create the Function and the shortcut.


In FND_FORM_FUNCTIONS you can get the newly created function, the FORM_NAME will be BNE_NCR TEMPLATE – 8 (All in caps and prefixed with BNE_), This needs to be added with the custom menu Tejari POR NCR Catalog Upload

(Code: XXT_NCR_UPLOAD_MENU)

You can use Functional Administrator Resonsponsibility (Self Service: Core Services -> Menus) or System Administrator(Forms: Application ->Menu)

 

Now the Menu XXT: NCR Web ADI Integrators Menu will have the functions of Catalog Upload, Catalog Update.

Now you can remove the Web ADI prompt in the menu XXT: NCR Web ADI Integrators Menu, so that users will not see the Web ADI Functions.

 

You can download the sample PL/SQL used for this article from link below
http://www.apps2fusion.com/training_demo/kalimuthu/web-adi/XXT_NCR_UPLOAD_PKG.sql

 

Comments   

0 #1 Anton Alexeyev 2008-07-15 05:20
Intresting article, but are u able to create integrator with LOVs like in standart integrators?
Quote
0 #2 Kalimuthu Vellaichamy 2008-07-15 06:27
Yes, We can create LOV's like standard integrators. There are two types of LOV.
Once is just a simple where clause that can be done without using a java file,
If you want to build a complex query for the search you can do it with the help of java files.

Thanks.

With Regards,
Kali.
Quote
0 #3 Anton Alexeyev 2008-07-15 22:55
Java? nice. I use standart tools for it, like inserting into bne_attributes, bne_param_list_ items and etc for create LOVs like in a seeded "Create integrator" integrator.
But it's have only 3 fields for data(like Lookup_code, Meaning, Description), but i don't need to create a Java class and i'm able to create integrator with simple pl/sql call like:
p_lov_list :=
xxbne_cols_arra y_t (xxbne_cols_t ('P_TEST_ID' -- NAME_package
,'TEST_ID' -- NAME_view
,'test_id' -- CAPTION
,'pay_element_t ypes_v a' -- obj_name
,'' --addl_w_c
,'ELEMENT_TYPE_ ID' --id_col
,'ELEMENT_NAME' --mean_col
,'DESCRIPTION' --desc_col
)
,xxbne_cols_t ('P_TEXT1' -- NAME_package
,'TEXT1' -- NAME_view
,'Text1' -- CAPTION
,'FND_APPLICATI ON_VL' -- obj_name
,'' --addl_w_c
,'APPLICATION_S HORT_NAME' --id_col
,'APPLICATION_N AME' --mean_col
,'' --desc_col
)
,xxbne_cols_t ('P_DATE1' -- NAME_package
,'DATE1' -- NAME_view
,'Date1' -- CAPTION
,'' -- obj_name
,''
--addl_w_c
, '' --id_col
,'' --mean_col
,'' --desc_col
)
);
xxbne_integrato r_utils.create_ integrator (p_object_code
,p_integrator_u ser_name
,p_api_package_ name
,p_api_procedur e_name
,p_view_name
,p_lov_list
);

And i have a question. Are u able to create LOV with more then 3 columns??
Quote
0 #4 Kalimuthu Vellaichamy 2008-07-16 08:35
Anton,

The question is, Can I have more than 3 LOVs in the excel?

Thanks.

With Regards,
Kali.
Quote
0 #5 Anton Alexeyev 2008-07-16 08:46
Nope can u have a more then 3 columns in ur Java functio based LOV?
Quote
0 #6 AboutOracleApps 2008-07-16 22:03
Great article.


--Ch ris Martin
Quote
0 #7 ram c 2008-07-17 03:49
I want to migrate 11.5.10 to R12 for GL Daily rates?
Do we need to create custom Integrator or is there any integartor available in R12?
We I just have a gray area on the ADI stuffs.
It would be great if suggest me on same.

Regards,
Ram
Quote
0 #8 rekaprasannakumar 2008-07-21 12:05
Can we use this feature to load AP Invoices using Web ADI?
Quote
0 #9 Tubai 2008-07-25 04:07
Great article. It seems veru helpful to me. I am facing the following problem while developing a custom integrator. Please help me in this regard. This is urgent.

I am developing a custom integrator for uploading Bills of Material details. After creating the custom integrator following the steps as given in your article, i defined layout for the new custom integrator. But when I click on 'Create Document' in Oracle Web ADI responsibility, the custom integrator is not visible in the select integrator drop-down list. So I am unable to create the document.

Plea se help.
Quote
0 #10 Kali 2008-07-25 04:23
Hi,

Can you please check the entries in the Web ADI tables, for integrator and interface.

Wit h Regards,
Kali.
Quote
0 #11 Kali 2008-07-25 23:18
Hi,

You can check the created Integrator, and Interface from the following tables.

Select * From BNE_INTEGRATORS _B order by creation_date desc

Select * From BNE_INTEGRATORS _TL order by creation_date desc

Select * From BNE_INTERFACES_ B order by creation_date desc

Select * From BNE_INTERFACES_ TL order by creation_date desc

If still you are facing issues to create the integrator, please give me your email id, I can give you a sample script which is working fine.

Thanks.

With Regards,
Kali.
OSSI.z
Quote
0 #12 Kali 2008-07-25 23:19
Hi,

I never tried to create more than 2 java function based LOVs.
You are facing any issues, when you are creating the fourth LOV?

Thanks.

With Regards,
Kali.
OSSI.
Quote
0 #13 Kali 2008-07-25 23:21
rekaprasannakum ar ,

I am not aware of the functionality of the AP invoices, if it is a excel sheet. You can define a custom integrator which is of the same format
and upload it.

Before create custom integrator, check the standard integrators, there are many inbuilt integrators which will support the standard export.

Thanks .

With Regards,
Kali.
OSSI.
Quote
0 #14 somisettyramana 2008-07-28 14:13
Hi,
Very good article.
Thank you very much.
Can you please tell how to create java based LOV. Please email the sample adi scripts to .

Thanking you,
Ramana.
Quote
0 #15 somisettyramana 2008-07-29 07:14
Hi,
Can you please suggest:
1) How the message text will be populated in the excel sheet after the uploading process, if we are calling API for the interface.
2) In the jounrals upload , we will get one screen where we can select options like all lines to upload. How to enable this for custom integrator.
3) If we want to provide two options like validate the data , upload the data, validate & upload the data. How do we achieve this. In case of validate , which api will be called.

Thanks ,
Ramana.
Quote
0 #16 Kali 2008-07-29 09:18
Ramana,

I sent the sample scripts and the developer guide for Web ADI.

That gives more info.

Thanks.

With Regards,
Kali.
Quote
0 #17 Anton Alexeyev 2008-07-29 23:06
somisettyramana
1. Just raise a message and u will see it after the uploading process.
2. I have by default in my ingerators, but i create it with my own script.
3. U mast use same package for validation, in case it's not seccided just Raise a error and u will see it in ur integrator.

Ka li
Hey, can u email me this java Based Lov sample too plz??
W wiil gave u may package for integrator creation.
Quote
0 #18 Rehan Yusuf 2008-08-04 01:02
Hello Kali,

Thanks for this article. I've tried building a custom integrator and it works just fine, however, it only takes the data from my XLS to a destination table in the Database. What if I wanted to process this data using concurrent processing once I have staged it ?
A point of reference to what I'm talking about would be the "Fact Loader" integrator in Enterprise Profitability Manager. The algorithm for the same is like this:
1.) User enters data into XLS
2.) User uploads data from XLS by selecting the "Upload" function from the Oracle menu
3.) Data is loaded to the open interface table
4.) Integrator also calls a seeded Open Interface Program to load data to base tables
5.) Integrator shows the request ID of the submitted request to the user.

Half of the above algorithm is done, if you could please provide inputs as to how we could do the second half ?
Also, could you please direct me as to where I can find the BNE developer guide ?

Thanks and regards,
Rehan Yusuf
Quote
0 #19 Kali 2008-08-04 01:51
Hi Rehan,

You want to start a concurrent program once the Web ADI excel uploads the data into the interface table?
Please check the "Defining an Importer" in the developer's guide.
I don't remember the metalink note number, give me your email id.
I will send you the document.

Than ks.

Give
Quote
0 #20 Shailaja 2008-08-05 13:02
I want to display error message in the "Messages" column in the spreadsheet for each data row which had error ..can we even do this ?. We have to do some custom validations and if not validated display some custom message..
I am using Custom Procedure which inserts data to my custom table. How do i this ?
Quote
0 #21 Shailaja 2008-08-06 18:06
Please can you send me the document too..
How do we determine the End of File..Once it has finished parsing through all the rows I have to total the amount column in spreadsheet and make sure total is greater than 0. If greater than 0 then only commit all the rows else rollback..
How can I do this ?
Quote
0 #22 Kali 2008-08-06 20:40
Hi,

>>I want to display error message in the "Messages" column in the spreadsheet for each data row which had error ..can we even do this ?.
>>We have to do
>>some custom validations and if not validated display some custom message..
>>I am using Custom Procedure which inserts data to my custom table. How do i this ?

I am not sure how to do this, But the developer guide will give more idea.
Give me your maili id, I will send you the doc.

>>How do we determine the End of File..Once it has finished parsing through all the rows I have to total the amount
>>column in spreadsheet and make
>>sure total is greater than 0. If greater than 0 then only commit all the rows else rollback..

Thi s can be done at your procedure, You can have a global variable and count every time of insert and if the total is
Quote
0 #23 Anton Alexeyev 2008-08-06 23:06
>I want to display error message in the "Messages" column in the spreadsheet for each data row which had error ..can we even do this ?. We have to do some custom >validations and if not validated display some custom message..
>I am using Custom Procedure which inserts data to my custom table. How do i this ?

Just Raise a custom Error message in ur package -- and u will get in ur Message column
Quote
0 #24 Shailaja 2008-08-07 12:47
Thanks Kali. my email id is
Quote
0 #25 Kali 2008-08-07 20:31
>>Thanks Kali. my email id is
'>
I sent the document to you.

Please check.

Thanks.

With Regards,
Kali.
Quote
0 #26 vivien 2008-08-15 13:49
Hi Kali, great article and subject.

Can you also email me the webadi developer guide?

Any api integrator example would be greatly appreciated also, I'm on EBS 11.5.10.2 and my BNE_INTEGRATOR_ UTILS header line is:

/* $Header: bneintgs.pls 115.59.1013.3 2006/07/26 04:04:19 dagroves noship $ */
Quote
0 #27 Kali 2008-08-15 13:58
Hi

Can you give your email id.

Thanks.

W ith Regards,
Kali.
Quote
0 #28 vivien 2008-08-15 14:05
yes, my email id is:
Quote
0 #29 Pri 2008-08-18 03:08
I want to display the error messages in Messages column of Web Adi Excel. How can we do this?

Can u mail me sample script for this & a copy of the web adi developers's guide to ?
Quote
0 #30 somisettyramana 2008-08-18 15:43
Hi,
Can you please provide your gmail id. I lost it.

Thanks,
Ra mana.
Quote
0 #31 Kali 2008-08-18 20:21
Sent a test mail to you.

With Regards,
Kali.
OSSI.
Quote
+1 #32 Anton Alexeyev 2008-08-19 05:46
Hey m8s.
Can anyone tell me how can i create a read only or hidded column in my integrator??
Quote
0 #33 Anton Alexeyev 2008-08-19 06:17
I was found u can control it in bne_interface_c ols_b table.
But it's work realy bad -- if u setting up a Read_only flag -- it's clear it after user editing.
Quote
0 #34 Pri 2008-08-22 01:32
I am developing a WEB ADI integrator for Bill of material upload. The integrator will populate the data in a temporary table, validate it & write the error messages back to the table . On succesful validation the data will be sent to interface tables & then to base table.

The integrator uses a procedure & sends data to the procedure. Procedure then loads data in temporary table & does the rest of work.

To do this i need to know the following thinngs:

1. How i can track the line no of Excel?
2. How do I know that all data are loaded in temporaray table because the validation & rest of work will be done once all the rows of excel are transfered to temporaray table. i.e. How do i determine the End of File in Excel?
3. How do i write error messages from the table to the excel in web adi?

Any help will be appreciated. Please send me the sample scripts & web adi developer guide at ,.
Quote
+1 #35 Sneha 2008-08-29 18:14
Im printing error messages using the RAISE APPLICATION ERROR in the Messages Column of webadi upload spreadsheet. However the error message is getting truncated to 100 characters. Does anyone know why ?
eg: RAISE_APPLICATI ON_ERROR(-20001 ,V_MESSAGE);

I saw in oracle that v_message length can be 2048 bytes (512 characters)..th en why is it truncating it

Thanks
Quote
0 #36 Rehan Yusuf 2008-09-12 16:02
Hello Kali,

Thanks for your response, you can send me the details on this id :
Your efforts are much appreciated !

regards,
Reh an Yusuf
Quote
0 #37 Rajteva 2008-09-24 11:33
Hi Kali,

Can you please email me the web adi developer guide to .

Thanks

Raj
---------
Quote
0 #38 Rajteva 2008-09-24 14:18
Hi Kali,

Can you please email me the web adi developer guide to .

Thanks

Raj
---------
Quote
0 #39 veni 2008-09-29 16:46
Hi can i have the web adi developers's and if possible script to display custom error messages in message column in excel. My email id is

Thanks in advance
veni
Quote
0 #40 Jake 2008-10-14 12:12
Can I also get a copy of the developers guide? Can't find it anywhere on-line. Thanks.
Quote
0 #41 Rosemarie Vitales 2008-10-14 15:09
Can I also get a copy of the developer's guide. My email is
Quote
0 #42 Priscila Moreira 2008-10-17 10:55
Could you send me a copy of he developer's guide too.
My e-mail:
Thank´s

Prisc ila Moreira
Quote
0 #43 Jerry 2008-10-27 04:03
Hi Kali,
Now, I used Oracle R12, when i tried to create document with standard Integrator in Oracle, there is only few integrator that i can use, and i've allready check table BNE_INTEGRATORS _VL and there is many integrator in the data. Could you give me a clue, where i must setup so i can use general integrator which oracle allready has.
thq
my email is
Quote
0 #44 GeorgeS 2008-10-27 15:31
Hi Kali,
Excellent article. Please send me the WebADI Developers Guide.

My email:

Thanks,
Georg e
Quote
0 #45 sudhir 2008-10-29 06:34
Hi Kali,

Thanks for the article, its very helpful.

I have following questions?
1. When i use the seeded general ledger journals integrator to upload the data, there are fields in the template where list of values are available. Where you do the configuration to attach an lov to the field.
2.Is it possible to show an example where the data is downloaded from the system, corrections are made and uploaded back.
3.Please send me the webADI developers guide

Thanks for the help.
Sudhir
Quote
0 #46 Chris Navin 2008-11-03 21:29
Hi Kali,

Can you please mail me the developer guide document?
.

Thanks a lot.
Navin.
Quote
0 #47 Chris Navin 2008-11-03 21:32
Kali,

Can you send sample scripts for updating the excel sheet with error messages?

Than ks.

Navin.
Quote
0 #48 Abhishek1 2008-11-13 04:09
Hi Kali,

Please send me the user guide on my email address .

Thanks much!
Abhishek
Quote
0 #49 Geethana 2008-11-17 03:31
Hi Kali,
Please send me the ADI developer guide and the sample script to my e-mail address

Thanks a lot!

Geetha
Quote
0 #50 Sneha 2008-11-18 14:32
Does Poplist work with Excel 97 for webadi ? does anyone know ? I cant test this because I dont have Excel 97 in my machine.
Quote
0 #51 Lokesh 2008-11-21 14:17
Hi Sneha,

Are you ablel raise the error message with more than 100 characters.

if so can you pls share with us.
Quote
0 #52 Sneha 2008-11-25 17:15
No. im still not able to error messages more than 100 chars..Our user is ok with it. But as of now dont think there is any solution.
Quote
0 #53 Dillibabu 2008-11-26 03:18
Hi Kali,

Can you please send me the web adi developer guide.

Thanks
R.Dillibabu
Quote
0 #54 veerakm 2008-12-05 13:08
Hi
can i have the web adi developers's and if possible script to display custom error messages in message column in excel. My email id is
This e-mail address is being protected from spambots. You need JavaScript enabled to view it '>
Thanks in advance
veera
Quote
0 #55 Dillibabu 2008-12-05 20:56
Hello,

I have a requirement to run the concurrent program automatically after the upload is complete. Can you please tell me how to do this.

Thanks
R .Dillibabu
Quote
0 #56 Aleksandar 2008-12-10 10:26
Hi,

I am also interested in how can I know in my upload procedure that upload reached the last row in excel template so I can start some concurrent program like import?

Thank you,

Aleksanda r
Quote
0 #57 Aleksandar 2008-12-11 05:53
Hi,

Can you please send me the web adi developer guide.


Thank you,
Aleksandar
Quote
0 #58 Aneel kumar 2008-12-16 02:31
Kali,

It’s a nice article. I have a problem with web ADI. I have created an integrator pointing to custom API. This API calls inside Seeded API.
I am passing 43 parameters to this custom API, when I upload 4-5 records it’s working fine. But when I am trying to upload more than 20 records
I am getting an error “The server is unable to complete the upload.”
Any help is much appreciated.

T hanks,
Aneel
Quote
0 #59 Abdul Rahman 2009-01-01 05:09
Great Article Mr. Kali, please continue this good work.

Dear Aneel,

i had the same issue, we found out that the lenght of text to be inserted in a column is more than the length of the column, it does not highlight this and gives “The server is unable to complete the upload.”

i was able to insert successfully after i truncated the text from the parameter to map it to the lenght of the column (in the integrator API).

My Requirement is to add Calendar LOV and validate data can i have the Developer Guide please. if somebody can post the link that would be lot more better.

my id is , thanks in advance.

btw i use this form function to call my WEBADI directly from Application navigator Menu.

in the form function enter the Relevant User-Form-Funct ion name, and select the type as " SSWA servlet function'' and in the parameters column enter '' bne:page=BneCre ateDoc&bne:view er=BNE:EXCEL200 3&bne:reporting =N&bne:integrat or=GNE:GENERAL_ 81_INTG&bne:lay out=GNE:GNE_SHI PMENT&bne:conte nt=GNE:GENERAL_ 81_CNT&bne:nore view=Yes "
And the HTML call will be "oracle.apps.bn e.webui.BneAppl icationService' '

in the Parameters column

we got the integrator name ''GNE:GENERAL_8 1_INTG'' from

Select * From BNE_INTEGRATORS _B order by creation_date desc

Select * From BNE_INTEGRATORS _TL order by creation_date desc

we got the layout name ''GNE:GNE_SHIPM ENT'' from Selcet USER_NAME from BNE_LAYOUTS_TL;

we got the content name ''GNE:GENERAL_8 1_CNT'' from Select CONTENT_CODE from bne_contents_tl ;

good work guys.

Abdul Rahman
P.S : Please mail developer guide to
Quote
0 #60 JOSE FERREIRA 2009-01-02 14:08
Hi,
First of all great article !
I've got a web adi only for update mode and the message above appears always at the bottom of spreadsheet. Do you know if there is a way to remove this message once the users must not insert any row in my webadi ?
Please could you send me the webadi develper guide ?
Thanks,
Jose ()
Quote
0 #61 Syed_ZN 2009-01-06 16:32
Hi Kali

Appreciat ing your work on this article. I am looking for a sample script to create LOV to show on Excel and the possiblity of validating the data to upload to an interface table. Could you please send me relevant scripts and the developers guide? My email id is .

Thank you
Syed.
Quote
0 #62 Jwolters4 2009-01-15 14:38
Great article! Can you please send me the "Web ADI Developers Guide"?

Thanks !
Jason ()
Quote
0 #63 Servane 2009-01-21 18:14
Hi Kali,

Very interesting article!
We are in Release 12 and want to be able to upload AP Invoices through Web ADI.
I know we can use the AP Interface Tables but do we need to create temp Tables since we want to be able to upload multiples invoices with multiples lines in a single batch?
Please send me a sample script and any documentation that will be helpful in this matter.
Thank you so much and keep up the good work you do with your blog !

Cheers!
Serv ane
Quote
0 #64 Dillibabu 2009-01-22 21:34
Hello,

can anyone tell me how to create the Java Lov in a custom integrator.

Th anks
R.Dillibab u
Quote
0 #65 RRaghuRaman 2009-01-27 11:39
How Do You Handle Output Parameters? Could This be part of The Document? Also type Boolean?
Quote
0 #66 Sam Wang 2009-03-16 23:17
Hello Kali,

I am facing the problem of creating java function based LOV. There also need dependent relationship between LOVs. Do you know how to deal with it?
Also please send me your java LOV scripts and Web ADI Development guide.


Thanks a lot!

Sam
Quote
0 #67 Cj 2009-03-18 09:43
Hi Kali,
Very helpful article.
Can you send me the ADI developer guide and sample scripts to my e-mail address at
.

Thanks a lot!
Chris
Quote
0 #68 trista 2009-03-19 02:43
Thank you for your explanation
But I can't found the developer guide on oracle website
Could you send me the developer guide to my e-mail?
Thank you
Quote
0 #69 Lakshmi Narayanan 2009-03-20 08:06
Hi,

We have a requirement to uploaded the Receiving data to the Receiving Interface Table. Is it possible to create the Integrator for 'RCV_TRANSACTIO NS_INTERFACE'

expecting your reply.

Thanks!
()
Quote
0 #70 Harrod 2009-03-31 07:09
Hi
kali
I 'am facing the problem that i have to creating the JAVA LOV,But I don't know how to do it,could you please send me some example scripts ?And could you please send me The copy of WebADI developer's guide? Thanks you.
My E-mail:
Quote
0 #71 jayashree 2009-04-02 16:31
Excellent article. Can you please send me the ADI Developer guide to my email id
Quote
0 #72 rejeswari 2009-04-03 13:30
Hi Kalimuthu,

cou ld u please email me the web adi developer guide. I need some help in this. Please email me your email id so that I can send me the error I am getting

thanks

rajeswari
Quote
0 #73 Ian Towey 2009-04-09 18:39
Hi,

Very good article, could you forward the Web ADI dev guide to me.

Thanks

Ia n
Quote
0 #74 shweta naugaiya 2009-04-14 02:16
Hi I tried creating a Cistom ADI Integrator. It is visible at front end. But when I am selecting the integrator on the screen, it is giving the following error:
"you do not have permission to acess this functionality".
Please mail the relevant docs to
It'll be great if you can help.

Regards
Shweta
Quote
0 #75 Vishala 2009-04-14 02:56
I need to call a function from in WEB ADI

My requirement is that I have to provide the LOV for CONVERSION_TYPE and CONVERSION_DATE and when the user selects the values from the LOV, the value in the Exchange Rate should pop up automatically.
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 custom function in WEB ADI.

Regards

Vishala
Quote
0 #76 anton 2009-04-14 03:59
u need create a function and add it in to column SECURITY_VALUE from bne.bne_securit y_rules table, after u will add this function to ur user menu it will be able to open integrator
Quote
0 #77 SnehaR 2009-04-17 11:09
Im getting the messages with more than 100 char. Infact the whole message is displayed but along with that unnecessary info is also displayed which we dont need. Not sure how to get rid of that.

Format of the output in the MESSAGES Column in Excel spreadsheet is below -

APPLICATION NAME MESSAGE NAME N -- not sure what this stands for TOKEN NAME -- token if any TOKEN VALUE -- token values : ERROR MESSAGE -- The actual error message

We need the TOKEN because we have to display list of the Error Customer Numbers along with the error message.

Code Snippet used -
FND_MESSAGE.SET _NAME('BNE','WE BADI_ERROR');
FND_MESSAGE.SET _TOKEN('P_UPD_F ILE',p_upload_f ile,false);
FND_MESSAGE.RAI SE_ERROR;

Also tried below

1. FND_MESSAGE.set _encoded('Error message greater than 100 chars');
FND_MESSAGE.RAI SE_ERROR;

RESULT -- Truncates it to 100 characters

2. -- Created Application Message WEBADI_ERROR using Application Developer.

FND_MESSAGE.SET _NAME('BNE','WE BADI_ERROR');
FND_MESSAGE.SET _TOKEN('P_UPD_F ILE',p_upload_f ile,false);
RAISE_APPLICATI ON_ERROR(-20004 , fnd_message.get );

RESULT -- truncates to 100 characters.
Quote
0 #78 Karthikeyan Kumaran 2009-04-24 07:39
Hi Kali,

Nice Article,
It would be great if you could share the dev guide.

Hope so you remember this karthik from OSSI. ;)

Regards,
Ka rthik
Quote
0 #79 srikanthreddy 2009-04-30 02:50
Hi,

At the time of creting new web integator we are facing one problem system is showing the error like:"you dont have permissions to access to this functionality" this error will happen after selceted HR integator setup option from list of values.so wih this error I can not able to proceed further.Please advice me how to resolve this issue.

I will list up the steps which I have followed for creating a new custom integrator for AP Invoice...
---- ---------

1.I selected desk top integator
2.cre ate document
3.Next
4.Selected HR integrator setup

Here after click on next button I am getting this error"You dont have permission to access this functionality". ..

And we need to create new column in the existing layout ,please explain the procedure this is very urgent....

Tha nks
Srikanth
ma il:
Quote
0 #80 Hieu Le 2009-05-04 04:15
Hi Kali,
I checked data in these table, however the integrator still invisible. Could you please send me the script to active the integrator
Sele ct * From BNE_INTEGRATORS _B order by creation_date desc

Select * From BNE_INTEGRATORS _TL order by creation_date desc

Select * From BNE_INTERFACES_ B order by creation_date desc

Select * From BNE_INTERFACES_ TL order by creation_date desc

Best Regards
Hieu
Quote
0 #81 S 2009-05-20 20:56
Hi,

Can you send me the We ADI developer guide to my email address?

Thank s,
S
Quote
0 #82 Guy B 2009-05-22 09:02
Hi,

Can someone tell me how I can add an additional column to the accounting flexfield LOV? This is a key flexfield. I want to add the start date from the code combinations to be shown in the LOV.

Thanks for your help!!!
br
Guy
Quote
0 #83 M 2009-05-26 22:53
Great article!!!
Can you please e-mail me the dev guide at

Appreciate your help.
Thanks,
M
Quote
0 #84 Hrishika 2009-06-03 05:57
Hi Kali ,

Many thanks for the awesome article. I am new to WEB ADI . And I did follow all your step. After creating the integrator , Interface and Layout thru backend , I could update the layout but when I clicked on Create document the integrator list that comes up does not show me the custom integrator created by me .I did check in the tables as follows :
select * from bne_integrators _b where integrator_code like 'HXT_TIME_ASG_I NTG' order by creation_date desc

select * from bne_integrators _tl where integrator_code like 'HXT_TIME_ASG_I NTG'
order by creation_date desc

select * from bne_interfaces_ b where integrator_code like 'HXT_TIME_ASG_I NTG'
order by creation_date desc
select * from bne_interfaces_ tl where interface_code like 'HXT_TIME_ASG_I NTF' order by creation_date desc
and it shows records to be existing . At this step I am stuck and need your help .

Also , it will be great if you can send me the Developer Guide.My id is

Thanks,Hrishi ka
Quote
0 #85 Cesar 2009-06-04 12:38
Hi Kali

Thanks for taking the time to write this article.

Can I also please get a copy of the developers guide? Can't find it anywhere on-line.
My email is

Thanks Again!
Quote
0 #86 Ayaz 2009-06-17 02:41
Hello,
Can u please provide me the sample script to create an LOV on custom Integrator. Also I would like to know how to display cutom error message on excel sheet.

Thanks
Ayaz
Quote
0 #87 Ayaz 2009-06-17 02:42
Hello,
Can u please provide me the sample script to create an LOV on custom Integrator. Also I would like to know how to display cutom error message on excel sheet. My email address is

Thanks
Ayaz
Quote
0 #88 vinay kumar 2009-06-19 01:18
Hi kali,

i'm new to this web adi tool..i've a requirement...i 've a custom integrator..the re are 12 layouts in that..i want to restrict the layouts based on user type(full time/part time)is there any way to restrict the users?

thanks in advance
Quote
0 #89 vinay kumar s 2009-06-19 02:53
hi,

can u mail me the developer guide

Quote
0 #90 Kalimuthuv 2009-06-19 03:14
The Dev Guide is an Internal Document(Oracle ), which cannot be disclosed.
Sorr y for the inconvenience.

Thanks.

With Regards,
Kali.
Quote
0 #91 Ayaz 2009-06-19 07:47
Mr. Kali,
thanks for your effort. i have some queries:

1. Can we display out variable back on to excel ?
2. Can we return back to message field on excel excel when our record insert successfully ?

Thanks in Advance
Quote
0 #92 M 2009-06-30 13:42
Hi,

I am using 'Raise Application Error' to populate error messages in the Excel sheet while uploading data to APC. However, the messages are truncated to 100 characters. I have also tried to use 'FND_MESSAGE.RA ISE_ERROR however, I face the same problem. Please suggest why is this happenning and what can be done?

Thanks,
M
Quote
0 #93 Mario 2009-07-02 12:55
Hi Kali

great article!

Can I also please get a copy of the developers guide?
My email is

Thanks again.

Mario
Quote
0 #94 Zig Balodis 2009-07-09 12:30
Can you please provide a copy of the Web ADI developers guide.
Quote
0 #95 Zig Balodis 2009-07-09 12:35
I have created a custom integrator. Each account is validated using some custom validation rules, this works as expected,
valid lines have green icon, invalid lines the red icon, nothing gets uploaded. How can I perform a final validation after all detail
lines have been processed to check if the journals are balanced?
Quote
0 #96 Sushmitha 2009-07-22 15:41
Hi

I need to create a custom integrator, for doign this I am doing a simple integrator in which I can insert data into a custom table which I have defined already. When I am creatign a layout and updating the field it throws me an error by saying:

Inform ation

No columns have been defined in the column list.

Can you please let me know as how to proceed further from here. I am working on R12 web ADI

Thanks
Quote
0 #97 Kalimuthuv 2009-07-23 00:26
Hi,

Could you please check, you are creating the integrator and interface on a table or view.
If you are creating on a view, please change into a table and then check the issue.

Thanks.

With Regards,
Kali.
Quote
0 #98 Adish Jain 2009-07-26 06:10
Hi Kali,

Nice Article on Web ADI.

I am calling a custom Package from a a Custom Integrator. I need to diaplay the custom error messages from package to Excel sheet.

1. How to display the custom error messages to Excel Sheet Columns.
2. How to put LOV to Excel Sheet Column.

This is the urgent requirement. Kindly help me out. You can mail me solution to my mail ID also. It is

Regards
Adish Jain
Quote
0 #99 Yudhvir Singh 2009-07-27 10:32
Hi Kali.
Great article.
can you please e-mail Web-ADI developer's guide to
Thanks,
Yudhvi r Singh
Quote
0 #100 Ankit@erp 2009-07-27 10:33
HI Kali,

Thanks for the document.It is highly informative.

I need to update an existing lov with my custom one.

Basically the COA segments accounts,locati on,department are to be fetched from custom tables instead of the standard ones.
But when i checked the bne_interface_c ols table, the existing type for Segment1,Segmen t2 are not LOV"S.they are marked as flexfields.I wanted to know if we can change them to our custom LOV's too??

I basically need to fetch the values of department,loca tion etc from my custom table instead of the standard table.

Highly appreciate any pointers in this direction
Quote
0 #101 Yan Pechenik 2009-07-29 10:12
Thanks for putting together this web page tutorial. It was very helpful to me in setting up a custom integrator.
Can you please send me the Web ADI Integrator Developer’s Guide? I haven't been able to find it on metalink or otn. My email address is .

Also, I have the following question.
I was able to successfully create a custom integrator which calls a custom package for each row in the ADI spreadsheet and performs validation and returns error messages.
Now my problem is that each row in the ADI spreadsheet represents an invoice line which needs to be created. For invoices which have 2 lines, there are 2 records in the ADI spreadsheet. This makes it problematic to group the 2 invoice lines together and create a single invoice with 2 lines. Is there a way to have a package, concurrent request,... executed after the upload of the entire spreadsheet is complete?

Than ks,
Yan
Quote
0 #102 Paul Thien 2009-08-03 20:48
Hi Kali,
Can you email me a copy of the Web ADI developer's Guide to please?
Thanks for your help.
Paul
Quote
0 #103 Srinivas_r 2009-08-10 18:08
Hi ,
This article is really good and very informative. Can you please email me the WEB ADi developer's guide. I really appreciate your help.

Thanks
S rini
Quote
0 #104 Srinvas Rao 2009-08-11 11:46
Hi Kali,
Good article. I created a ADI interface for creating invoices and when I'm attaching LOVs as per the document you laid out. It works for one lov as soon as i add another pop list the ADI can't create a document and errors our. If I remove the secong POP List Lov it works fine. Is the procedure same for adding a STANDARD lov? When I tried to add a standard lov thru the procedure it's not showing up in the excel spread sheet. Can you please email me the Web ADI Developr's document to my address

Thanks
Srinii vas Rao
Quote
0 #105 Jags Viswanathan 2009-08-14 12:24
Kali,

Can you send me the WebADI developer user guide which does not exist at any Oracle sitse

Thanks
Quote
0 #106 Uma_P 2009-08-19 20:13
Hi Kali , Could you please email me a copy of the WebADI Developer User guide , I could not find it in any Oracle site. Thanks
Quote
0 #107 AkhilJain 2009-08-26 15:59
Hi Kali,
Can you please email me a copy of the WebADI Developer User guide.

Thanks,
Akhil
Quote
0 #108 mayur 2009-08-29 11:50
Hi Kali,
Can u please forward me the developer's guide

my id is :-

Thanks,
Mayur
Quote
0 #109 rohit kumar pandey 2009-09-02 09:21
Hi Kali,

Can you please mail me the metalink note for defining the importer. Actually, i am trying to replace the GL import program with a custom concurrent program. Thanks in advance.
My email id is :-

Regards,
Rohi t
Quote
0 #110 Nini1 2009-09-10 23:07
Hello Kali
Can u plz explain How u can create a Custom JAVA LOV for Web ADI

thanks
Quote
0 #111 P 2009-09-11 16:48
I think I found a way to get around the 100 character truncation issue.

So, I used the following code:

FND_MESS AGE.SET_NAME('B NE','WEBADI_ERR OR');
FND_MESSA GE.SET_TOKEN('M SG', 'error message goes here');
--FND_M ESSAGE.RAISE_ER ROR;

Just try commenting out the call to FND_MESSAGE.RAI SE_ERROR. This will prevent the eventual call to RAISE_APPLICATI ON_ERROR which truncates to 100 characters.

I think what happens is that whenever a message gets pushed onto the stack, the Oracle database treats this as an error state even if you don't invoke FND_MESSAGE.RAI SE_ERROR. When your program finishes running, I think it will return an error code and the message from the stack is also returned.

Hope this helps.

P
Quote
0 #112 siva_adi 2009-09-17 14:50
Hi Kali,

Could u please let me know how to add a total field in custom integrator. Eg If i have a enter_dr field and number of rows is
10 , how do i add a total field
Quote
0 #113 Iva Bartek 2009-09-23 17:19
Thank you for the excellent article. I'm having troubles with making my tabel LOV work. Could you please send me a copy of the WebADI Developer's guide?
Quote
0 #114 Kumar111 2009-09-28 02:00
Hi Kali,
Can you please email me a copy of the WebADI Developer User guide to email
?

I will also need some sample WebADI scripts.

Thank s
Kumar
Quote
0 #115 SergiuP 2009-09-30 04:38
Hi Kali,

Can you give me some information about how to secure a custom integrator so that it can be used only from one, or several responsabilitie s?
I've created a custom form function, which I've added to the custom menu associated with my responsability. I have set the BNE_ALLOW_NO_SE CURITY_RULE to No
and I used de "HR Maintain Integrator Form-Function Associations" to secure my integrator and assign it to the function I defined.
I must have missed something, because I still cannot se the integrator in the poplist when I select Create Document.
Also, I am using R12.1

Thank you
Quote
0 #116 Sreeabcd985 2009-10-07 04:30
Wonderful article. Although I've worked with standard integrators before, it was interesting to know about custom integrators.

E ven before I start working with custom integrators I have 2 questions:

1) Can we create a custom integrator to populate an interface table instead of passing the parameters directly to an API ?
( Let's suppose there is a standard import program to upload records from this interface table )
2) Let's say we want to upload data with a header-lines scenario. And let's say we have 2 different interface tables for headers and lines. Is it possible
to create a custom integrator for this scenario ?
( Let's suppose the single standard import program picks up records from both headers and lines interface tables )

Note: Please mail the sample web ADI scripts and Developer's guide to >>

Thanks and regards,
Sree
Quote
0 #117 Prashanth Rayaprolu 2009-10-09 10:03
Hi Kali,

This is a wonderful article. However, I am a bit lost as I am trying to create an Integrator for the Employee Assignment EITs for updating the records. I created one with an Update EIT API with package and procedure name. However, I am not sure of the other values required like the View Name. I wanted to create a DOWNLOAD Metadata Type for the EIT function so taht I can download the data, Update it and upload it back. I am not sure if this is possible. Can you help me with it please?

If you have any related document please email me at

Thanks & Regards,
Prasha nth
Quote
0 #118 Carmen 2009-10-28 03:52
Hello Kali,

Thanks for the article. Ii's very helpful.

I'm making a custom integrator for Proyect Management. I need to make some calls to the package: PA_CLIENT_EXTN_ BUDGET to calculate budgets.
Can i pick the data which the user introduces and call the functions (passing that data as a parameter). With the value returned by the function fill out other columns inside the spreadsheet.

P lease could you mail me the sample web ADI scripts and Developer's guide to:

thanks in advance! :)
Quote
0 #119 Sanjay Prasad 2009-10-29 01:08
Nice article, Thanks, I learn lot of new things from your WEB ADI article. Can you please send me the WEB ADI developer's guide to my mail id ' '

Regards,
sanjay prasad
Quote
0 #120 Thu Nguyen 2009-10-30 11:27
I would really appreciate if you could send the WEB ADI devl guide and the sample scripts. My email is .

Thanks
Quote
0 #121 Thu Nguyen 2009-11-04 11:06
We're thinking of implementing a custom budget system using Web ADI to download and upload data from spreadsheets that users will enter. The application will be heavily used by 100+ users during budget season (for about 3 weeks) and the data load will have about 500 records each. Is Web ADI a good fit or will we encounter performance issues?

Thanks
Quote
0 #122 terry 2009-11-11 22:48
Hello Kali,
Thanks a lot for your amazing article.
Would you please send me the Web ADI developer guide and sample scripts ?
My Email is .
Thanks again!

terry
Quote
0 #123 NGNEETU 2009-11-17 12:03
I have created a custom integrator which inserts records in custom staging table. I want to define a LOV for one of its field. When I tried the code that you have specified above, I get Jave null pointer error.

Could you guide me how to solve this issue?
Quote
0 #124 NGNEETU 2009-11-17 12:42
Could you mail me the WEB ADI documentation
Quote
0 #125 rafeeque 2009-11-24 06:35
I am trying to create an Upload integrator for AR. Used CREATE_INTEGRAT OR then CREATE_INTERFAC E_FOR_API and then CREATE_DEFAULT_ LAYOUT . The document created not showing any columns. It is only showing Upl and Message columns.
Please let me know whether I am missing anything.

Than ks in advance.
Quote
0 #126 Nalumachu 2009-12-08 17:18
I really appreciate your help here, I need sample scripts along with the developer guide so that I can fulfill a client requirement on creating custom Web ADI
Quote
0 #127 Nalumachu 2009-12-08 17:19
My Email is
Quote
0 #128 James Kim 2009-12-14 15:05
Hey Kali! This is James Kim.

So surprised to find your picture here....you're so famous now! hahaha.

Hope you're doing well..
Quote
0 #129 Roberto 2009-12-22 16:53
Hi,

Could you send me WebAdi Developer's Guide ()
and if you have some example where you want to add a validation to a Key Flexfield before to import using GL Journal Import WebADI ?

thanks in advance,
Roberto.
Quote
0 #130 Manojram 2010-01-04 12:35
Hi can some one send the webADI developer guide to my email ?

thanks
Manoj
Quote
0 #131 krish01 2010-01-04 13:30
can you please email me the webADI developer guide . my email id
Thanks
Quote
0 #132 Vijay Addanki 2010-01-08 15:21
I would really appreciate if you could send the WEB ADI devl guide and the sample scripts. Email address
Quote
0 #133 Krish01 2010-01-12 10:20
Hi,

I see that you mentioned having a global variable to track total. I tried doing that but it’s not working. Can you please elaborate more on how to know eof , how to total all rows to check if the total = 0 . And can you please email me DEV Guide at

------------- --------------- ----------
>>How do we determine the End of File..Once it has finished parsing through all the rows I have to total the amount
>>column in spreadsheet and make
>>sure total is greater than 0. If greater than 0 then only commit all the rows else rollback..

This can be done at your procedure, You can have a global variable and count every time of insert and if the total is

------------- -------------
Quote
0 #134 Dazza 2010-01-18 18:52
Hi Kali / anyone

Interes ting article, however I'm after a definitive yes/no answer as to whether you can create custom integrators for any module. E.g. Accounts Receivables has no seeded WebADI integrator defined (seeded integrators seem to be HR, FA, GL, and Projects only).

I am assuming the answer is Yes, in which case I'm happy. In this case, are these custom integrators ever over-ridden by patching?

In addition, if anyone has ever done this for AR invoices or receipts before then I would love to talk to you for some pointers!

Kind regards,
Dazza
Quote
0 #135 China 2010-01-19 15:17
Hi All

Can anybody please send me the Web ADI Integrator Developer Guide? I am searchig for that so long time, but I could not able to find it.
Thanks in Advance. Please help me out.

My Email ID:

Thanks China
Quote
0 #136 China 2010-01-20 14:29
Hi

Anybody have the Developer guide? please respond. Its urgent

Thanks
Venkat
Quote
0 #137 Kenny Miller 2010-01-25 10:50
I'd appreciate it if someone could email the Developers Guide to

Thanks,
Kenny
Quote
0 #138 akkirajukiran 2010-01-29 14:21
Could some body Please send me the Developers guide.

Thanks
Kiran
Quote
0 #139 akkirajukiran 2010-01-29 16:25
Could you please email me Developers Guide
Quote
0 #140 sri L 2010-02-01 17:20
Could you please email me "WEB ADi developer's guide"?
Quote
0 #141 Vish 2010-02-02 19:49
I'd appreciate it if someone could email the Developers Guide to
Quote
0 #142 AT 2010-02-10 20:53
I do really appreciate it if someone could email the developer guide
I also do have a question on how to create lov on parameters and use the lov to validate the entries
Thanks
Quote
0 #143 PrasannaNarayananMankali 2010-02-17 22:42
Hi Kali,
Though in couple of places i saw that this question came up, I could not find anywhere how they did it.

I want to submit a concurrent program right after the Upload is done ... How can I do it ?
or I want to know how many rows are there in the XL file that got uploaded ?

please let me know - my email id is

Thx a lot for your blog/website and instructions. it was pretty impressive.

Pr asanna.
Quote
0 #144 Vikas Pandey 2010-02-18 09:44
Hi Guys,

I am not able to see the changes in the layout after changing my package procedure.
The changes in layout columns are visible from backend in BNE_LAYOUT_COLS _VL but while defining the layout I am able to see the old laout only. I have cleared cache and tried again but no results.

I ll be thankfull if any one helps me out in this.

Regards,

Vikas
Quote
0 #145 Vikram S V 2010-02-24 04:05
Hi Kali,

A cery good material. I was able to create a custom integrator which calles a custom PL/SQL package. It would be of great help if you can send me the developer guide document.
We are trying a launch a concurrent program (A standard API) ofet the XLS uploads the data into an Interface table.

My mail ID is

Thanks,
Vikra m S V
Quote
0 #146 Sheila Najmi 2010-03-02 02:26
Hi Kali,
Am trying to develop a custom integrator that is identical to the Fixed Assets -Additions integrator...
The client wants to be able to update the FA Mass Additions table instead of insert.
I have been tring to locate the web adi developer's guide but didnt have any luck, is it on some oracle site(i work for oracle partner so if u tell me the site i will have access).
Am trying to find out how i can reuse the LOV's used by Assets inetrgator and call my custom package to do update to Mass Additions table instead of insert...
I have tried POPLIST and it works as per ur article but Key Flexfields cant really be POPLISTS..
Can u please help me out, i will really appreciate it
Thanks
sheil a
Quote
0 #147 John Trautman 2010-03-16 16:03
Hi: We created an ADI for uploading salary increases to Oracle HRIS. This worked until this year. Now we are getting the following error which doesn't really tell us where to look: The connection to the server is unavailable. Please contact your support representative. Where should I look first? Also if you could send me the developer's guide that would be helpful.
Quote
0 #148 Krishna B 2010-03-17 12:34
I am working custom Web ADI. I created a package and procedure. I want to Call API after loading all the records from Excel into PL/SQL Table. Please let me know if it is possible. I have Plan B to create custom table and load all the records in a table and then call API. I am not sure how to identify last record on Excel. Please let me know.


Thanks,

Krishna
Quote
0 #149 J 2010-04-17 13:04
Could you send me the example you have for creating a java based LOV please together with the developer's guide. Thanks.
Quote
0 #150 J 2010-04-17 13:10
My email id is .
Quote
0 #151 sayed Moinuddin 2010-04-22 13:13
Great could you please email the document

Thanks in advance
Quote
0 #152 sayed Moinuddin 2010-04-22 13:15
Kali we are getting the belwo problem can u please suggest....

On : 12.1.1 version, ATG Technical Issues

When attempting to create a WebADI document the following error occurs when the integrator selection screen is opened

ERROR
- --------------- -------
HTML Page is not created properly and the following Internet explorer error is fired

"Errors on this webpage might cause it to work incorrectly"

S TEPS
---------- -------------
T he issue can be reproduced at will with the following steps:

1:- Log into the application
2:- Choose the "Desktop Integrator" responsibility
3:- Choose Desktop Integrator >> Create Document

Thank s in advance
Quote
0 #153 Walter 2010-04-22 15:52
Kali

Your article was really helpful in filling in some holes. I cannot find the WebADI Developers Guide you referenced - could you please email me a copy?

email:

Thanks again for the great article.

-Walt er
Quote
0 #154 Uday Jadhav 2010-04-27 05:49
Hi,
I have written packaged procedure to execute after uploading the data in the interface. currently the data is getting uploaded but api is not working. where would be the problem.

thank s,
Uday
Quote
0 #155 Usha2345 2010-04-29 11:58
Hi Kali

Thanks for a great article. It gave me lot of insight on various Oracle web adi implementation options.

Can you please send me the Web ADI Integrator Developer’s Guide guide.

I appreciate your help.

Thanks a lot
Quote
0 #156 slokam_L 2010-04-29 17:55
Hi,

Did anybody get an answer for following question? If so can you please let me know , we need to implement the Total field in our custom Integrator.

== =============== =============== ==
Hi Kali,

Could u please let me know how to add a total field in custom integrator. Eg If i have a enter_dr field and number of rows is
10 , how do i add a total field
============== =============== ======

Thanks
slokam
Quote
0 #157 Karthik_Rajasekaran 2010-04-29 21:50
Hi Kali,

Your insight into the custom integrator development is excellent. Can you please send me a copy of the WebADI developer guide to my gmail id ? I would like to use WebADI custom integrators in R12.1.1. Is there a new dev guide for this version?

Regards,
Kart hik
Quote
0 #158 Wonderful document and thanks guys.Please send me the web adi developers guide for R12 2010-05-04 19:26
Wonderful document and thanks guys.Please send me the web adi developers guide for R12 to
Quote
0 #159 Vyagh 2010-05-19 09:15
Is there a way to create dependant LOV in Web ADI Spread Sheet.
My requirement is : I have two columns one is Proj number and Tack numbe columns. I created an LOV for Proj Number.
For Lov of Task number, i want all the tasks of the Project Number i selected in the other cell.

Please let me know the working scenario how to handle this.

Thanks
V yaghresh
Quote
0 #160 Vyagh 2010-05-21 07:37
Hi Kali,

Can you please send us teh Web ADI Developer's Guide to mail my
Quote
0 #161 Sachin Singh 2010-05-21 20:57
Is it possible to change the List of Values in the Standard integrators.
Quote
0 #162 Rubayat Newaz 2010-05-23 06:20
Dear Kali,

Can you please send me the web adi developer guide? Can you also tell me How can I load invoice into apps using xls files.

Regards
Rubayat Newaz
Quote
0 #163 hari krishna 2010-06-02 16:53
This article is very useful. Appreciate Web ADI developeres guid. I need to develop custom integator with custom API.

Please provide your inputs on this.

My email id:

Regards,
Hari
Quote
0 #164 kris 2010-06-12 12:29
I want to know abt the java default type implementation in the integrator
Quote
0 #165 Mukesh Singh 2010-06-17 10:43
I am unable to add LOV to custom web ADI. Please provide some handson material or guidelines.

I have followed you steps. But didn't work out.
Quote
0 #166 Sheena Sidhu 2010-06-23 16:55
I am on Web ADI 12i on Oracle 10g. On the spreadsheet, some rows error out. As per Oracle, no rows will load until all the errors
are fixed in the spreadsheet. But I am seeing that the ones w/o an error load fine, although there is no message against the
loaded records and the 'update flag' is not cleared. So the next time the file is upload again, the correct reccords that were
not supposed to load the first time, load again and error out.
Any ideas on how to fix this?

Thanks
Quote
0 #167 Pradeep.moganti 2010-07-05 07:12
Hi All,

I am trying to create a Web ADI for PA. Here I am using a view for downloading and uploading data. I am good upto this point. Now I have two challanges in my hand
1) I need to provide a LOV for a column which will take the major role in Update
2) I need to populate a message based on the Update statement.
So, please help to acheive these two challanges.
And please help me to get a developer guide
EMail :

Thanks,
Prade ep
Quote
0 #168 Sheena Sidhu 2010-07-05 09:17
Pradeep,
For #1, I know in 12i there are ways to do it as I have across documents on the web to do it, although I have not done it myself...

For# 2, I am not sure what you mean by. Can you please be more explicit? Is it the custom error messages you are talking about? If so, that ca n be done from within your pl/sql code by raising an exception.
Quote
0 #169 Pradeep.moganti 2010-07-05 10:19
Hi Sheena,

I am using Oracle 11i and I need some details about LOV's in Excel sheet.

I have to display some custom messages like ( Invalid Project Number) in the excel sheet. Can I acheive it trhough Raise_Applicati on_Error? If so, please provide me some basic systax to capture that message in excel and also please provide me some documents on this.

Thank You So Much,
Pradeep
Quote
0 #170 Pradeep.moganti 2010-07-06 05:59
Hi,

If I use Raise_Applicati on_Error() then the program will exit when ever an error occurs right?
Here I need to show messages for each line to show the status like Successful , Fail.

Please help me on this.

Thanks,
Pradeep
Quote
0 #171 Sheena Sidhu 2010-07-06 09:08
Pradeep, Web ADI does the success part anyway. Not sure how else you can change it to add a message there, I have never seen it been done before.
Will surely require a lot of research and development. Not sure if its worth the effort..A success is a success anyway. What the user should be more interested in is the errors!
Good luck!
Quote
0 #172 Pradeep.moganti 2010-07-07 08:06
Hi Kali,

I am searching for the Web ADI Developer Guide since very long time still I am not able to get any documet.
So, please send me Web ADI Developer Guide and some userful documents to me.
Mail ID :

Please.....

Th anks,
Pradeep
Quote
0 #173 Pradeep.moganti 2010-07-08 14:24
Hi All,

I got some errors while I am adding one LOV to the excel.

I have a view "pa_ra_invoice_ v" with "tag_value"

Now, I am updating the base table like this

UPDATE bne_interface_c ols_b
SET val_id_col = 'TAG_VALUE'
,val_mean_col = 'TAG_VALUE'
,val_type = 'TABLE'
,lov_type = 'POPLIST'
,val_obj_name = 'PA_RA_INVOICE_ V'
WHERE interface_col_n ame = 'P_TAG_VALUE'
AND application_id = 20011
AND interface_code = 'GENERAL_16_INT F'

But, while downloading the data I am getting some exception like "java.nullpoint er.exception"
and in the screen I am getting oracle.apps.bne .exception.BneF atalException - A system error has occurred.

So, If anyone aware of this error please help me to get a solution..

Tha nks,
Pradeep
Quote
0 #174 Manoveg Saxena 2010-08-02 01:24
Hi Pls mail me Web ADI developer guide and some working examples in java classes so that I can implement
depen dent LOV .

Thanks,
Manov eg
Quote
0 #175 Manoveg Saxena 2010-08-02 01:26
Hi Pls mail me Web ADI developer guide and some working examples in java classes so that I can implement
dependent LOV .
My mail id is

Thanks,
Manov eg
Quote
0 #176 sreekanths 2010-08-17 00:59
Hi Pls mail me Web ADI developer guide..its very urgent
Quote
0 #177 sreekanths 2010-08-17 01:01
Hi Pls mail me Web ADI developer guide..its very urgent to
Quote
0 #178 Leo Ameal 2010-08-19 09:11
Hi Pls mail me Web ADI developer guide..its very urgent
Quote
0 #179 Naveen Azad 2010-08-19 09:22
Hi,

I want to use WED ADI to upload Approved Cost Budget in Projects.

Plea se help me on this.

Regards,
Nave en
Quote
0 #180 Sheena Sidhu 2010-08-19 10:15
Naveen, ps be more specific what you need help with. Is it finding the right api or something else?

Sheena
Quote
0 #181 Ram M. 2010-08-25 09:23
We are on R12.1.1 and we would like to create a xls sheet bases om a simple sql query.

select invoice_num, creation_date from ap_invoices
whe re creation_date < ¶meter


So the xls output should look like


invoice created till : 10-AUG-2010 (¶meter)

i nvoice_num creation_date
- --------------- - --------------- ----
75893454 01-JAN-2010
435 74859 11-JAN-2010

et c...


We are not very familiar with WEBADI. Could you provide screenshot how to create such xls sheet?
We appreciatie your support.

Regar ds,
Ram
Quote
0 #182 Ram M. 2010-08-25 09:48
Could you send me the WEB ADI Developer Guide?

Thanks and regards,
Ram
Quote
0 #183 Kaouther 2010-09-10 12:17
Hi,
Very helpful article.
Can you send me the ADI developer guide and sample scripts to my e-mail address at
Best regards,
Kaouth er
Quote
0 #184 T Simkiss 2010-09-23 15:45
Very well written article. we are trying to create an AP integrator and have it working to load the headers and lines, but we can't create the java LOVs for any of the fields. If you could send some instructions on that it would be most appreciated.
Quote
0 #185 sajsanr 2010-10-01 11:31
Here is a working example that will help for simple LOVs:
UPDATE bne_interface_c ols_b
SET val_id_col = 'ORGANIZATION_I D',
val_mean_col = 'ORGANIZATION_N AME',
VAL_DESC_COL='ORGANIZATION_N AME',
VAL_OBJ_NAME = 'ORG_ACCESS_VIE W',
val_addl_w_c = 'RESPONSIBILITY _ID = $env$.respid AND RESP_APPLICATIO N_ID = $env$.appid',
VAL_TYPE = 'TABLE',
LOV_TYPE = 'POPLIST',
offline_lov_ena bled_flag = 'N',
mapping_enabled _flag = 'N'
WHERE interface_col_n ame = 'P_OPER_UNIT'
AND application_id = 20003
AND interface_code = 'GENERAL_8_INTF ';

the value retrieved is the id while in the spreadsheet the actual value is displayed.


2. If you want to change the column name display on the spreadsheet:


UPDATE bne_interface_c ols_tl
SET PROMPT_ABOVE = 'OPERATING UNIT'
WHERE
application_id = xxxxx
AND prompt_left = 'OPER_UNIT'
AND interface_code = 'INTF_NUM_INTF' ;

3. User hint for a column heading:


UPDA TE bne_interface_c ols_tl
SET PROMPT_ABOVE = 'AMOUNT',
USER_HINT = 'LINE'
WHERE
application_id = xxxx
AND prompt_left = 'PARM_AMOUNT'
AND interface_code = 'INTF_NUM_INTF' ;

4. Once the changes are commited, in order to view these, apache services need to be bounced.

5. Issues noted.
256 rows are only retrieved. If any suggestions on how to extend this, will appreciate the information for R12.
Quote
0 #186 Tina 2010-10-21 06:22
Hello,

Very helpful article.
Can you please send me the web adi developer guide?
My Email is :

:D
Quote
0 #187 vasu 2010-11-07 06:50
Dear i am having 11.5.9 version. I want to download employee data (hrms) based on time period id(parameter) can you please suggest me how to do this. Because i am not understanding where i have to give parameter user need 2 parameters like time_period_id and employee_no based on this they want to download data. please mail me steps.
Quote
0 #188 vasu 2010-11-07 06:53
Dear i am having 11.5.9 version. I want to download employee data (hrms) based on time period id(parameter) can you please suggest me how to do this. Because i am not understanding where i have to give parameter user need 2 parameters like time_period_id and employee_no based on this they want to download data. please mail me steps.
Quote
0 #189 VosKon 2010-11-26 05:29
Can anyone help me with Web ADI?
I have system administrator responsobility, but our users haven't, and so they can't call function and create web adi document. They get error like below.
"Please resolve the following error to continue.
140:X XFA_BNE_TEST_IN TG is an invalid Integrator Key."

I thought that error is in profile iptions, responsobilitie s, application_id in my integrators.

I'm sorry about mistakes in my english..
Quote
0 #190 Kish 2010-12-01 02:07
Can anyone suggest me a work around to use Web ADI for asset additions where we have the employee numbers as alpha-numeric values, but the web ADI is throwing as error saying "Enter only numeric values" for Employee Number field.

Thanks in advance.
Quote
0 #191 cheran 2010-12-22 07:59
Hi Kali,

We are trying to upload CRV in a new instance, we created Custom integrator layout in WEB ADI, when we are trying to select the integrator it is not available in the LOV. so we created custom function but when I click this function it is showing noserach found.

could you please explain which step we missed to use the layout while creating document time.

Regards
Cheran
Quote
0 #192 Amit garg 2011-01-13 00:55
hi,
i want to design dependent lov ..please send the sample java class file and developer guide to
it surgent

Amit
Quote
0 #193 Pal 2011-01-18 05:20
Hi,

I need developer guide for web ADI..Pls do send me
But very well defined and elaborated above description.

T hanks,
Pallavi
Quote
0 #194 sajsanr 2011-02-03 10:05
Here is how to go about creating standard LOV or poplist.
If you have created custom ADI using Desktop Integrator; and in R12 if you want to create a component and add it to the the custom integrator; there is a bug in Desktop Integration Manager. It flags these integrators as 'Oracle' and due to hardcoded security rules, one cannot update. If any one has any information on how to disable that security feature, a post is welcome.

The API works well.

-- BNE_INTEGRATOR_ UTILS.CREATE_TA BLE_LOV --
-- (P_APPLICATION_ ID => 231, --
-- P_INTERFACE_COD E => 'MY_INTERFACE', --
-- P_INTERFACE_COL _NAME => 'COL_NAME', --
-- P_ID_COL => 'LOOKUP_CODE', -- LOOKUP CODE UPLOADED --
-- P_MEAN_COL => 'MEANING', -- Shown in sheet --
-- P_DESC_COL => 'DESCRIPTION', --
-- P_TABLE => 'FND_LOOKUPS', --
-- P_ADDL_W_C => 'lookup_type = ''FND_CLIENT_CH ARACTER_SETS''' ,
-- P_WINDOW_CAPTIO N => 'Yes/No/All with Meaning and Description, selecting Meaning, Meaning sortable',--
-- P_WINDOW_WIDTH => 400, --
-- P_WINDOW_HEIGHT => 300, --
-- P_TABLE_BLOCK_S IZE => 10, --
-- P_TABLE_SORT_OR DER => 'yes,no', -- sortable by meaning, not description--
- - P_USER_ID => 2,
-- P_POPLIST_FLAG => 'Y' --- this by default is null and results in Table based LOV, if set to 'Y', it will result in POPLIST.
); -- SEED USER --
-- --

Assuming, you had created your spreadsheet thru Desktop Integrator.
a. p_application_i d can be looked up as defined in the bne_interface_c ols_b.applicati on_id.
b. p_interface_cod e will be in bne_interface_c ols_b.interface _code column.
c. p_interface_col _name will be in bne_interface_c ols_b.interface _col_name
d. p_id_col, p_mean_col, and p_desc_col are self explanator; the p_desc_col is useful if you want to have a description column so that users can make informed choice.

For standard lov, you need not have p_poplist_flag in the parameter list. If you want a poplist, then this needs to be set to 'Y' as noted above. No hardcoded update to bne_interface_c ols_b is required to make this as a POPLIST.

Pleas e note, a poplist will result is 256 row limit.

Once the changes are executed, bounce apache services before generating the spreadsheet.

Thanks
Sajid
Quote
0 #195 Jeroen 2011-02-04 00:57
Hi Guys,

I developed my own PL/SQL wrapper to upload Web ADI data.
Works great... if no exceptions occur.
However, if they do occur I only get one error in the Messages column:

"SQL exception occurred during PL/SQL upload."

I tried:
hr_utility.set_ message (808, 'XXLCHXC_WEBADI _GRADE_NF');
hr_utility.set_ message_token ('ERR_MSG' , p_error_message );
hr_utility.rais e_error;

I tried:
FND_MESSAGE.SET _NAME('BNE','WE BADI_ERROR');
FND_MESSAGE.SET _TOKEN('P_UPD_F ILE','HELLO 123',false);
FND_MESSAGE.RAI SE_ERROR;

but it seems WebADI is overwriting my custom errors in some way.
Am I missing something?
Quote
0 #196 Sheena Sidhu 2011-02-04 15:12
Hi- try using: raise_applicati on_error(-20000 ,'ur custom mesg');
Quote
0 #197 pal1901 2011-02-11 07:14
Hi ,

I need the DFF columns in WEB ADI as it is there in ADI....can u please let em know how and wheer it is done.It would be great help.

Thanks,P allavi
Quote
0 #198 sam.jmd 2011-02-15 19:40
Hi
Thanks for this excellent article

I have a question regarding standalone integrator (not associated to a function form). This is a "GENERAL" integrator; we are not supposed to call it form a screen.

I duplicate the BNE_CREATE DOCUMENT function and setup the parameters (calling the integrator_code )

And I added this function to a menu; I can call my new integrator.

Wh at is the usage of the seeded integrator : HR Maintain standalone query" ?

Thank you
seham
Quote
0 #199 ariel 2011-03-02 11:10
Hello Kali,
Can you please send me the dev guide and sample scripts ?

Thank you,
Ariel
Quote
0 #200 Vikram 2011-03-09 05:36
Its a great article ..

I want to use web adi for Class enrollments in OLM. We are having all the data in excel. So our users are asking interface to load it direclty to the OLM enrollments for a class.I am not sure whether we can use web adi for OLM or not .. because .. OLM enrollments are not form based .it is jsp page .. and more over we are currently in 11.5.10.2 version whethere there is no standard API for enrollments . Can you please guide me how can i achiecve solution for this requirment .

Thanks in advance
Regards
Vicky
Quote
0 #201 Sateeshapp 2011-03-18 01:06
Hello Kali,

This is a Excellent article. We are planning to develop the Custom integrator for uploading the AP invoices

Can you please send me the dev guide and sample scripts?

Regards
Satee sh
Quote
0 #202 Sateeshapp 2011-03-18 01:10
Hi Kali,

My email id is .

Please send the WEBADI devloper guide and sample scripts.

Regar ds
Sateesh
Quote
0 #203 Igor 2011-04-03 03:12
Hi, Kali,
Great article!
Can you please send the sample script & the developer guide for Web ADI to > ?
Thanks.
Regards,
Igor
Quote
0 #204 Uprale 2011-04-15 15:13
Hi Kali,
Thank you for the article. I am trying to create the LOVs for WEB ADI, could you please send me those sample java files.
Thanks in advance.
Pramod Uprale
Quote
0 #205 VRaju 2011-04-20 07:46
Hi..

Great article. Can you please tell us how to find the total number of records entered in the spreadsheet.

A lso, is there a way to stop any record from getting uploading even if one record is in error.

Thanks in advance,
Vidya.
Quote
0 #206 Vijay Nurani 2011-04-28 16:05
Kali,

Is their need to have PLM installed for loading items?
Quote
0 #207 VijayN 2011-04-29 08:29
Hi Kali,
I have 2 questions. From your article it looks like you can create WebADI for any open API. Is that true? For Item load /update do you need PLM installed?
Quote
0 #208 herdanto 2011-05-16 00:28
Hi
I'm using 11.5.10 and the WEB ADi has not been working for excel 2007 yet. I've been able to create a layout but when I opened the layout, I get a pop up window saying "Your document is being created" and it stays there forever...
the document created has .xls extension and not .xslx like 2007 extension.
I have followed the setup as you recommended above.
Currentl y I have no idea what went wrong.. can anyone help me please... thank you.
regards
He rdanto
Quote
0 #209 kalimuthu V 2011-05-16 01:44
Hi Herdanto,
For excel 2007 check you have done the mentioned changes in the URL,
http://appssupport.com/2010/05/07/working-with-web-adi-and-excel-2007/

And try from IE browser.

Thank s,

With regards,
Kali.
Quote
0 #210 xyz1 2011-05-19 09:31
When uploading Asset using Additions Integrator getting Error "Enter a valid Employee Number."
Please suggest how to accept alphanumeric Employee Numbers

Regard s,
Rahul
Quote
0 #211 RKGMAIL 2011-06-17 19:24
I have a custom integrator and would like to display the error messages for the failed records. Could you guide me what are the things that we need to do on the ERRORED_ROWS step to see the error messages on the spreadsheet. The user guide is not that helpful. THanks.

We are in R12 - 12.1.3. Custom Integrator calling a custom PL/SQL API as an interface.
Quote
0 #212 Alex Reyderman 2011-07-11 17:28
Great article! This is the most comprehensive and detailed description of the process that found thus far. I'm looking to build a custom intergrator for AP invoices. If you have any code samples for it and you can share them I would highly appeciate it! Also, can you please send me a copu of Web ADI developer's guide? I do not see it included with Oracle R12 documentation.
Thanks a lot!!
Alex Reyderman
Quote
0 #213 saravanan.j 2011-07-17 12:35
Hi gurus,

We upgraded from 11.5.9 to 12.1.3 and we already created some Letter request in HRMS using ADE and now upgradation, it is not working. Giving Error as ":oracle.apps.b ne.exception.bn efatal.exceptio n" and also we are not able to create Integrator also. Any idea about this ?.
Hope now ADE is not available and WEbAdi came into the picture.

Thank s
Quote
0 #214 Chandra123g 2011-07-26 17:43
Hello, Thanks for a nice article. I am trying to understand if I can add some additional validation to the existing pre-validation to a copy of a seeded Oracle web ADI...Please assist. Can you also send me the Web ADI Developer Guide to ? Thanks
Quote
0 #215 nabil 2011-09-07 03:05
thanks for sharing your knowledge.. this was helpful...
i would appreciate if you send me the ADI developer guide and sample scripts to

regards
Nabil
Quote
0 #216 nabil 2011-09-27 23:59
Hi...
i would appreciate if anyone can send the developer guide to

regards
nabil
Quote
0 #217 KRama 2011-10-03 03:33
Hi Kali ,

Could you please email me a copy of the WebADI Developer User guide and sample scripts for HRMS salary_proposal _api to

Regards
Ramar ao
Quote
0 #218 topbagscenter 2011-10-13 03:48
It's good to see this information in your post, I was looking the same but there was not any proper resource, thanks now I have the link which I was looking for my research.
topbagscenter
Quote
0 #219 Swarna Gowri 2011-10-13 06:23
Hi,

I have a problem where a User has uploaded data through Web ADI in a date format MM/DD/YYYY.
But when the User uploads an error comes in the validation and date is trasnformed to format MM-DD-YYYY.

As per the logic date from sheet would format to DD-MON-YYY after the upload is successful.
Whe n I upload the same file,the dates are in correct format in Interface Table.(DD-MON-Y YY)

User and myself are using Excel 2007.
I am unable to reproduce the Issue he faces because the same file works for me.

Any help in this regard would be highly appreciable.

T hanks,
Swarna
Quote
0 #220 Aannatjot 2011-10-14 16:31
Hi Kalimuthu ,

I am looking for a solution to Define 10K Mass Allocation Formula in r12. I am functional consultant with only SQL knowledge to suffice my needs.
Is there any source or sample document , which i can use to build WEB ADi Integrator for my requirement.

A nantjot
Quote
0 #221 debarchan 2011-10-17 16:45
We are in R12.1.1. We have facing following problems;

1. ORG_NAME LOV from HR_OPERATING UNIT. Using above dummy LOV not appearing on document.
2. Select Customer name & account number depending on ORG_NAME using LOV separately.
3. Separate LOV for Transaction Type depending on ORG_NAME.
4. One Date LOV.
5. One LOV for account code combination.

P lease help to resolve this LOV related.
Quote
0 #222 Ravinder R 2011-10-18 03:35
Hi Kali,

I am developing interface using web adi. I am able to create LOV using table. But not able to create LOV using KFF for account flexfield.

In my requirement i need to submit the Import program as well. Once all the records validated and inserted then only we need to submit the import program.

I am facing 2 issues.

1. Not able to create LOV using KFF for account flexfield.
2. How to count the records in excel template, which are validated and successfully uploaded to interface table.

Please hlep me.

Thanks
Ravinder
Quote
0 #223 michael kors tote 2011-11-16 00:45
michael kors outlet
michael kors toteIt makes me feel so surprise.I never know there is such a place that I can find The site offers different kinds.
Quote
0 #224 suni 2011-12-14 00:31
hello,

Please send me the sample script . my email id :

Thanks
Sunil
Quote
0 #225 suni 2011-12-19 02:25
hi,

I have built a custom integrator to insert values into custom table. i have one query..

1. I am unable to create the document.. When i click on create document button, excel opens and after some time i see the error in my jsp pages..

Thanks
Sunil
Quote
0 #226 Ajs 2012-02-15 11:21
Is there standard web ADI for loading manual journal entries into FAH ?
Quote
0 #227 Nupur Garg 2012-02-21 04:13
Hi,
Is there a way to create dependent LOV in excel sheet?
Please can you mail me the steps.

Thanks,
Nupur
Quote
0 #228 AppsDeveloper 2012-03-06 23:01
We run a report out of Oracle ADI which is used for overall GL account review and tie-out of our file transfer to Essbase. There were new GL accounts added to Oracle in February. How do I change the report parameters to pull these new accounts?
Quote
0 #229 VikasMehra 2012-04-25 01:25
Hi,

I modified a standard integrator 'Project - Transaction Import'. I modified the Layout also accordingly. But when i go to Create Document, same integrator is not coming in the list. I did bounce the Apache and OA core but still i could not able to see same integrator in create document list. Can you please let me know what I could do to show that integraotr in create document list.

Any kind of help will be highly appriciable.

T hanks,
Vikas
Quote
0 #230 SaurabhGoel85 2012-05-01 13:47
This is a great article no doubt it helped me a lot.
But still I am facing following issue.

1. Columns I defined as POPList displays a dropdown with limited number of values. The Dropdown is for employee names. We need search ability for the same hence dropdown will not help me could you please suggest what could be possibly wrong.
Code used is
UPDATE
BNE_INTERFACE_ COLS_B
SET
VAL_ID_COL = 'PERSON_ID',
VAL_DESC_COL = 'FULL_NAME',
VAL_MEAN_COL = 'FULL_NAME',
VAL_TYPE = 'TABLE',
LOV_TYPE = 'POPLIST',
VAL_OBJ_NAME = 'PER_ALL_PEOPLE _F',
VAL_ADDL_W_C = 'SYSDATE BETWEEN EFFECTIVE_START _DATE AND NVL(EFFECTIVE_E ND_DATE,''31-De c-4712'') and CURRENT_EMPLOYE E_FLAG = ''Y''',
OFFLINE_LOV_EN ABLED_FLAG = 'N'
WHERE 1=1 AND APPLICATION_ID = 200
AND INTERFACE_CODE = 'JHA_AP_CARD_AD ILOAD7_INTF'
AN D INTERFACE_COL_N AME like 'P_EMPLOYEE_NAM E'

Regards
Sau rabh Goel
Quote
0 #231 SaurabhGoel85 2012-05-01 15:22
Continuing previous post.

2. I have defined the Poplist for yes and no using a value set but the same is not appearing in the excel while all other lov's are appearing on the excel.
UPDATE
BNE_INTERFACE_ COLS_B
SET
REQUIRED_F LAG = 'N',
VAL_ID_COL = 'FLEX_VALUE_ID' ,
VAL_MEAN_COL = 'FLEX_VALUE',
V AL_DESC_COL = 'FLEX_VALUE',
V AL_TYPE = 'TABLE',
LOV_TYPE = 'POPLIST',
VAL_OBJ_NAME = 'FND_FLEX_VALUE S',
VAL_ADDL_W_C = 'FLEX_VALUE_SET _ID = 1010300',
OFFLI NE_LOV_ENABLED_ FLAG = 'Y'
WHERE 1=1 AND APPLICATION_ID = 200
AND INTERFACE_CODE = 'JHA_AP_CARD_AD ILOAD7_INTF'
AN D INTERFACE_COL_N AME like 'P_PAPER_STMT_W ANTED'

3. I need sample files for creating dependent LoV's

If someone can help I would really appriciate the same.
You can mail me samples at

Thanks and Regards
Saurabh Goel
Quote
0 #232 andrushell 2012-05-14 09:38
Could anyone describe the steps for implementing java LOV's, some scripts examples ... .
It would be very helpful. Share your experience.
Tha nks.

If someone would like to help me, email me at
Thanks.
Quote
0 #233 Ravi Manchu 2012-07-05 06:52
Hello,

We have one requirement to restrict the LOV values based on certain condition.So when i checked it is JAVA LOV.So can some one guide me how we can acheive this requirement.

T his is the standard webadi integrator.



Regards,
Ravi M
Quote
0 #234 Ravi Manchu 2012-07-05 06:52
Hello,

We have one requirement to restrict the LOV values based on certain condition.So when i checked it is JAVA LOV.So can some one guide me how we can acheive this requirement.

T his is the standard webadi integrator.



Regards,
Ravi M
Quote
0 #235 Deepak Kandpal 2012-08-23 01:06
We can use Java APi to create JAVA LOV.. here is the code



-- LOV for Project
bne_integrator_ utils.create_ja va_lov(p_applic ation_id => v_application_i d,
p_interface_cod e => v_interface_cod e,
p_interface_col _name => UPPER ('p_c_project_i d'),
p_java_class => 'oracle.apps.xb ol.excelupload. lov.XxneProject Lov',
p_window_captio n => 'Project',
p_window_width => 400,
p_window_height => 400,
p_table_block_s ize => 10,
p_table_columns => 'FLEX_VALUE,DES CRIPTION',
p_table_select_ columns => NULL,
p_table_column_ alias => NULL,
p_table_headers => NULL,
p_table_sort_or der => 'YES',
p_user_id => fnd_global.user _id
);
Quote
0 #236 Gaurav Kumar 2012-08-29 13:04
Hi Kali.

Great article. It seems very helpful to me.
I need to know some technical information about web adi like,
In a custom web adi, we can know the procedure name used from the table 'BNE_INTERFACES _B' as the field 'INTERFACE_NAME ',
but can you tell me from where we can get the package name. because with the same procedure name there can be many package.

Then how can we decide which package is using in web adi.

Thanks,
G aurav
Quote
0 #237 Nageshwar Reddy 2012-11-01 14:07
Hi ,

Good Morning everyone...
I am working in R12.
My Custom WEB ADI 11i Templates are not working in R12.
Please let me know is there any steps to resolve the issue.
Thanks and Regards,
Nagesh war Reddy Porla.
Quote
0 #238 Jinal Shah 2012-11-26 08:32
Hi,

I am new to web ADI and facing problem in the following:

I have created the parameterized web ADI report using “HR Create Standalone Query “Integrator. However, by this we can only add 5 parameters. Can anybody suggest how to add more than 5 parameters in the web ADI report?
Quote
0 #239 Pradeep Rayapudi 2013-01-09 15:00
Hi Kali,

Great article. It seems very helpful to me. I am facing the following problem while developing a custom integrator. Please help me in this regard.

I am developing a custom integrator for uploading AP invoice. After creating the custom integrator following the steps as given in your article, i defined layout for the new custom integrator. But when I click on 'Create Document' in Desktop Integration responsibility, the custom integrator is not visible in the select integrator drop-down list. So I am unable to create the document.

Do I need to bounce the Apache? or some thing else

Please help.

Thanks,
-Prad eep.
Quote
0 #240 vijay_b 2013-03-29 12:23
Please could you help me to achieve the below functionality using WEB ADI ?
My requirement is like to load large data from Excel sheet to Oracle Tables.
Validat e the loaded data, It has to allow to review data and it also to update the data.

Please help me.

Thanks,
Vi jay
Quote
0 #241 vijay_b 2013-03-29 12:25
My work environment is 11.5.10
Quote
0 #242 Rajan M Kalam 2013-12-12 17:37
Hello Kali,
Great article, I owed a lot to you. :)
What is the PL/SQL package/procedu res for the "General Ledger- Journal" integrator? What is the table that the integrator?
If I need to modify the Journal Integrator in Web ADI, how can i achieve this? For example, I don't need to upload all field to the table, change the integrator name to e.g., XXXGeneral ledger - Journal--in the dropdown list of 'Integrator' field.

Also, would you please send me the sql for the Interface (step2) and default layout (step 3)?
Thank you,
Rajan K M
Quote
0 #243 saranya 2014-07-08 13:30
Hi,

My requirement is to add additional field to the integrator. I have modified the integrator and its corresponding package. And I have changed the layout to use the added field. Now when I upload the layout, am getting Exception during parsing of uploaded document.

Can any of you please help to resolve this error.

THanks
Quote
0 #244 NRaghavan 2014-08-07 04:47
How to know the total number of rows uploaded?
User uploads in validate mode and uploads the same set in validate and import mode. Duplicate sets of records are getting imported.

How to get to know in plsql the total no of records uploaded?
Quote
0 #245 Hari V 2014-09-01 06:20
Hi Kalimuthu,

I've two custom integratos Customer WebADI & Contracts WebADI for uploading the data. My rquirement is, if the user wants to uplod Customer data the only that integrator should be displayed in the LOV of the Integrator page. The contracts integrator should not be displayed in the LOV and vice-versa.
Is this possible, if so kinldy let me know.
Quote

Add comment


Security code
Refresh


Make Training Enquiry

  •  
* required information
 

LOGIN

DEMO INFORMATION

All content and images shown on this site is for demo, presentation purposes only. This site is intended to exemplify a live website and does not make any claim of any kind to the validity of non-Shape5 content, images or posts published. 

Photography is used for this demo only, and is not included with this template or any membership. You may not use these images for your own without purchase. Links to purchase from their copyright owners will be provided.