X

The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

Build Custom WebADI Integrators with EBS 12.1.2 Desktop Integration Framework

Rekha Ayothi
Product Management
[Nov. 22, 2010 Update:  Office 2010 (32-Bit) is now certified with the E-Business Suite; see this article for details] Oracle Web Application Desktop Integrator (Web ADI) is Oracle E-Business Suite's solution for integrating E-Business Suite applications with desktop applications such as Microsoft Excel, Word and Projects.  "Integrators" encapsulate the metadata and other information needed to integrate a particular Oracle E-Business Suite task with a desktop application. I'm pleased to announce the availability of Oracle E-Business Suite Desktop Integration Framework (DIF), a design time framework that you can use to create custom integrators for Oracle Web ADI in Oracle E-Business Suite Release 12.1.2.
 
Several Oracle E-Business Suite applications provide seeded integrators out-of-the-box. You can now use the Desktop Integration Framework to define custom integrators for tasks of your own.  
dif1.jpg
 
Oracle E-Business Suite Desktop Integration Framework provides a graphical user interface which you can use to define integrators and associated supporting objects.  You can reduce development time by using the GUI instead of working directly with the underlying Oracle Web ADI tables and APIs.  This user interface makes it easier to maintain your integrators, too.  The Desktop Integration Framework supports native Oracle Application Framework (OAF) UI widgets like Flex-fields, List Of Values, Pop-lists and Date pickers.  
dif2.jpg
The Desktop Integration Framework allows you to:
  • Create Integrators using a wizard-based user interface
  • Define Integrators to upload data through PL/SQL APIs or directly to tables
  • Define Integrators to download data from text files or using SQL Queries
  • Define data validation rules
  • Embed UI widgets (List of values, Pop lists, Date pickers, Flexfields) in spreadsheets
  • Use the Oracle E-Business Suite Security Model
  • Define layouts and mappings for custom integrators
Your feedback is welcome
 
We are very interested in hearing about your experiences with this new tool.  Please post your comments here or drop me an email at email.jpg
 

Join the discussion

Comments ( 226 )
  • Ketan Thanki Monday, February 15, 2010

    Rekha,

    Is DIF likely to be back-ported to the versions of R12 prior to 12.1.2?

    Regards,

    Ketan


  • Rekha Ayothi Tuesday, February 16, 2010

    Hi Ketan,

    Currently there are no plans for back-porting to releases prior to 12.1.2. However, based on need we will evaluate this requirement.

    Regards,

    Rekha


  • Sudhakar Mani Wednesday, February 17, 2010

    Rekha,

    DIF is a very useful framework for R12.1.2.Thanks for the info.

    This helps us to build some stunning solutions without playing around with the code much.

    Regards

    Sudhakar Mani


  • Rekha Ayothi Sunday, February 21, 2010

    Thank you Sudhakar.

    We are eager to hear your experiences with DIF.

    Regards

    Rekha


  • Venkata Mellacheruvu Tuesday, March 2, 2010

    Rekha,

    We are looking at this functionality to insert data into our custom schema (11.5.10 R2). Any plans for getting this released for 11.5.10. Or if you could suggest ways to do it in 11.5.10.

    Regards

    Venkat


  • Bob Friday, March 26, 2010

    Could someone please help me with this... I am an oracle applications user and trying to export data into excel, error: APP-PER-289793.. System Administrator must define a Web ADI integrator and associate it with this window. However, it used to work perfectly and i could get excel files but suddenly stopped, i am not getting any help from the administrator as he says nothing has changed on his side.. Is there any reason why the association could just break?? thanks, Bob


  • Steven Chan Friday, March 26, 2010

    Hi, Bob,

    I'm sorry to hear that you're encountering problems with this. Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

    Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

    Regards,

    Steven


  • Grant Newcomer Tuesday, March 30, 2010

    We would be very intereted in this being back ported to R 12.0.4


  • Nitesh Thursday, June 3, 2010

    Hi Rekha,

    I had build a custom integrator to upload data in a custom staging table. It is working find and doing its job well. Now, i need to call a concurrent program at the end of uploading process. Say, when all the rows are uploaded into the staging table, execute the concurrent program to read these rows and insert data into base tables.

    Can you help me in this???

    Did i mention, ADI and DIF rocks!!!!!!!!!!!!!!!!!!!!!

    best regards

    Nitesh Sharma


  • Rupa Thursday, August 19, 2010

    Hi Rekha,

    I has similar requirement as Nitesh , calling a concurrent program at the end of uploading process. I could submit concurrent program from Web ADI based on one of the thread in oracle forum but i could not pass parameter from Excel to concurrent program.

    Any points on this is appriciated.

    rupa


  • Chandra Wednesday, September 22, 2010

    Hi Rekha,

    How to end date or inactivate a particular WEB ADI Layout.?

    All I can see in the "Layout" screen is to delete.

    I just wanted to inactivate few layouts instead of deleting them completely.

    Any idea.


  • HY Monday, September 27, 2010

    Hi Rekha,

    We have the similar problem as Rupa, that we cannot pass the parameter when calling a concurrent program after uploaded data to the interface table. Either the concurrent program can be submitted without parameter passed in; or error caught (ORA-00900) when call the concurrent program.

    Please kindly advise.

    HY


  • Sachin Singh Tuesday, October 19, 2010

    Hi Rekha and Steven,

    We would also be interested in having this functionality for R12.1.1. Let me know if there are plans do back port the same.

    Thanks

    Sachin


  • Ash Friday, October 22, 2010

    Hi Steven.

    I was wondering if its possible to create java desktop application and get database connection from apps user authentication.

    I've done this desktop application and I used jdbc connection with apps credentials but in PRODUCTION I got no apps password. so I have to change my connection to authenticate fnd user and pass to get a session then get database connection from that session.

    I'm cannot see the way to do this. is there any Java API??

    Any help would be great.

    Regards!!


  • Steven Chan Thursday, October 28, 2010

    Ash,

    You might find this article useful:

    AppsDataSource and Java Authentication and Authorization Service for Oracle E-Business Suite

    http://blogs.oracle.com/stevenChan/2010/01/appsdatasource_jaas_ebs.html

    It's designed to support Java EE programs deployed on application servers rather than desktops, so it might not be completely applicable to your requirements, but it's a start.

    Regards,

    Steven


  • Steven Chan Thursday, October 28, 2010

    Sachin,

    Thanks for your feedback. We have no plans to backport this functionality to EBS 12.1.1 at this point.

    Regards,

    Steven


  • Anjana Ghosh Friday, December 17, 2010

    Should DIF be available through the 12.1.2 patch, I don’t see the ‘Desktop Integrator Manager’ menu/responsibility


  • Rekha Ayothi Sunday, December 19, 2010

    Hi Anjana,

    If you want to use Oracle E-Business Suite Desktop Integration Framework in Oracle E-Business Suite Release 12.1.2, apply the DIF: New Responsibility and Function for Desktop Integration Manager patch (9055234:R12.BNE.B, Patch 9055234) on top of Oracle E-Business Suite Applications Technology Release 12.1.2 (R12.ATG_PF.B.DELTA.2), Patch 7651091. After you apply the patch, assign the new Desktop Integration Manager responsibility to the developers in your enterprise who will define custom integrators.

    The above and required setup steps are mentioned in Oracle Web Applications Desktop Integrator Release Notes, Release 12.1.2 (My Oracle Support Knowledge Document: 950876.1)

    Regards,

    Rekha


  • srisu Monday, January 3, 2011

    Hi guys,

    Actually I want to download data from Oracle E-Business by providing parameters and then want to make few changes, upload back to E-business..is it possible here.

    If yes, can you please send me some sample document as we want to do some POC.


  • Santosh Wednesday, January 5, 2011

    Hello Rekha,

    Like the posting of Nitesh and Rupa, would you please publish informaiton on how to call a concurrent program once the Upload is complete in Ebusiness 12.1.2?

    Thanks

    Santosh Rao


  • Rekha Ayothi Thursday, January 6, 2011

    Hi Santosh,

    Wish you very happy new year!

    Thanks for raising this query, let me address it.

    Desktop Integration Framework was introduced in Oracle E-Business Suite R12.1.2 as part of Web ADI as a tool to define custom integrators. It provides basic ability to create simple custom integrator - download data, work on it and upload data.

    In Oracle E-Business Suite R12.1.3, Desktop Integration Framework is enhanced to provide advanced features like "Ability to define importer rules" (call concurrent program after upload) for a custom integrator.

    Please refer Oracle E-Business Suite R12.1.3 Desktop Integration Framework Developer's Guide E15877-02 for details on Importer Rules.

    Thanks,

    Rekha


  • Santosh Rao Thursday, January 6, 2011

    Hello Rekha,

    Thank you and wish you a very Happy New Year too

    So calling a concurrent program using Importer rules is only possible in R12.1.3, Desktop Integration Framework ?

    The reason i ask is that reading note Is it Possible to Launch a Standard Concurrent Program From a Custom WebADI Integrator? (Doc ID 1160340.1), i thought it is possible in 12.1.2 version

    Can you please confirm?

    Also, can you give some pointers/links to how to achieve the same in 12.1.2 , thanks for your time

    Thanks

    Santosh Rao


  • guest Friday, June 3, 2011
    There are so many questions asked w.r.t the article posted by Rekha. When will these questions by answered? The author posts some article and goes away forgetting to answer the questions.
  • Rekha Ayothi Tuesday, June 7, 2011
    Hi All,
    Apologies for my delayed response, and thanks to dear guest for raising this point.
    As I scan through the posts, I see the following open questions, I will try to resolve them:
    Q 1) I want to download data from Oracle E-Business by providing parameters and then want to make few changes, upload back to E-business..is it possible here.
    Ans: Yes, it is possible. You may define an integrator with Content Parameters. While creating document, user will be prompted to entire value, and based on user entered value and Content definition, data will be extracted from source and presented in spreadsheet. Data in spreadsheet can be updated, and uploaded back to Oracle E-Business Suite.
    For more details, please refer Desktop Integration Framework Developers Guide (Note 979354.1), and R12.1.2 TOI: Implement and Use E-Business Suite Desktop Integration Framework from Oracle University.
    Q 2) How to call a concurrent program once the Upload is complete in E-business 12.1.2?
    Ans: Calling a concurrent program after upload is part of Importer process. Ability to define custom Importer for custom Web ADI Integrators using Desktop Integration Framework is only available from Oracle E-Business Suite R12.1.3.
    Q 3) How to pass parameter when calling a concurrent program after uploading data?
    Ans: Please refer R12.1.3 TOI: Implement and Use Web Applications Desktop Integrator from Oracle University.
    Regards,
    Rekha
  • guest Thursday, June 16, 2011

    Could you please help me on this?

    1.I call a custom PL/SQL API as an interface to insert data into a custom table. When testing, the records are getting insert into this custom tables, no errors.

    2.In the importer section, I call another custom PL/SQL API to validate the data entered in this custom table. This program is also working fine.

    3.Now, I need to show the corresponding error/success messages for those records that were inserted in step #1.

    My Questions:

    1. 'Document row - interface attribute mapping' shows the attributes from the PL/SQL API defined in #1 above. The 'Error row definition' I put a SQL query 'select * from xx_custom_table where status='ERROR'.

    How do I use the above two import rules to achieve my purpose of showing the error message on the excel spreadsheet? THanks a lot, in advance.

    The interface table is defined in a custom schema.


  • Rekha Ayothi Friday, June 17, 2011

    Dear Guest,

    For how to use Importer Rules, please refer R12.1.3 TOI: Implement and Use Web Applications Desktop Integrator from Oracle University.

    Regards,

    Rekha


  • Geoff Dale Thursday, September 29, 2011

    Does anyone know of a solution to create a custom integrator for AR Transactions? I have tried to use the seeded Transaction API package but then it asks for ONE procedure or function. This API has many procedures in the one package.

    I have heard the word 'wrapper' custom package mentioned in blogs but have not seen any solutions nor have any idea what this is and how to pass it to a technical resource. Has anyone achieved such a package? Many thanks. Geoff


  • Rekha Ayothi Tuesday, October 4, 2011

    Hi Geoff,

    I do not have expertise on AR Transactions, but let me try to understand your requirement in general, from Web ADI perspective.

    The API that you are intending to use as Interface may have multiple procedures and/or functions. And, for a particular task (and hence custom integrator), you may want to use more than one procedure.

    For example, say a ficticious API 'Employee Record' has procedures to 'Create Employee', 'Update Employee', 'Get Employee'. And, you want to use both Create and Update Employee APIs as interface for a custom integrator.

    Please note, as of now, DIF does not support multiple interfaces for an integrator. Having said that, if your requirement is as mentioned above then, here is what you can do:

    Create a custom API, say 'My Employee Record' with a procedure, say 'Create', with set of parameters as required for Employee Record. In addition, include one parameter say 'flag' to indicate if record needs to be created or updated. Within the custom procedure, based on the flag value, you may invoke both, 'Create Employee' and 'Update Employee' from original 'Employee Record' API. That is, the single custom procedure 'Create' of 'My Employee Record' performs the functionality of 2 procedures 'Create Employee' and 'Update Employee' of original API 'Employee Record'.

    And, use the custom API 'My Employee Record' and single procedure 'Create' as interface while creating the custom integrator. In this case, the custom API is commonly referred as 'wrapper' API (as it wraps/ covers the original APIs based on some logic).

    Hope this answers your query!

    Thanks,

    Rekha


  • Geoff Dale Wednesday, October 5, 2011

    Thanks Rekha

    I will pass on your comments to a technical resource to see if they can work something out. The issue we have is that creating AR Transactions has a procedure for Create Invoice Header and Create Invoice Lines with the two being linked. To do this in ADI the spreadsheet would need to have sections for both that are somehow linked during upload. I know More4Apps does this but we are trying to have an internal solution to avoid licence fees!

    Cheers

    Geoff


  • guest Wednesday, October 12, 2011

    Hi Rekha,

    Thanks for your post on the bog, which gives more information.

    I am working on WEB ADI R12.1.3 version.

    I have create ADI template and able uplaod the data. I have created Interface based on API.

    My query is, For each record it inserting valid into the some staging table. For example in the excel sheet if we have 5 rows if all the rows are valid then only the data need to be inserted into staging table. If any one of row validation fails all the rows need not be inerted.

    How to achive this. Please advise us.

    Thanks

    Ravinder


  • guest Wednesday, November 30, 2011

    I have created Web ADI Letters on DEV instance for OLM and moved to Test instance using FNDLOAD. Even though FND load download and upload completed successfully, when ever we click on Export data from Request Letters window we get error APP-PER-289793 with message "Before you can run Mail merger using this letter, Your System Administrator must create WEB ADI Layout and Integrators. the Layout must match the letter name and must be associated with Integrator which must also be attached with LETTER group."

    Please note : My Letter name and Layout name is same.

    Integrator and layout present on Test instance via FNDLOAD.

    But still I am getting this error.

    Please Help.


  • Steven Chan Wednesday, November 30, 2011

    Hello, Guest,

    I'm sorry to hear that you've encountered an issue with this.

    We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

    Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our WebADI specialists engaged.

    Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

    Regards,

    Steven


  • guest Friday, December 9, 2011

    I am currently working on an upgrade of HRMS 11.5.10 to 12.1.4 and part of my work involves ensuring the Web ADI customisations work as per normal. I am highly disappointed about the lack of information about changes we need to make to ensure these customisations work in R12. I have spent weeks trawling metalink to find bits of information residing in different documents. Surely someone in Oracle should be be able to write a simple guide for people to follow ?. The fact that excel spreadsheets now gets generated regardless of the fact that you have chosen Word as the default viewer is a fundamental change that I cannot seem to find documented anywhere. I raised an SR few weeks ago and I was advised by one of your analysts that Excel and then Word would be opened every single time i am trying to generate a word document via Web ADI and I find this astonishing.


  • guest Monday, December 19, 2011

    Hi,

    I am new to web ADI and want to build a custom integrator for oracle projects to upload the data into UDA table. so i started with a test (created a new custom table and create a simple package to insert values into the custom table, then layout and everything) and I am struck up. I have 3 queries..

    1. I am unable to create the document. when i click on create document my excel opens and it never creates the document..

    2. Is there any standard API for oracle projects to insert data into table? I'v referred the API guide but i unable to find out.

    3. I also want to create dependent LOV's for the web ADI. How can i do that?

    Hope you help me out..

    Thanks

    Sunil


  • Rekha Ayothi Wednesday, December 21, 2011

    Hi Sunil,

    I am sorry to hear that you are unable to create the document. I suggest you log a Service Request via My Oracle Support.

    On 2nd query,

    For any information on standard APIs from Oracle Projects, you may have to refer Oracle Projects documentation. You can also look for E-Business Suite public APIs from "Integration Repository" of your hosted instance. [Hint: For Oracle E-Business Suite R12.1.x, you can access Integration Repository of your E-Business Suite instance using Integrated SOA Gateway responsibility]. If you are unable to find an API, please log a separate Service Request for Oracle Projects.

    On 3rd query - yes, dependent LOV's are supported by Web ADI framework, and used by Oracle seeded integrators. However, as of R12.1.3, Desktop Integration Framework does not have a provision to define dependent LOV from UI.

    Thanks,

    Rekha


  • Vishwa Thursday, January 26, 2012

    For a Custom WebADI I created Content which has date columns. The view which I am using for downloading the data has date values with timestamp.

    When the data is downloaded into the WebADI the date values are coming in without timestamp.

    I tried looking if there is some setup but could not find it.

    Thanks in advance for the help.

    Thanks

    Vishwa


  • Rekha Ayothi Friday, January 27, 2012

    Hi Vishwa,

    Web ADI does not support timestamp. The supported data types are number, string and date; the same is mentioned in Desktop Integration Framework Developer Guide.

    If you have requirement for timestamp, please enter enhancement request in My Oracle Support, based on need we will evaluate the requirement.

    Thanks,

    Rekha


  • Vishwa Friday, January 27, 2012

    Hi Rekha,

    Thanks for the response.

    You mentioned that WebADI supports date data type.

    My question was that does it support this kind of date which has timestamp also.

    For example: '01/27/2012 23:59:59'

    As I mentioned the custom WebADI which I have built has a Content defined for downloading the data. The sql for this has columns which have date (including timestamp).

    When the data is downloaded I see only the date value 01/27/2012 and not 01/27/2012 23:59:59.

    Please confirm if this is a bug or standard functionality.

    Thanks

    Vishwa


  • Rekha Ayothi Friday, February 10, 2012

    Hi Vishwa,

    Web ADI supports date type 'without timestamp'. Hence, even if sql has columns with date-timestamp type, when data is downloaded to the worksheet, you may see it as 'date' only type (without timestamp). From your example, I see you are experiencing the expected behavior.

    Thanks,

    Rekha


  • new_user Monday, April 9, 2012

    Hi Rekha,

    Please can you tell me the difference in wed ADI in 11i and R12?

    We are in the process of creating a web ADI for oracle projects in 11i, we would be upgrading to R12 very soon.

    My question is should we wait for the upgrade to R12 or should we just go ahead a create a new integratot in 11i?

    Thanks for your help in advance.

    Regards

    New_user


  • Rekha Ayothi Wednesday, April 11, 2012

    Hi,

    Please refer My Oracle Support Note: 404152.1 -> Applications Technology Family RCD for enhancements in Web ADI R12 over 11i.

    Regarding custom Web ADI integrators, please note that Web ADI provides DIF to create custom integrators from Oracle E-Business Suite R12.1.2. As of today, this capability is not available in 11i.

    Hope that helps!

    Regards,

    Rekha


  • guest Wednesday, May 23, 2012

    We have integrated Oracle EBS with SSO using OAM 10g.

    1. Logged in to EBS using SSO.

    2. Downloaded Web ADI xls file. The file is opened sucecssfully and logged in to form automatically.

    3. Now we logged in to another Oracle EBS instance.

    4. Now opened the same xls file downloaded with first EBS instance.

    5. Now the form does not logs in. Also it asks to select the responsibility but after selecting a responsibility, it throws a error.

    Can you pls tell - after logging in to another EBS, why the automatic login to xls form downloaded from first EBS instance fails ?


  • guest Wednesday, May 23, 2012

    Dear Guest,

    I am sorry to hear that you encountered this error. It needs to be investigated further.

    I suggest you log a Service Request via My Oracle Support (formerly Metalink).

    Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

    Regards,

    Rekha


  • guest Friday, June 8, 2012

    I have created a custom integrator succesfully where I want to download some 10 rows from a custom table to a xl file. But I am not able to see or view the file consisting those records in the desktop.

    Please let me know what is missing here.

    Thanks,

    Ahamed.


  • Rekha Ayothi Friday, June 8, 2012

    Hi Ahamed,

    The basic steps to create custom integrator in Desktop Integration Framework are:

    1. Create integrator

    a) Define basic Integrator information and Security

    b) Define Interface (if you want to upload data to Oracle E-Business Suite)

    c) Define Content

    d) Define Uploader (if you want to upload data to Oracle E-Business Suite)

    e) Define Importer (if you want to validate and import data from Interface to Oracle E-Business Suite base tables)

    2. Define Layout

    3. Define Mapping (if you want to upload data to Oracle E-Business Suite)

    4. Preview Integrator

    I am not sure if you have followed these steps. For more information on each of these steps, please refer Oracle E-Business Suite Desktop Integration Framework Developer's Guide, Release 12.1.3, Part Number E15877-02.

    Thanks,

    Rekha


  • Naveen Wednesday, June 27, 2012

    Hi,

    I had created custom integrator in 11i and in that i want to use Date LOV for one column. Is it possible?if yes can you give me the brief information.


  • Rekha Ayothi Wednesday, June 27, 2012

    Hi Naveen,

    Date LOV can be defined for a column, for integrators created using Desktop Integration Framework (DIF). However, please note that the ability to create custom integrator in Web ADI is available only from Oracle E-Business Suite Release 12.1.2. Custom integrators are not supported in 11i. And, one should use DIF to create custom integrators.

    Thanks,

    Rekha


  • guest Wednesday, June 27, 2012

    Hi Rekha,

    I have developed Web ADI custom integrator in 11i using API's and we are using it from long time.Now my requirement is to add a calender LOV when we click on the date column.

    Thanks,

    Naveen


  • guest Friday, July 6, 2012

    Hi I am wondering if any one submitted concurrent program through the importer as a last step in the custom integrator. if so can you please share the steps.

    Thank you

    -Seshu


  • guest Friday, July 6, 2012

    Hi Rekha,

    I have created custom integrator and it is working fine and I am trying to run the interface as part of the custom integrator by

    Defining Importer (if you want to validate and import data from Interface to Oracle E-Business Suite base tables)

    I have a pl/sql concurrent program which I am planning to run at the end and trying to define importer and it is failing to create. Do you have any example/specific instructions for this step.

    Thank you

    -Seshu


  • Rekha Ayothi Monday, July 9, 2012

    Hi Seshu,

    Couple of months back, we announced an important update for Web ADI R12.1.3:

    Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1 (Patch 9790225, R12.BNE.B)

    (Ref: https://blogs.oracle.com/stevenChan/entry/rollup_update_for_oracle_web)

    This update includes a number of new fixes and consolidates previously-released patches that address issues in the Desktop Integration Framework of Web ADI Release 12.1.3.

    If you haven't yet applied this patch, I suggest you apply the same. If you are facing the said issue after applying the patch, I suggest you log a Service Request in My Oracle Support, one of our support engineers will help you.

    Thanks,

    Rekha


  • guest Monday, July 16, 2012

    Hi Rekha,

    Do you have ant steps or docs for Depenedent LOV in WEB ADI.

    Regards

    Niraj


  • Rekha Ayothi Monday, July 16, 2012

    Hi Niraj,

    Web ADI framework supports dependent LOV, and Oracle-seeded integrators use them. However, as of Oracle E-Business Suite Release 12.1.3, Desktop Integration Framework does not have a provision to define dependent LOV from UI.

    Regards,

    Rekha


  • guest Thursday, July 19, 2012

    Thank you Rekha,

    The patch worked and I could attach concurrent program to the custom Integrator now.

    -Seshu

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

    Hi Seshu,

    Couple of months back, we announced an important update for Web ADI R12.1.3:

    Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1 (Patch 9790225, R12.BNE.B)

    (Ref: https://blogs.oracle.com/stevenChan/entry/rollup_update_for_oracle_web)

    This update includes a number of new fixes and consolidates previously-released patches that address issues in the Desktop Integration Framework of Web ADI Release 12.1.3.

    If you haven't yet applied this patch, I suggest you apply the same. If you are facing the said issue after applying the patch, I suggest you log a Service Request in My Oracle Support, one of our support engineers will help you.

    Thanks,

    Rekha


  • guest Wednesday, August 1, 2012

    Hi Rekha,

    I have defined importer. It is a pl/sql package procedure. Interface is a custom table.

    When I upload data using Web ADI template, data is loaded into the table ( as expected ) but it is not firing ( executing ) pl/sql package defined in the importer.

    There is no error and not sure how to debug this one.

    Any pointers to resolve the issue.

    Cheers


  • Rekha Ayothi Wednesday, August 1, 2012

    Hi Mahesh,

    One of the seeded Upload Parameters - 'Automatically Submit Import', determines the submission of import program. Ensure to set the value of this parameter as true. Please refer the guide for more information on this Upload Parameter - Oracle E-Business Suite Desktop Integration Framework Developer's Guide [Part No: E15877-02].

    Also, we published a white paper on how to define importer that returns error message. You may refer this step-by-step tutorial.

    (Ref: https://blogs.oracle.com/stevenChan/entry/new_whitepaper_on_web_applications)

    If you encounter the said issue after following the above suggested steps, please log a Service Request in My Oracle Support, one of our support engineers will assist you.

    Thanks,

    Rekha


  • Ashok Monday, November 5, 2012

    We are in 11.5.10.2 and created lot of Custom Integrators using Web ADI applications. We did not use any custom LOV's in them. Now we would like to use LOV capability with custom integrators (As we see this feature with default integrators provided by Oracle such as Journel Import, etc).

    In a white paper i found that we can use BNE_INTEGRATOR_UTILS.CREATE_TABLE_LOV package.procedure to enable this feature. But in our instance we see the package but this procedure is missing. Wanted to know if this is R12 only feature. If so can we get a patch to back port it to 11i.


  • Rekha Ayothi Tuesday, November 6, 2012

    Hi Ashok,

    Please note, Web ADI provides Desktop Integration Framework (DIF) to create custom integrators from Oracle E-Business Suite R12.1.2. As of today, Desktop Integration Framework and, hence the capability to create custom integrators is not available in 11i.

    However, you may refer following recorded online course for steps to create LOV in custom integrator in R12.1.2:

    Implement and Use Oracle E-Business Suite Desktop Integration Framework (http://oukc.oracle.com/static05/opn/metalinklogin/?t=offering&c=765622276)

    Thanks,

    Rekha


  • Anil Monday, December 24, 2012

    Hi Rekha,

    I have few questions, I want to add new where condition to existing LOV in seeded Integrator(Transaction Source LOV and Expenditure Type LOV) in PAXTTRXB (Projects- Transaction Import). is this possible?

    If not how to copy same integrator and customize?

    I tried using FNDLOAD its only copying Integrator definition and interface, but not Importer definition.

    Please advice

    Thanks

    Anil B


  • Rekha Ayothi Monday, December 24, 2012

    Hi Anil,

    Thanks for your query. Please note that you may not be able to modify Oracle seeded integrators.

    As of now, we do not have an ability to duplicate an existing integrator definition and then, customize it. This is a good requirement, we may evaluate to include this feature in future release. Please log an enhancement request in My Oracle Support.

    Thanks,

    Rekha


  • Rakesh Tuesday, January 22, 2013

    Hello Rekha,

    Can you please let me know how to get concurrent program parameters displayed in WebADI when i have an importer defined for a concurrent program after data upload.

    We are on R12.1.3

    Thanks

    Rakesh


  • Rekha Ayothi Wednesday, January 23, 2013

    Hi Rakesh,

    Thanks for the query. You can capture user-entered value during Upload process and, pass that value as Concurrent Program parameter value to Importer. Here is what you need to do while creating integrator:

    1. Create Upload Parameter

    2. In Concurrent Program Submission page, select 'Upload Parameter' as Source of Concurrent Program parameter.

    3. Enter Upload Parameter name defined in step 1 here.

    For details, refer Oracle E-Business Suite Desktop Integration Framework Developer's Guide [Section: To define a concurrent program request submission importer rule]:

    http://docs.oracle.com/cd/B53825_08/current/acrobat/121bnedg.pdf

    Thanks,

    Rekha


  • Rakesh Wednesday, January 23, 2013

    Hello Rekha,

    Thanks a lot, i am able to get the parameters for submission of the concurrent program but when i pass the parameters, I get the following error

    The import program could not be started. Contact your system administrator.. Parameter 5 from the CONCURRENT_REQUEST import step parameter list 20003:ZENGL_SUMM_LOAD_CP has the following error: API Parameter name is not defined in Attribute 1.

    The program has only 2 parameters , please advise.

    Thanks

    Rakesh


  • Rakesh Wednesday, January 23, 2013

    Hello Rekha,

    Applied Patch#11704204 and still getting the same error.

    Please let me know.

    Thanks

    Rakesh


  • Steven Chan Wednesday, January 23, 2013

    Hello, Rakesh,

    I'm sorry to hear that you've encountered an issue with this.

    We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

    Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

    Please feel free to forward your Service Request number to Rekha and I if it gets stuck in the support process for some reason.

    Regards,

    Steven


  • guest Tuesday, February 5, 2013

    Hi,

    I wanted to know if the Layout is customizable (Not just customization of Columns) like adding another detail region.

    E.g if there is a Header Record to be uploaded in Standard, I would like to create another Detail region and then store it in a custom table. I also have to take care of the relationship.

    Possible?

    Regards,

    Satya


  • Rekha Ayothi Tuesday, February 5, 2013

    Hi Satya,

    Layout lets you customize the way fields are presented in spreadsheet. So you can determine the fields displayed in spreadsheet, their position, etc. The fields may be placed in Context or Header or Line (i.e., Details) region. Web ADI supports single Context and single Line region. You may have multiple Header regions.

    For more information on Layout capabilities, refer Oracle Web Applications Desktop Integrator Implementation and Administration Guide:

    http://docs.oracle.com/cd/B53825_08/current/acrobat/121bneig.pdf

    If your requirement is to introduce new fields and capture the data in custom table, you may have to create custom integrator. And, Desktop Integration Framework is the tool for creating custom Web ADI integrators.

    Thanks,

    Rekha


  • Lance Tuesday, February 5, 2013

    Rakesh

    Did you find a resolution to the issue whereby you received the error:

    The import program could not be started. Contact your system administrator.. Parameter 5 from the CONCURRENT_REQUEST import step parameter list 20003:ZENGL_SUMM_LOAD_CP has the following error: API Parameter name is not defined in Attribute 1.

    after applying patch #11704204?

    I am running into the same issue and as I am new to building custom integrators I can't tell if it's me or the application that is not working correctly.


  • Rekha Ayothi Wednesday, February 6, 2013

    Hi Lance,

    Last year, we announced an important update for Web ADI R12.1.3:

    Oracle Web Applications Desktop Integrator 12.1.3 Release Update Patchset 1 (Patch 9790225, R12.BNE.B)

    Refer: https://blogs.oracle.com/stevenChan/entry/rollup_update_for_oracle_web

    This patchset includes fixes to issues such as this one in Desktop Integration Framework R12.1.3.

    If you haven't yet applied this patch, I suggest you apply the same. If you are facing the said issue after applying the patch, I suggest you log a Service Request in My Oracle Support, one of our support engineers will help you. Please feel free to forward me the Service Request number if it gets stuck up in support process for some reason.

    Thanks,

    Rekha


  • Lance Wednesday, February 6, 2013

    Thanks Rekha.

    We already have applied this patch as well which was why I was hoping that Rakesh may have found a resolution. I have opened a case with Oracle support and will keep all updated on what we find.

    Many Thanks

    Lance


  • Satya Thursday, February 7, 2013

    Hi rekha

    Thanks a lot for speedy reply.

    What I understand from ur reply is that its not possible to achieve what I want to.. to create another line (detail region).

    There cud be technical reasons i can think of like linking detail region record to another CORRESPONDING sub-detail records.even if that is possible how would you link that to multiple tables or map records to api.Nevertheless its a great feature. I am only concerned how much time oracle would spend to include new features specially when fusion already has these features included out of the box.

    Satya

    PS: Forgot to add my name in last comment, adding it now so that it is easy to follow.


  • Rekha Ayothi Thursday, February 7, 2013

    Hi Satya,

    Please log a formal enhancement request for this new feature via My Oracle Support. And, send me your Service Request number.

    Thanks,

    Rekha


  • JudyZ Tuesday, February 12, 2013

    Rekha,

    I need to add a custom DFF field to the HR Integrator Setup template. I have made a copy of the template, but cannot figure out how to add our descriptive flexfield. Can this be done?

    Thank you,

    JudyZ


  • Rekha Ayothi Wednesday, February 13, 2013

    Hi JudyZ,

    HR Integrator Setup is one of the Oracle seeded integrators from HRMS. I may not be able to comment on its behavior with custom DFF.

    Thanks,

    Rekha


  • Saroj Mahanta Tuesday, February 26, 2013

    Hi,

    I went through all the Q&A in this page, but i didnt found my answer. Or probably i have missed it somehow. Well, my concern is i have upgraded my EBS system from 12.1.1 to 12.1.3. After login as sysadmin, i am unable to see the "Desktop Integration" responsibility.

    Please suggest, how can i see this responsibility ? Do i need to apply the patches which are mentioned for 12.1.2 ? or there is separate ML id to follow ?

    Thanks & Regards,

    Saroj Mahanta


  • guest Thursday, February 28, 2013

    Hi Rekha,

    We have an issue to be sorted out urgently. We are trying to upload asset activity association using webADI, we have built a custom integrator using the API EAM_ITEM_ACTIVITIES_PUB.Insert_item_activities

    However the upload always fails giving SQL cannot upload error. Our only suspicion is the pm_last_service_tbl column. We haven't given any value for this column, it is a mandatory field, so this might be the reason why our upload failed. Now if we have to give the value, how is it supposed to be given? The type is table and we don't know how to pass the value for this column. Please advise how a value for a column type as table needs to be populated in the excel cell.

    Thanks


  • Steven Chan Thursday, February 28, 2013

    Hi, Guest,

    I'm sorry to hear that you've encountered an issue with this.

    We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

    Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

    Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

    Regards,

    Steven


  • Rekha Ayothi Tuesday, March 5, 2013

    Hi Saroj,

    No, the patches mentioned in Web ADI Release notes 12.1.2 (My Oracle Support Knowledge Document: 950876.1), need not be separately applied for "Desktop Integration" responsibility in 12.1.3. "Desktop Integration" responsibility should continue to be accessible after you upgrade E-Business Suite from 12.1.1 to 12.1.3.

    Ensure that "Desktop Integration" responsibility assigned to "sysadmin" user is active (check Effective From and To dates from User Management screens).

    Still, if you are unable to access this responsibility, log a service request in My Oracle Support and feel free to send me the SR number.

    Thanks,

    Rekha


  • guest Monday, March 25, 2013

    I want to create dependent LOV's for the web ADI.

    For eg: Supplier and Supplier Site

    Supplier Field : LOV displaying all the active suppliers

    Supplier Site Field: Dependent LOV displaying all the sites under the Supplier entered.

    thanks,

    Ram


  • Rekha Ayothi Monday, March 25, 2013

    Hi Ram,

    Currently, Dependent LOV is used by Oracle seeded integrators. As of R12.1.3, Desktop Integration Framework does not have a provision to define dependent LOV for custom integrators.

    Please log enhancement request in My Oracle Support for Dependent LOV in Desktop Integration Framework.

    Thanks,

    Rekha


  • jasper Monday, April 15, 2013

    Does WebADI DIF support multi-DescFlexField on one excel row?

    I am testing DFF function and it is working fine.

    Now I want to import 2 diffent DFFs from one excel row, such as header's DFF and line's DFF.

    Is possible or not?

    Thx!

    Regards,

    Jasper


  • Rekha Ayothi Monday, April 15, 2013

    Hi Jasper,

    Yes, you can have multiple DFFs defined in an integrator; and, it can be in a row.

    I didn't quite understand your requirement of Header DFF and Line DFF in a row - did you mean Header DFF would be repeated for all Line items? Can you mail me the use case with example?

    Thanks,

    Rekha


  • guest Saturday, June 8, 2013

    Hi All,

    My concern is that if we have 5 rows in web-adi excel and if all the rows are valid then only the data need to be inserted into staging table. If any one of row validation fails all the rows need not be inserted. please tell me how we can achieve it.

    Regards

    manish gupta


  • manish kumar gupta Saturday, June 8, 2013

    Hi All,

    I have an issue in web-adi that if we have 5 rows in web-adi sheet and if all the rows are valid then only the data need to be inserted into staging table. If any one of rows validation failed then all the rows need not be inserted.Please suggest me.

    Thanks

    Manish


  • Rekha Ayothi Monday, June 10, 2013

    Hi Manish,

    I didn't quite get your concern because, as of today, Web ADI behaves the way you have mentioned. That is, if multiple rows are being uploaded from Web ADI spreadsheet, and if any of the row fails validation rules, then none of the rows are uploaded. The rows are uploaded only if all of them pass validation rules. And, as of R12.1.3, you don't have to do anything special to achieve this functionality.

    By any chance, are you referring to any specific Oracle seeded Web ADI integrators?

    Thanks,

    Rekha


  • guest Saturday, June 15, 2013

    Hi,

    In Excel 2013 for 'Add-ins' WHICH Name or Location (from Right Panel) is to select so that 'Add-Ins' is added and Displayed in EXCEL MENU bar?

    It is observed that sometime this 'Add-Ins' appears / displays in the MENU and other times it doesn't.

    Similarly while uploading, the data, only first 10 rows are uploaded. Where is setup we are missing?

    Purpose is to upload any number of rows, as there are thousands of lines / rows to upload.

    We are uploading PO and Supplier Prices data in a customized Table first. Then a procedure (already developed) will validate the data and fill-in PO Interface tables (2 or 3 depending on uploaded data), from where the standard "Import Price Catalogs" or "Import Standard Purchase Orders" will process the data.

    Also what is community name for WEB ADI in the MOS communities?

    Best regards,

    MohammadYar


  • Rekha Ayothi Monday, June 17, 2013

    Hi Mohammad Yar,

    Please note Web ADI is not yet certified with Excel 2013. Let me know, if you are facing this issue in Excel 2010 or earlier versions.

    We do have plans to certify with Office 2013. Refer this blog:

    https://blogs.oracle.com/stevenChan/entry/plans_for_certifying_microsoft_office

    Feel free to subscribe to our blog, we will announce as and when it is certified.

    Thanks,

    Rekha


  • Sunil Atluri Friday, August 2, 2013

    Hi Rekha

    Thanks for the post. I need to upload a GL Journal using WebADI. Before submitting I need to call a webservice or a pl/sql API to an other system to perform Custom Cross validation of the GL segements (Thrid party system which maintains cross validation rules).

    Can I achieve it using a DIF. Appreciate your input.

    Thanks

    Sunil


  • Rekha Ayothi Monday, August 5, 2013

    Hi Sunil,

    DIF provides an ability to call PL/SQL API registered in APPS schema, before submitting the main import program. As of now, it does not provide an ability to invoke web service from another application. It is definitely a good requirement. I will note it down. Meanwhile, you can log an Enhancement Request in My Oracle Support to track this requirement.

    Thanks,

    Rekha


  • Sekhar G Monday, August 12, 2013

    Hi Rekha,

    In Addtion to the below mail from wrote by Anil on December 24, 2012 at 12:03 AM PST.

    Do you have any update on the below issue?

    I have few questions, I want to add new where condition to existing LOV in seeded Integrator(Transaction Source LOV and Expenditure Type LOV) in PAXTTRXB (Projects- Transaction Import). is this possible?

    If not how to copy same integrator and customize?

    I tried using FNDLOAD its only copying Integrator definition and interface, but not Importer definition.

    Please advice

    Thanks

    Sekhar G


  • Rekha Ayothi Tuesday, August 13, 2013

    Hi Sekhar,

    Thanks for your query and reference.

    We have Enhancement Request 14068572 to track this requirement internally. If you wish to strengthen this ER, please log formal Service Request in My Oracle Support with your business case. This will help in prioritizing this ER.

    Thanks,

    Rekha


  • Rakesh Monday, October 7, 2013

    Hello Rekha,

    I am using the fnd_global.conc_request_id in my custom package for custom webADI Integrator and it is generating -1. Can you please advise.

    Thanks

    Rakesh


  • Rekha Ayothi Friday, October 11, 2013

    Hi Rakesh,

    I am sorry to hear that you are facing this issue. Please file a Service Request in My Oracle Support, one of our Support Engineers will help you.

    Thanks,

    Rekha


  • Pradeep Wednesday, November 13, 2013

    Hi,

    We are defining a custom Integrator based on the standard Project Interface table, PA_TRANSACTION_INTERFACE_ALL.

    I had few queries -

    Should we define a way for generating a value for the INTERFACE_ID (The column uniquely identifies the Record into the Interface table).

    Also, currently I am getting an error during upload -

    Unable to perform column validation due to program error.

    Any help would be appreciated.

    Thanks

    Regards

    Pradeep


  • Pradeep Thursday, November 14, 2013

    Also experts, my other query is -

    If i use Table as my Interface, and develop a Web ADI Template (without any Pre-Import Rules)-

    Use that Web ADI Template (Excel Sheet) to enter table data and further Upload it, will the insert directly happen into the Table.

    Sorry for my simple queries. As I am yet to do a cycle of Insertion. Struggling due to an error above. I guess the error came due to some columns being "Not Null" or "REquired in all Layouts" but not displayed. I am looking into it and checking it.

    Regards

    Pradeep


  • Pradeep Thursday, November 14, 2013

    Hi All,

    I was able to do a upload of data to the PA_TRANSACTION_INTERFACE_ALL from Web ADI Template (After unchecking the check box - Validate Before Upload). Request experts to share a knowledge on - Where do we build this Validation? It is not Pre-Import rules right. Or is the Validation on the Data assigned using LOV?

    An interesting thing i noted is the coloumn - TRX_INTERFACE_ID.

    I have not defined any logic to derive the data for this coloumn.

    Request experts to share some knowledge on how this data was derived for this column.

    Appreciate your help.

    Regards

    Pradeep


  • Rekha Ayothi Thursday, November 14, 2013

    Hi Pradeep,

    Let me try to answer some of your queries in last 3 comments:

    1. On generating unique value for ID column

    Yes, there is a way. 'Sequence' is one of the Pre-Import Rule Types. So, you can create a sequence, define pre-import rule and assign sequence value to the interface attribute. However, I am not the right person to answer how INTERFACE_ID column in Oracle Projects table PA_TRANSACTION_INTERFACE_ALL works.

    2. Upload data without pre-import rules

    As such defining an Importer is optional. That is, you may have Web ADI integrator without an importer. In this case, data from spreadsheet will be uploaded to Interface Table.

    3. On Validate Before Upload

    This option refers to the validation defined at the Interface Attribute level such as, LOV. It is not referring to Pre-Import rules.

    I did not understand your query about TRX_INTERFACE_ID. You may raise Service Request in My Oracle Support for such queries as well - one of our Support Engineers will help you.

    Thanks,

    Rekha


  • Rob Monday, November 18, 2013

    Hi Rekha

    I have a similar query to the one above regarding populating interface_id.

    I therefore have a database sequence and have created a pre-import rule for this sequence. However, can you please explain how to assign this to my interface attribute? It does not appear obvious and I cannot find it explained in documentation

    Thanks

    Rob


  • Pradeep Tuesday, November 19, 2013

    Thanks Rekha for your comments. Appreciate your reply.

    (1)

    For the TRX_INTERFACE_ID, i could see a value generated in the Table, PA_TRANSACTION_INTERFACE_ALL. But i have not defined any Sequence, etc to assign a value for this Interface Attribute.

    I have seen other Integrators where a sequence is assigned to the Interface Attribute as a Default SQL Query and the Default Value as - select XXXXXXX.NEXTVAL from dual. In my case, there is no such sequence defined or assigned.

    (2)

    How to create a LOV for a Key Flexfield Segments where User selects each segments. And based on security rules a valid code combination is selected.

    There is an option for defining an Interface Attribute using Key Flexfield and also a Component based on FLEX. But this does not seem to work. Giving an error -

    The value for Application ID supplied to the page flow is invalid

    Regards

    Pradeep


  • Pradeep Monday, November 25, 2013

    Dear All,

    I was able to get the Key Flexfield Values populated per my expectation after a long try with trail and error. Putting across the steps i did for benefit of all -

    Define individual segments to the Integrator

    Step (1):

    Attribute Name - Segment1...... (Define attributes equivalent to the number of segments in the KFF)

    Enables for Mapping - checked

    validation Type - Key Flexfield Segment

    Group Name - <Auto Selected based on below Group Setup>

    Segment Number - <Enter the Segment Number in the KFF Segment definition>

    Step (2):

    Define a Placeholder to hold the segment values

    Attribute Name - ACCOUNT_FLEX_FIELD_CR

    validation Type - Key Flexfield

    Group Name - Choose the Group Name created below

    Validation Entity - oracle.apps.bne.integrator.validators.BneKFFValidator

    Key Flexfield - <Instance specific flexfield>

    Concat Segment Values - Yes

    Component Name - OA_FLEX Component (Web ADI)

    Step (3):

    Define a Group to combine the above segment Segments

    Group Name - ACCOUNT_CR

    Attribute Name - ACCOUNT_FLEX_FIELD_CR

    Validation Type - Key Flexfield

    Key Flexfield - <Select the Key Flexfield>

    Validation Entity - <Auto Selected>

    Concat Segment Values - Yes

    Component Name - OA_FLEX Component (Web ADI)

    In the Select Group Attributes section -

    Select the Attributes defined as segments from Step (1)

    Regards

    Pradeep


  • Pradeep Wednesday, December 4, 2013

    Dear Folks,

    We have build a web ADI Template to load data to the Interface table. Post loading we are calling a PL/SQL Package procedure.

    Post entering data in the web ADI Template, and selecting Upload, we get the below error -

    Error validating bne:integrator attribute in bne:data element:. No parameter definition found

    Has anybody faced similar issue

    Regards

    Pradeep


  • Rekha Ayothi Wednesday, December 4, 2013

    Hi Pradeep,

    I am sorry to hear that you are facing this issue. Please log formal Service Request in My Oracle Support, one of our Support Engineers will assist you. Feel free to forward me the SR number.

    Thanks,

    Rekha


  • guest Thursday, December 5, 2013

    I am wondering whether I can use Web ADI 12.