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

Update for Web Applications Desktop Integrator 12.1.3 Now Available

Rekha Ayothi
Product Management

Desktop Integration Framework is a wizard-driven user interface to create and manage custom desktop integrators for the Oracle Web Applications Desktop Integrator in Oracle E-Business Suite 12.1.3. Custom desktop integrators allow your users to:

  • Create a formatted document such as a spreadsheet on the desktop containing application-specific fields for data entry.
  • Import data into the desktop document from the database, a text file or using Java program.
  • Work with the data in the desktop application while enforcing the owning application's business rules.
  • Upload data from the desktop document into Oracle E-Business Suite.
  • Validate the data being uploaded and receive immediate feedback about the results of the validation during the upload process.
  • Submit program to import data from staging tables, Open Interface tables to E-Business Suite base tables.
Web ADI Desktop Integration Framework screenshot

What's new in this update?

An important update for Oracle Web Applications Desktop Integrator Release 12.1.3 is now available:

This update includes a number of new fixes and consolidates previously-released patches that address issues in the Desktop Integration Framework of Oracle Web Applications Desktop Integrator Release 12.1.3. If you are using or planning to use Web ADI's Desktop Integration Framework to create custom desktop integrators, Oracle strongly recommends applying this patch.

Patch 9790225:R12.BNE.B not only fixes outstanding bugs in Web ADI R12.1.3, but also includes following usability enhancements:
  • Security Rules: Ability to add or remove multiple form functions at once. 
  • Pre-import Rules: Ability to reorder the pre-import rules.
  • The pages in the integrator definition wizard are enhanced for greater consistency in titles, formatting, and layout.  


Related Articles



Join the discussion

Comments ( 19 )
  • guest Wednesday, August 22, 2012

    Hello Rekha,

    can you please confirm that the new "Desktop Integration Framework" cannot be used to create custom integrators for the HRMS module?



  • Rekha Ayothi Thursday, August 23, 2012

    Hi Paolo,

    You can create custom integrators for HRMS module using Desktop Integration Framework. There is no such limitation in Desktop Integration Framework for HRMS module.



  • Paolo Marzucco Tuesday, August 28, 2012

    Good morning Rekha,

    thanks a lot for your answer.

    It is anyway strange that Oracle HR Development told me the opposite in an SR I opened, because I have problems in creating custom application integrators for the HRMS module using the Desktop Integration Framework.

    The main problem is that when associating an integrator to an HR form, the DIF forms do not create the correct parameter list for the form in question (like the standard "HR Integrator Setup" integrator is doing) and for that reason the integrator is not available when using Web ADI export icon from that form. Is that a bug or is it just unforeseen functionality?



  • guest Tuesday, October 16, 2012

    Good morning Rekha,

    just for your information, DEV has finally confirmed that it is not supported to create HR related integrators via the new "Desktop Integration Framework".

    For this reason I have asked to create the following Enhancement Request:


    It would be nice if you could follow it up and make sure it gets implemented, so that also HR users will be able to exploit the huge advantages of the "Desktop Integration Framework".



  • Joseph Mathew Tuesday, December 4, 2012

    Can Patch 9790225 be applied to a 12.1.2 install that has ATG 12.1.3 (Patch 89194910) and Patches 8919489 & 9239089 installed?

  • Rekha Ayothi Wednesday, December 5, 2012

    Hi Joseph,

    DIF consolidated patch 9790225:R12.BNE.B is built on top of ATG R12.1.3, that is on top of code levels - R12.AD.B.delta.3 (Patch 8919489) & R12.ATG_PF.B.delta.3 (Patch 8919491).

    As you are in R12.1.2 level, you would need to follow the steps in My Oracle Support Note: 1066312.1 for ATG R12.1.3, before applying 8919491, 9239089 or 8919489 patches.



  • Denzil Thursday, December 6, 2012

    Hi Rekha,

    We are working on a solution to provide WebADI to refresh Inventory tables, can you pls let us know if it is possible to do the same?

    Thanks and regards,


  • Denzil Thursday, December 6, 2012

    Hi Rekha,

    We have a requirement to update inventory using WebADI, we're using R12.1.3, can you comment on the possibility of creating a custom integrator for inventory and suggest any whitepapers for step by step installation of the same.



  • Rekha Ayothi Thursday, December 6, 2012

    Hi Denzil,

    Nice to hear from you. As I am not a subject matter expert of Inventory, I may not be able to guide you specifically on Inventory. In general, here are few things you may want to consider while you prepare to create custom integrator:

    1. Data level Validation rules

    2. Business rules that can be implemented using APIs.

    3. Interface (Open Interface tables) - where do you want to upload data

    4. Content - Source of data

    5. Public APIs provided by Inventory

    I suggest you to refer Integration Repository (available in your E-Business Suite R12.1.3 instance through Integrated SOA Gateway responsibility). If you do not find any appropriate API, please file Service Request with My Oracle Support, one of our Support Engineers will assist you.



  • guest Wednesday, July 10, 2013

    Hi Rekha,

    I had created one custom integrator and its working fine in development instance and I created ldt file from development instance by using FNDLOAD utility.

    when I migrated this custom integrator into Test instance , I am getting error message as below 'XXcustom:cust_intg' is an invalid integrator key'.

    Thanks & Regards


    I am accessing this from AP responsibility and this integrator is not in editable mode.

  • Rekha Ayothi Thursday, July 11, 2013

    Hi Ram,

    I am sorry to hear that you are facing this issue. Please log a Service Request in My Oracle Support. One of our Support Engineers will help you. Feel free to forward me the Service Request number.



  • Sue Wednesday, August 21, 2013

    Hello Rekha

    I created a custom Integrator to download and upload data into a custom table. How do I update data. Right now any changes I make to the data in the spreadsheet is uploaded as new row. What do I have to do to make it a upload instead of insert.



  • Rekha Ayothi Thursday, August 22, 2013

    Hi Sue,

    Please log a formal service request in My Oracle Support. And, feel free to forward me the SR number.



  • guest Sunday, December 29, 2013

    Hi Rekha,

    We have a requirement to create a WebADI template for uploading AP Invoices. Have below questions in this regard.

    1. Can we use a custom table say XXAP.XXAP_INVOICES_INT (registered to custom Application say XXAP )

    2. The problem in using the standard open interface table is that Invoice data comprises of Invoice Headers (that goes to AP_INVOICES_INTERFACE) and Invoice Lines (that goes to AP_INVOICE_LINES_INTERFACE. Which means I should create 2 integrators and that gives two layouts one for entering headers and another one for lines and users dont like this.

    Can you please give me a quick confirmation on this. I tried creating integrator for custom Application (XXAP) but while creating Interface, there are no tables listed in the LOV. (When I queried I have 20 custom tables)


    Naresh Mankala


    Naresh Mankala

  • Dawn Wernette Wednesday, June 3, 2015

    We are looking for a template for loading AP invoices into eBS. Is that now available or must it be built? Can it be built in version

  • Rekha Ayothi Friday, June 5, 2015

    Hi Dawn,

    Thanks for your comment. I am afraid, I may not be able to speak for AP Invoices. You may have to check with your Oracle Account Manager or Oracle Support for assistance.

    However, in general, Desktop Integration Framework - the tool to create custom Web ADI integrators, is available from R12.1.2 onwards. It is not available in earlier releases of E-Business Suite.



  • guest Thursday, February 18, 2016

    Hi I am defining the custom download integrator to export the form data to excel based on the sql query..

    1. I defined the custom integrator

    2. I defined the content based on the sql query with parameter

    3. I created form function and assiged to the menu

    4. I am calling the Custom adi function from the "tool" menu on the standard oracle form ( persoanlized the form to enable the function call from the tool)

    Now when user query the data in the form , One of the form field value need to pass as parameter to the integrator so that user don't need to enter the parameter...

    Ex. User query the Expenditure batch... the custom adi should take the

    block.field value ( Groups.expenditure_group value ) as parameter and export the data based on the sql results.

    Can any one help me how to define parameter and pass the value dynamically to ADI.

    Thanks for the help


  • Kendo Nagasaki Thursday, November 30, 2017
    Sorry to jump on an old blog but does anyone know if ADI DIF supports MOAC? Oracle Support certainly don't know and are hiding behind the old "we support the tool, not what you do with the tool" line. In 12.1.3 I have a responsibility with MO: Default Operating Unit, MO: Operating Unit and MO: Security Profile all set but MOAC doesn't work in LOV's etc.
  • Rekha Ayothi Friday, December 1, 2017
    Hi Kendo,

    As of today, Web ADI framework does not provide MOAC initializations for LOVs. And, it is not available by default via DIF as well. If required, you would have to handle them explicitly.

    Please file an Enhancement Request in My Oracle Support, it will help in tracking this requirement.

Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.