Wednesday Jul 18, 2012

New Whitepaper: Defining Web Applications Desktop Integrators That Return Error Messages

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.  You can use the Desktop Integration Framework (DIF) to create custom integrators for Oracle Web ADI in Oracle E-Business Suite Release 12.1.2. The ability to create custom importers was added in EBS 12.1.3.

I am pleased to announce the release of a new white paper that provides a step-by-step tutorial on how to use the Desktop Integration Framework to define a Microsoft Excel-based integrator.  The example in the tutorial shows how to define an importer that returns error messages for any spreadsheet rows that failed to import into an E-Business Suite database. It describes the steps in 3 phases: 

  • Preparing that database and application objects

This phase provides the sample code to create a custom table and PL/SQL package which will be used for importing the data from a Microsoft Excel spreadsheet into an E-Business Suite table. It also describes the steps to create an FND Lookup code and its value, which will be used to map error codes and their corresponding messages.

  • Phase A: Defining an integrator that downloads and uploads data

This phase provides the steps to create a basic integrator using the Web ADI Desktop Integration Framework. It describes the steps to define the integrator's Interface, Content, Uploader, Layout, and Mapping.

  • Phase B: Defining an integrator importer that returns error messages

This phase provides the steps to define importer. It extends the integrator definition to process the data uploaded in the interface table and return error messages back to the desktop document for any rows that failed to import.

Screenshot of SQL query definition screen

The intended audience of this document is custom desktop integrator developers who are familiar with Oracle E-Business Suite and Oracle Web Applications Desktop Integrator.

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

Download the new whitepaper

The white paper is available in two places -- Oracle Learning Library (OLL) and My Oracle Support:

References

Related Articles

Monday Dec 12, 2011

Reminder: ATG Live Webcast Dec. 15: Desktop Integration Beyond Client ADI

If you're interested in seeing the next generation of the desktop integration toolset in EBS 12, make sure that you tune into the next installment of our ATG Live Webcast series this week on Dec. 15, 2011:

Join Gustavo Jimenez, Senior Development Manager and Senthilkumar Ramalingam, Manager, for this wide-ranging discussion on the topic of desktop integration within E-Business Suite.

Web ADI Architecture diagram

Need to work with Oracle E-Business Suite data in desktop applications or Microsoft Office? The desktop client-based version of ADI isn't available in Oracle E-Business Suite 12. What do you use now? This session will give you an overview of the new expanded functionality available in WebADI, Report Manager, and dedicated integrators.

You have more options for desktop integration now, not less. Topics will include an overview of prepackaged solutions for integrating Oracle E-Business Suite applications with applications such as Microsoft Excel, Word, and Projects. This session will also discuss using the new wizard-based Desktop Integration Framework to create custom integrators to download, validate, upload data from Excel to Oracle E-Business Suite.

This one-hour webcast provides an overview of desktop integration with Q&A. This events are targeted to system administrators, DBAs, developers, and implementers, and you can feel free to invite your desktop users to this event to ask their questions.

The agenda for the Desktop Integration Beyond ADI webcast includes the following topics:

  • Overview of Web ADI
  • Overview of Report Manager
  • Client ADI, Web ADI and Report Manager
  • Desktop Integration Framework
  • WebADI and Report Manager in Release 12.1

Date:              Thursday, December 15, 2011
Time:              8:00 AM - 9:00 AM Pacific Standard Time
Presenters:  Gustavo Jimenez, Senior Development Manager
                        Senthilkumar Ramalingam, Manager

Webcast Registration Link (Preregistration is optional but encouraged)

To hear the audio feed:

    Domestic Participant Dial-In Number:           877-697-8128
    International Participant Dial-In Number:      706-634-9568
    Additional International Dial-In Numbers Link:
    Dial-In Passcode:                                              98513

To see the presentation:

    The Direct Access Web Conference details are:
    Website URL: https://ouweb.webex.com
    Meeting Number:  278307572

If you miss the webcast, or you have missed any webcast, don't worry -- we'll post links to the recording as soon as it's available from Oracle University.  You can monitor this blog for pointers to the replay. And, you can find our archive of our past webcasts and training here.

Monday Dec 05, 2011

ATG Live Webcast: Desktop Integration Beyond Client ADI

I am pleased to announce the ATG Live Webcast event for Dec. 15.

Join Gustavo Jimenez, Senior Development Manager and Senthilkumar Ramalingam, Manager, for this wide-ranging discussion on the topic of desktop integration within E-Business Suite.

Need to work with Oracle E-Business Suite data in desktop applications or Microsoft Office? The desktop client-based version of ADI isn't available in Oracle E-Business Suite 12. What do you use now? This session will give you an overview of the new expanded functionality available in WebADI, Report Manager, and dedicated integrators.

You have more options for desktop integration now, not less. Topics will include an overview of prepackaged solutions for integrating Oracle E-Business Suite applications with applications such as Microsoft Excel, Word, and Projects. This session will also discuss using the new wizard-based Desktop Integration Framework to create custom integrators to download, validate, upload data from Excel to Oracle E-Business Suite.

This one-hour webcast provides an overview of desktop integration with Q&A. This events are targeted to system administrators, DBAs, developers, and implementers, and you can feel free to invite your desktop users to this event to ask their questions.



The agenda for the Desktop Integration Beyond ADI webcast includes the following topics:

  • Overview of Web ADI
  • Overview of Report Manager
  • Client ADI, Web ADI and Report Manager
  • Desktop Integration Framework
  • WebADI and Report Manager in Release 12.1

Date:              Thursday, December 15, 2011
Time:              8:00 AM - 9:00 AM Pacific Standard Time
Presenters:  Gustavo Jimenez, Senior Development Manager
                        Senthilkumar Ramalingam, Manager

Webcast Registration Link (Preregistration is optional but encouraged)

To hear the audio feed:

    Domestic Participant Dial-In Number:           877-697-8128
    International Participant Dial-In Number:      706-634-9568
    Additional International Dial-In Numbers Link:
    Dial-In Passcode:                                              98513

To see the presentation:

    The Direct Access Web Conference details are:
    Website URL: https://ouweb.webex.com
    Meeting Number:  278307572

If you miss the webcast, or you have missed any webcast, don't worry -- we'll post links to the recording as soon as it's available from Oracle University.  You can monitor this blog for pointers to the replay. And, you can find our archive of our past webcasts and training here.

If you have any questions or comments, feel free to email Bill Sawyer (Senior Manager, Applications Technology Curriculum) at BilldotSawyer-AT-Oracle-DOT-com.

About

Search

Categories
Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
6
8
9
10
12
13
14
15
16
17
18
19
20
22
23
25
26
27
29
30
31
     
Today