Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

Blogs
  • Register

Oracle Gold Partners, training schedule is listed here designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

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

 


Kalimuthu Vellaichamy

Overall Rating (0)

0 out of 5 stars
  • Guest - Anton Alexeyev

    Intresting article, but are u able to create integrator with LOVs like in standart integrators?

    3 Like
    Short URL:
  • 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.

    0 Like
    Short URL:
  • 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_array_t (xxbne_cols_t ('P_TEST_ID' -- NAME_package
    ,'TEST_ID' -- NAME_view
    ,'test_id' -- CAPTION
    ,'pay_element_types_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_APPLICATION_VL' -- obj_name
    ,'' --addl_w_c
    ,'APPLICATION_SHORT_NAME' --id_col
    ,'APPLICATION_NAME' --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_integrator_utils.create_integrator (p_object_code
    ,p_integrator_user_name
    ,p_api_package_name
    ,p_api_procedure_name
    ,p_view_name
    ,p_lov_list
    );

    And i have a question. Are u able to create LOV with more then 3 columns??

    0 Like
    Short URL:
  • Anton,

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

    Thanks.

    With Regards,
    Kali.

    2 Like
    Short URL:
  • Nope can u have a more then 3 columns in ur Java functio based LOV?

    0 Like
    Short URL:
  • Guest - AboutOracleApps

    Great article.


    --Chris Martin

    2 Like
    Short URL:
  • Guest - ram c

    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

    1 Like
    Short URL:
  • Guest - rekaprasannakumar

    Can we use this feature to load AP Invoices using Web ADI?

    0 Like
    Short URL:
  • Guest - Tubai

    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.

    Please help.

    1 Like
    Short URL:
  • Guest - Kali

    Hi,

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

    With Regards,
    Kali.

    0 Like
    Short URL:
  • Guest - Kali

    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

    1 Like
    Short URL:
  • Guest - Kali

    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.

    1 Like
    Short URL:
  • Guest - Kali

    rekaprasannakumar ,

    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.

    0 Like
    Short URL:
  • Guest - somisettyramana

    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 somisettyramana@rediffmail.com.

    Thanking you,
    Ramana.

    1 Like
    Short URL:
  • Guest - somisettyramana

    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.

    0 Like
    Short URL:
  • Guest - Kali

    Ramana,

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

    That gives more info.

    Thanks.

    With Regards,
    Kali.

    1 Like
    Short URL:
  • 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.

    Kali
    Hey, can u email me this java Based Lov sample too plz??
    W wiil gave u may package for integrator creation.

    0 Like
    Short URL:
  • Guest - Rehan Yusuf

    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

    0 Like
    Short URL:
  • Guest - Kali

    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.

    Thanks.

    Give

    1 Like
    Short URL:
  • Guest - Shailaja

    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 ?

    2 Like
    Short URL:
  • Guest - Shailaja

    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 ?

    0 Like
    Short URL:
  • Guest - Kali

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

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

    1 Like
    Short URL:
  • >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

    0 Like
    Short URL:
  • Guest - Shailaja

    Thanks Kali. my email id is baligas@gmail.com

    0 Like
    Short URL:
  • Guest - Kali

    >>Thanks Kali. my email id is
    '> baligas@gmail.com
    I sent the document to you.

    Please check.

    Thanks.

    With Regards,
    Kali.

    0 Like
    Short URL:
  • Guest - vivien

    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 $ */

    0 Like
    Short URL:
  • Guest - Kali

    Hi

    Can you give your email id.

    Thanks.

    With Regards,
    Kali.

    0 Like
    Short URL:
  • Guest - vivien

    yes, my email id is: vivienlam@cox.net

    0 Like
    Short URL:
  • Guest - Pri

    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 priyunmita@rediffmail.com?

    0 Like
    Short URL:
  • Guest - somisettyramana

    Hi,
    Can you please provide your gmail id. I lost it.

    Thanks,
    Ramana.

    0 Like
    Short URL:
  • Guest - Kali

    Sent a test mail to you.

    With Regards,
    Kali.
    OSSI.

    0 Like
    Short URL:
  • Hey m8s.
    Can anyone tell me how can i create a read only or hidded column in my integrator??

    1 Like
    Short URL:
  • I was found u can control it in bne_interface_cols_b table.
    But it's work realy bad -- if u setting up a Read_only flag -- it's clear it after user editing.

    0 Like
    Short URL:
  • Guest - Pri

    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 priyunmita@rediffmail.com,priyunmita@gmail.com.

    1 Like
    Short URL:
  • Guest - Sneha

    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_APPLICATION_ERROR(-20001,V_MESSAGE);

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

    Thanks

    1 Like
    Short URL:
  • Guest - Rehan Yusuf

    Hello Kali,

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

    regards,
    Rehan Yusuf

    1 Like
    Short URL:
  • Guest - Rajteva

    Hi Kali,

    Can you please email me the web adi developer guide to rajteva@yahoo.com.

    Thanks

    Raj
    ---------

    0 Like
    Short URL:
  • Guest - Rajteva

    Hi Kali,

    Can you please email me the web adi developer guide to rajteva@yahoo.com.

    Thanks

    Raj
    ---------

    0 Like
    Short URL:
  • Guest - veni

    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 triveni_reddy@yahoo.com

    Thanks in advance
    veni

    0 Like
    Short URL:
  • Guest - Jake

    Can I also get a copy of the developers guide? Can't find it anywhere on-line. jake_r_walsh@hotmail.com Thanks.

    0 Like
    Short URL:
  • Guest - Rosemarie Vitales

    Can I also get a copy of the developer's guide. My email is cfvitales@verizon.net

    0 Like
    Short URL:
  • Guest - Priscila Moreira

    Could you send me a copy of he developer's guide too.
    My e-mail: pri_480@oi.com.br
    Thank´s

    Priscila Moreira

    0 Like
    Short URL:
  • Guest - Jerry

    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 jerry_rijanto@yahoo.co.id

    0 Like
    Short URL:
  • Guest - GeorgeS

    Hi Kali,
    Excellent article. Please send me the WebADI Developers Guide.

    My email: gshugrue@copyright.com

    Thanks,
    George

    0 Like
    Short URL:
  • Guest - sudhir

    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

    0 Like
    Short URL:
  • Hi Kali,

    Can you please mail me the developer guide document?
    navinchris@gmail.com.

    Thanks a lot.
    Navin.

    0 Like
    Short URL:
  • Kali,

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

    Thanks.

    Navin.

    1 Like
    Short URL:
  • Guest - Abhishek1

    Hi Kali,

    Please send me the user guide on my email address abhishek.govil@gmail.com.

    Thanks much!
    Abhishek

    0 Like
    Short URL:
  • Guest - Geethana

    Hi Kali,
    Please send me the ADI developer guide and the sample script to my e-mail address geethana@optusnet.com.au

    Thanks a lot!

    Geetha

    1 Like
    Short URL:
  • Guest - Sneha

    Does Poplist work with Excel 97 for webadi ? does anyone know ? I cant test this because I dont have Excel 97 in my machine.

    1 Like
    Short URL:
  • Guest - Lokesh

    Hi Sneha,

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

    if so can you pls share with us.

    0 Like
    Short URL:
  • Guest - Sneha

    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.

    0 Like
    Short URL:
  • Hi Kali,

    Can you please send me the web adi developer guide.

    Thanks
    R.Dillibabu

    0 Like
    Short URL:
  • Guest - veerakm

    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 '> kmveeru@yahoo.com
    Thanks in advance
    veera

    0 Like
    Short URL:
  • 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

    0 Like
    Short URL:
  • Guest - Aleksandar

    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,

    Aleksandar

    2 Like
    Short URL:
  • Guest - Aleksandar

    Hi,

    Can you please send me the web adi developer guide.
    aleksandarkokanovic@yahoo.com

    Thank you,
    Aleksandar

    0 Like
    Short URL:
  • Guest - Aneel kumar

    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.

    Thanks,
    Aneel

    0 Like
    Short URL:
  • Guest - Abdul Rahman

    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 abdul.rahman2k@gmail.com, 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-Function name, and select the type as " SSWA servlet function'' and in the parameters column enter '' bne:page=BneCreateDoc&bne:viewer=BNE:EXCEL2003&bne:reporting=N&bne:integrator=GNE:GENERAL_81_INTG&bne:layout=GNE:GNE_SHIPMENT&bne:content=GNE:GENERAL_81_CNT&bne:noreview=Yes "
    And the HTML call will be "oracle.apps.bne.webui.BneApplicationService''

    in the Parameters column

    we got the integrator name ''GNE:GENERAL_81_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_SHIPMENT'' from Selcet USER_NAME from BNE_LAYOUTS_TL;

    we got the content name ''GNE:GENERAL_81_CNT'' from Select CONTENT_CODE from bne_contents_tl;

    good work guys.

    Abdul Rahman
    P.S : Please mail developer guide to abdul.rahman2k@gmail.com

    0 Like
    Short URL:
  • Guest - JOSE FERREIRA

    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 (ferreira_alex@yahoo.com)

    0 Like
    Short URL:
  • Guest - Syed_ZN

    Hi Kali

    Appreciating 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 syedzn@gmail.com.

    Thank you
    Syed.

    0 Like
    Short URL:
  • Guest - Jwolters4

    Great article! Can you please send me the "Web ADI Developers Guide"?

    Thanks!
    Jason (jwolters4@yahoo.com)

    0 Like
    Short URL:
  • Guest - Servane

    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!
    Servane

    0 Like
    Short URL:
  • Hello,

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

    Thanks
    R.Dillibabu

    0 Like
    Short URL:
  • Guest - RRaghuRaman

    How Do You Handle Output Parameters? Could This be part of The Document? Also type Boolean?

    1 Like
    Short URL:
  • Guest - Sam Wang

    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
    samwang77@hotmail.com

    0 Like
    Short URL:
  • Guest - Cj

    Hi Kali,
    Very helpful article.
    Can you send me the ADI developer guide and sample scripts to my e-mail address at
    christopherjwolfe@yahoo.com.

    Thanks a lot!
    Chris

    0 Like
    Short URL:
  • Guest - trista

    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

    0 Like
    Short URL:
  • Guest - Lakshmi Narayanan

    Hi,

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

    expecting your reply.

    Thanks!
    (k.latchu@gmail.com)

    0 Like
    Short URL:
  • Guest - Harrod

    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:harrodzhang@hotmail.com

    1 Like
    Short URL:
  • Guest - jayashree

    Excellent article. Can you please send me the ADI Developer guide to my email id rkrish4@gmail.com

    0 Like
    Short URL:
  • Guest - rejeswari

    Hi Kalimuthu,

    could 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

    0 Like
    Short URL:
  • Guest - Ian Towey

    Hi,

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

    Thanks

    Ian

    0 Like
    Short URL:
  • Guest - shweta naugaiya

    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 shweta.naugaiya@tcs.com
    It'll be great if you can help.

    Regards
    Shweta

    0 Like
    Short URL:
  • Guest - Vishala

    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

    0 Like
    Short URL:
  • Guest - anton

    u need create a function and add it in to column SECURITY_VALUE from bne.bne_security_rules table, after u will add this function to ur user menu it will be able to open integrator

    1 Like
    Short URL:
  • Guest - SnehaR

    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','WEBADI_ERROR');
    FND_MESSAGE.SET_TOKEN('P_UPD_FILE',p_upload_file,false);
    FND_MESSAGE.RAISE_ERROR;

    Also tried below

    1. FND_MESSAGE.set_encoded('Error message greater than 100 chars');
    FND_MESSAGE.RAISE_ERROR;

    RESULT -- Truncates it to 100 characters

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

    FND_MESSAGE.SET_NAME('BNE','WEBADI_ERROR');
    FND_MESSAGE.SET_TOKEN('P_UPD_FILE',p_upload_file,false);
    RAISE_APPLICATION_ERROR(-20004, fnd_message.get);

    RESULT -- truncates to 100 characters.

    1 Like
    Short URL:
  • Guest - Karthikeyan Kumaran

    Hi Kali,

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

    Hope so you remember this karthik from OSSI. ;)

    Regards,
    Karthik

    0 Like
    Short URL:
  • Guest - srikanthreddy

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

    Thanks
    Srikanth
    mail:evergreensrikanth@gmail.com

    1 Like
    Short URL:
  • Guest - Hieu Le

    Hi Kali,
    I checked data in these table, however the integrator still invisible. Could you please send me the script to active the integrator
    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

    Best Regards
    Hieu

    0 Like
    Short URL:
  • Guest - S

    Hi,

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

    Thanks,
    S

    0 Like
    Short URL:
  • Guest - Guy B

    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

    0 Like
    Short URL:
  • Guest - M

    Great article!!!
    Can you please e-mail me the dev guide at bbentley46@gmail.com

    Appreciate your help.
    Thanks,
    M

    1 Like
    Short URL:
  • Guest - Hrishika

    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_INTG' order by creation_date desc

    select * from bne_integrators_tl where integrator_code like 'HXT_TIME_ASG_INTG'
    order by creation_date desc

    select * from bne_interfaces_b where integrator_code like 'HXT_TIME_ASG_INTG'
    order by creation_date desc
    select * from bne_interfaces_tl where interface_code like 'HXT_TIME_ASG_INTF' 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 Hrishika.bhattacharya@gmail.com

    Thanks,Hrishika

    0 Like
    Short URL:
  • Guest - Cesar

    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 cbua@yahoo.com

    Thanks Again!

    0 Like
    Short URL:
  • Guest - Ayaz

    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

    0 Like
    Short URL:
  • Guest - Ayaz

    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 ayaz.aziz@gmail.com

    Thanks
    Ayaz

    0 Like
    Short URL:
  • Guest - vinay kumar

    Hi kali,

    i'm new to this web adi tool..i've a requirement...i've a custom integrator..there 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

    0 Like
    Short URL:
  • Guest - vinay kumar s

    hi,

    can u mail me the developer guide

    vinay.sajja@gmail.com

    0 Like
    Short URL:
  • Guest - Kalimuthuv

    The Dev Guide is an Internal Document(Oracle), which cannot be disclosed.
    Sorry for the inconvenience.

    Thanks.

    With Regards,
    Kali.

    0 Like
    Short URL:
  • Guest - Ayaz

    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

    0 Like
    Short URL:
  • Guest - M

    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.RAISE_ERROR however, I face the same problem. Please suggest why is this happenning and what can be done?

    Thanks,
    M

    0 Like
    Short URL:
  • Guest - Mario

    Hi Kali

    great article!

    Can I also please get a copy of the developers guide?
    My email is mcheng_home@yahoo.com

    Thanks again.

    Mario

    0 Like
    Short URL:
  • Guest - Zig Balodis

    Can you please provide a copy of the Web ADI developers guide.

    0 Like
    Short URL:
  • Guest - Zig Balodis

    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?

    0 Like
    Short URL:
  • Guest - Sushmitha

    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:

    Information

    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

    0 Like
    Short URL:
  • Guest - Kalimuthuv

    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.

    0 Like
    Short URL:
  • Guest - Adish Jain

    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 adish_jain86@yahoo.com

    Regards
    Adish Jain

    0 Like
    Short URL:
  • Guest - Yudhvir Singh

    Hi Kali.
    Great article.
    can you please e-mail Web-ADI developer's guide to yudhvir.singh@allvac.com
    Thanks,
    Yudhvir Singh

    0 Like
    Short URL:
  • Guest - Ankit@erp

    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,location,department are to be fetched from custom tables instead of the standard ones.
    But when i checked the bne_interface_cols table, the existing type for Segment1,Segment2 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,location etc from my custom table instead of the standard table.

    Highly appreciate any pointers in this direction

    0 Like
    Short URL:
  • Guest - Yan Pechenik

    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 yan.pechenik@hq.doe.gov.

    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?

    Thanks,
    Yan

    0 Like
    Short URL:
  • Guest - Paul Thien

    Hi Kali,
    Can you email me a copy of the Web ADI developer's Guide to thienpf@gmail.com please?
    Thanks for your help.
    Paul

    0 Like
    Short URL:
  • Guest - Srinivas_r

    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
    Srini

    0 Like
    Short URL:
  • Guest - Srinvas Rao

    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 srini_vas_r@yahoo.com

    Thanks
    Sriniivas Rao

    0 Like
    Short URL:
  • Guest - Jags Viswanathan

    Kali,

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

    Thanks

    0 Like
    Short URL:
  • Guest - Uma_P

    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

    0 Like
    Short URL:
  • Guest - AkhilJain

    Hi Kali,
    Can you please email me a copy of the WebADI Developer User guide.

    Thanks,
    Akhil
    akhiljain2k1@gmail.com

    0 Like
    Short URL:
  • Guest - mayur

    Hi Kali,
    Can u please forward me the developer's guide

    my id is :- menon.mayur@gmail.com

    Thanks,
    Mayur

    0 Like
    Short URL:
  • Guest - rohit kumar pandey

    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 :- rohitkumarpandey@gmail.com

    Regards,
    Rohit

    0 Like
    Short URL:
  • Guest - Nini1

    Hello Kali
    Can u plz explain How u can create a Custom JAVA LOV for Web ADI

    thanks

    1 Like
    Short URL:
  • Guest - P

    I think I found a way to get around the 100 character truncation issue.

    So, I used the following code:

    FND_MESSAGE.SET_NAME('BNE','WEBADI_ERROR');
    FND_MESSAGE.SET_TOKEN('MSG', 'error message goes here');
    --FND_MESSAGE.RAISE_ERROR;

    Just try commenting out the call to FND_MESSAGE.RAISE_ERROR. This will prevent the eventual call to RAISE_APPLICATION_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.RAISE_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

    0 Like
    Short URL:
  • Guest - siva_adi

    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

    0 Like
    Short URL:
  • Guest - Iva Bartek

    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?

    0 Like
    Short URL:
  • Guest - Kumar111

    Hi Kali,
    Can you please email me a copy of the WebADI Developer User guide to email
    skumar111@yahoo.com?

    I will also need some sample WebADI scripts.

    Thanks
    Kumar

    0 Like
    Short URL:
  • Guest - SergiuP

    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 responsabilities?
    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_SECURITY_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

    0 Like
    Short URL:
  • Guest - Sreeabcd985

    Wonderful article. Although I've worked with standard integrators before, it was interesting to know about custom integrators.

    Even 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 >> sree.k542@gmail.com

    Thanks and regards,
    Sree

    2 Like
    Short URL:
  • 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 zulesray@aim.com

    Thanks & Regards,
    Prashanth

    0 Like
    Short URL:
  • Guest - Carmen

    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.

    Please could you mail me the sample web ADI scripts and Developer's guide to: kdominguez@gmail.com

    thanks in advance! :)

    1 Like
    Short URL:
  • Guest - Sanjay Prasad

    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 ' sanjayind_prasad@rediffmail.com '

    Regards,
    sanjay prasad

    0 Like
    Short URL:
  • Guest - Thu Nguyen

    I would really appreciate if you could send the WEB ADI devl guide and the sample scripts. My email is nguyent@metro.net.

    Thanks

    0 Like
    Short URL:
  • Guest - Thu Nguyen

    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

    0 Like
    Short URL:
  • Guest - terry

    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 miaozhicong@hotmail.com.
    Thanks again!

    terry

    1 Like
    Short URL:
  • Guest - NGNEETU

    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?

    0 Like
    Short URL:
  • Guest - NGNEETU

    Could you mail me the WEB ADI documentation ngneetu@yahoo.com

    0 Like
    Short URL:
  • Guest - rafeeque

    I am trying to create an Upload integrator for AR. Used CREATE_INTEGRATOR then CREATE_INTERFACE_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.

    Thanks in advance.

    0 Like
    Short URL:
  • Guest - Nalumachu

    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

    0 Like
    Short URL:
  • Guest - Nalumachu

    My Email is replytomadhu@yahoo.com

    0 Like
    Short URL:
  • Guest - James Kim

    Hey Kali! This is James Kim.

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

    Hope you're doing well..

    0 Like
    Short URL:
  • Guest - Roberto

    Hi,

    Could you send me WebAdi Developer's Guide (roberto.dohmen@gmail.com)
    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.

    0 Like
    Short URL:
  • Guest - Manojram

    Hi can some one send the webADI developer guide to my email nmanojram@hotmail.com?

    thanks
    Manoj

    0 Like
    Short URL:
  • Guest - krish01

    can you please email me the webADI developer guide . my email id mkg20032000@yahoo.com
    Thanks

    0 Like
    Short URL:
  • Guest - Vijay Addanki

    I would really appreciate if you could send the WEB ADI devl guide and the sample scripts. Email address vijaykumar@msn.com

    0 Like
    Short URL:
  • Guest - Krish01

    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 mkg20032000@yahoo.com

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

    --------------------------

    0 Like
    Short URL:
  • Guest - Dazza

    Hi Kali / anyone

    Interesting 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

    0 Like
    Short URL:
  • Guest - China

    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: china.cse@gmail.com

    Thanks China

    0 Like
    Short URL:
  • Guest - China

    Hi

    Anybody have the Developer guide? please respond. Its urgent

    Thanks
    Venkat

    0 Like
    Short URL:
  • Guest - Kenny Miller

    I'd appreciate it if someone could email the Developers Guide to kenny_miller@blueyonder.co.uk

    Thanks,
    Kenny

    0 Like
    Short URL:
  • Guest - akkirajukiran

    Could some body Please send me the Developers guide.

    Thanks
    Kiran

    0 Like
    Short URL:
  • Guest - akkirajukiran

    Could you please email me Developers Guide
    akkirajukiran@yahoo.com

    0 Like
    Short URL:
  • Guest - sri L

    Could you please email me "WEB ADi developer's guide"?
    slokam_in@yahoo.com

    0 Like
    Short URL:
  • Guest - Vish

    I'd appreciate it if someone could email the Developers Guide to [url]kvishwas@earthlink.net[/url]

    0 Like
    Short URL:
  • Guest - AT

    I do really appreciate it if someone could email the developer guide arun_tom@yahoo.com
    I also do have a question on how to create lov on parameters and use the lov to validate the entries
    Thanks

    0 Like
    Short URL:
  • Guest - PrasannaNarayananMankali

    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 pras@att.com

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

    Prasanna.

    0 Like
    Short URL:
  • Guest - Vikas Pandey

    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

    0 Like
    Short URL:
  • Guest - Vikram S V

    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 vikram_sv@yahoo.com

    Thanks,
    Vikram S V

    0 Like
    Short URL:
  • Guest - Sheila Najmi

    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
    sheila

    2 Like
    Short URL:
  • Guest - John Trautman

    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.

    0 Like
    Short URL:
  • Guest - Krishna B

    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

    1 Like
    Short URL:
  • Guest - J

    Could you send me the example you have for creating a java based LOV please together with the developer's guide. Thanks.

    0 Like
    Short URL:
  • Guest - J

    My email id is jh1000@yahoo.co.uk.

    0 Like
    Short URL:
  • Guest - sayed Moinuddin

    Great could you please email the document sayed_moinuddin@yahoo.com

    Thanks in advance

    0 Like
    Short URL:
  • Guest - sayed Moinuddin

    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"

    STEPS
    -----------------------
    The 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

    Thanks in advance

    0 Like
    Short URL:
  • Guest - Walter

    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: wreinoehl@gmail.com

    Thanks again for the great article.

    -Walter

    0 Like
    Short URL:
  • Guest - Uday Jadhav

    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.

    thanks,
    Uday

    0 Like
    Short URL:
  • Guest - Usha2345

    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

    0 Like
    Short URL:
  • Guest - slokam_L

    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

    0 Like
    Short URL:
  • Guest - Karthik_Rajasekaran

    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 krajasek@gmail.com? I would like to use WebADI custom integrators in R12.1.1. Is there a new dev guide for this version?

    Regards,
    Karthik

    0 Like
    Short URL:
  • Guest - Wonderful document and thanks guys.Please send me the web adi developers guide for R12

    Wonderful document and thanks guys.Please send me the web adi developers guide for R12 to mlcbank@yahoo.com

    0 Like
    Short URL:
  • Guest - Vyagh

    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
    Vyaghresh

    0 Like
    Short URL:
  • Guest - Vyagh

    Hi Kali,

    Can you please send us teh Web ADI Developer's Guide to mail my vyaghreshmp@gmail.com

    0 Like
    Short URL:
  • Guest - Sachin Singh

    Is it possible to change the List of Values in the Standard integrators.

    0 Like
    Short URL:
  • Guest - Rubayat Newaz

    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

    0 Like
    Short URL:
  • Guest - hari krishna

    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: d.harikrishna@gmail.com

    Regards,
    Hari

    0 Like
    Short URL:
  • Guest - kris

    I want to know abt the java default type implementation in the integrator

    0 Like
    Short URL:
  • Guest - Mukesh Singh

    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.

    0 Like
    Short URL:
  • Guest - Sheena Sidhu

    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

    0 Like
    Short URL:
  • Guest - Pradeep.moganti

    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 : pradeep.moganti1@genpact.com

    Thanks,
    Pradeep

    0 Like
    Short URL:
  • Guest - Sheena Sidhu

    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.

    0 Like
    Short URL:
  • Guest - Pradeep.moganti

    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_Application_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

    0 Like
    Short URL:
  • Guest - Pradeep.moganti

    Hi,

    If I use Raise_Application_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

    0 Like
    Short URL:
  • Guest - Sheena Sidhu

    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!

    0 Like
    Short URL:
  • Guest - Pradeep.moganti

    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 : pradeep.moganti1@genpact.com

    Please.....

    Thanks,
    Pradeep

    0 Like
    Short URL:
  • Guest - Pradeep.moganti

    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_cols_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_name = 'P_TAG_VALUE'
    AND application_id = 20011
    AND interface_code = 'GENERAL_16_INTF'

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

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

    Thanks,
    Pradeep

    0 Like
    Short URL:
  • Guest - Manoveg Saxena

    Hi Pls mail me Web ADI developer guide and some working examples in java classes so that I can implement
    dependent LOV .

    Thanks,
    Manoveg

    1 Like
    Short URL:
  • Guest - Manoveg Saxena

    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 manoveg.saxena@tcs.com

    Thanks,
    Manoveg

    0 Like
    Short URL:
  • Guest - sreekanths

    Hi Pls mail me Web ADI developer guide..its very urgent

    0 Like
    Short URL:
  • Guest - sreekanths

    Hi Pls mail me Web ADI developer guide..its very urgent to sreekee.oracleapps@gmail.com

    0 Like
    Short URL:
  • Guest - Leo Ameal

    Hi Pls mail me Web ADI developer guide..its very urgent

    0 Like
    Short URL:
  • Guest - Naveen Azad

    Hi,

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

    Please help me on this.

    Regards,
    Naveen

    0 Like
    Short URL:
  • Guest - Sheena Sidhu

    Naveen, ps be more specific what you need help with. Is it finding the right api or something else?

    Sheena

    0 Like
    Short URL:
  • Guest - Ram M.

    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
    where creation_date < &parameter


    So the xls output should look like


    invoice created till : 10-AUG-2010 (&parameter)

    invoice_num creation_date
    ----------------- -------------------
    75893454 01-JAN-2010
    43574859 11-JAN-2010

    etc...


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

    Regards,
    Ram

    0 Like
    Short URL:
  • Guest - Ram M.

    Could you send me the WEB ADI Developer Guide?

    Thanks and regards,
    Ram

    0 Like
    Short URL:
  • Guest - Kaouther

    Hi,
    Very helpful article.
    Can you send me the ADI developer guide and sample scripts to my e-mail address at kaoutther.boussema@yahoo.fr
    Best regards,
    Kaouther

    0 Like
    Short URL:
  • Guest - T Simkiss

    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. Tsimkiss@biztech.com

    0 Like
    Short URL:
  • Guest - sajsanr

    Here is a working example that will help for simple LOVs:
    UPDATE bne_interface_cols_b
    SET val_id_col = 'ORGANIZATION_ID',
    val_mean_col = 'ORGANIZATION_NAME',
    VAL_DESC_COL='ORGANIZATION_NAME',
    VAL_OBJ_NAME = 'ORG_ACCESS_VIEW',
    val_addl_w_c = 'RESPONSIBILITY_ID = $env$.respid AND RESP_APPLICATION_ID = $env$.appid',
    VAL_TYPE = 'TABLE',
    LOV_TYPE = 'POPLIST',
    offline_lov_enabled_flag = 'N',
    mapping_enabled_flag = 'N'
    WHERE interface_col_name = '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_cols_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:


    UPDATE bne_interface_cols_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.

    0 Like
    Short URL:
  • Guest - Tina

    Hello,

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

    :D

    0 Like
    Short URL:
  • Guest - vasu

    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.

    0 Like
    Short URL:
  • Guest - vasu

    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.
    vasuappsconsultant@gmail.com

    0 Like
    Short URL:
  • Guest - VosKon

    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:XXFA_BNE_TEST_INTG is an invalid Integrator Key."

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

    I'm sorry about mistakes in my english..

    2 Like
    Short URL:
  • Guest - Kish

    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.

    0 Like
    Short URL:
  • Guest - cheran

    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

    0 Like
    Short URL:
  • Guest - Amit garg

    hi,
    i want to design dependent lov ..please send the sample java class file and developer guide to ---garg.amit6@gmail.com
    it surgent

    Amit

    0 Like
    Short URL:
  • Guest - Pal

    Hi,

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

    Thanks,
    Pallavi

    0 Like
    Short URL:
  • Guest - sajsanr

    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_TABLE_LOV --
    -- (P_APPLICATION_ID => 231, --
    -- P_INTERFACE_CODE => '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_CHARACTER_SETS''',
    -- P_WINDOW_CAPTION => 'Yes/No/All with Meaning and Description, selecting Meaning, Meaning sortable',--
    -- P_WINDOW_WIDTH => 400, --
    -- P_WINDOW_HEIGHT => 300, --
    -- P_TABLE_BLOCK_SIZE => 10, --
    -- P_TABLE_SORT_ORDER => '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_id can be looked up as defined in the bne_interface_cols_b.application_id.
    b. p_interface_code will be in bne_interface_cols_b.interface_code column.
    c. p_interface_col_name will be in bne_interface_cols_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_cols_b is required to make this as a POPLIST.

    Please note, a poplist will result is 256 row limit.

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

    Thanks
    Sajid

    1 Like
    Short URL:
  • Guest - Jeroen

    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.raise_error;

    I tried:
    FND_MESSAGE.SET_NAME('BNE','WEBADI_ERROR');
    FND_MESSAGE.SET_TOKEN('P_UPD_FILE','HELLO 123',false);
    FND_MESSAGE.RAISE_ERROR;

    but it seems WebADI is overwriting my custom errors in some way.
    Am I missing something?

    0 Like
    Short URL:
  • Guest - Sheena Sidhu

    Hi- try using: raise_application_error(-20000,'ur custom mesg');

    0 Like
    Short URL:
  • Guest - pal1901

    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,Pallavi

    0 Like
    Short URL:
  • Guest - sam.jmd

    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.

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

    Thank you
    seham

    0 Like
    Short URL:
  • Guest - ariel

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

    Thank you,
    Ariel

    0 Like
    Short URL:
  • Guest - Vikram

    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

    0 Like
    Short URL:
  • Guest - Sateeshapp

    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
    Sateesh

    0 Like
    Short URL:
  • Guest - Sateeshapp

    Hi Kali,

    My email id is sateeshapp@gmail.com.

    Please send the WEBADI devloper guide and sample scripts.

    Regards
    Sateesh

    0 Like
    Short URL:
  • Guest - Igor

    Hi, Kali,
    Great article!
    Can you please send the sample script & the developer guide for Web ADI to > goga-new@yandex.ru?
    Thanks.
    Regards,
    Igor

    0 Like
    Short URL:
  • Guest - Uprale

    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

    0 Like
    Short URL:
  • Guest - VRaju

    Hi..

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

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

    Thanks in advance,
    Vidya.

    0 Like
    Short URL:
  • Guest - Vijay Nurani

    Kali,

    Is their need to have PLM installed for loading items?

    0 Like
    Short URL:
  • Guest - VijayN

    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?

    0 Like
    Short URL:
  • Guest - herdanto

    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.
    Currently I have no idea what went wrong.. can anyone help me please... thank you.
    regards
    Herdanto