Skip Headers

Oracle Fusion Middleware Adapter for Oracle Applications User's Guide
11g Release 1 (
Part Number E10537-05
Go to Table of Contents
Go to previous page
Go to next page


Intended Audience

Welcome to the Oracle Fusion Middleware Adapter for Oracle Applications User's Guide, 11g Release 1 (

This documentation is written for the technical consultants, implementers and system integration consultants who use Oracle Fusion Middleware Adapter for Oracle Applications.

This guide assumes you have a working knowledge of the following:

If you have never used these products, Oracle suggests that you attend training classes available through Oracle University.

See Related Information Sources for more Oracle Applications product information.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.


1  What's New in This Guide for Release
2  Introduction to Adapter for Oracle Applications
3  Adapter for Oracle Applications Features
4  Adapter for Oracle Applications Concepts
5  Using XML Gateway
6  Using Business Events
7  Using Concurrent Programs
8  Using Interface Tables and Views
9  Using PL/SQL APIs
10  Using e-Commerce Gateway
A  WSDL Definition File and Connection Information Details
B  Troubleshooting and Workarounds
C  Adapter for Oracle Applications Properties

Related Information Sources

You can choose from many sources of information, including online documentation, training, and support services, to increase your knowledge and understanding of Oracle Fusion Middleware Adapter for Oracle Applications.


You may want to refer to other Oracle Fusion Middleware guides when you set up and use Oracle Fusion Middleware Adapter for Oracle Applications. You can read the guides online by reading from the Oracle Fusion Middleware or Oracle Database Documentation Library CD included in your media pack, or on the Oracle Technology Network (OTN).

To download free release notes, installation documentation, white papers, or other collateral, please visit the main OTN page.


Oracle offers a complete set of training courses to help you and your staff master Oracle Fusion Middleware 11g and reach full productivity quickly. These courses are organized into functional learning paths, so you take only those courses appropriate to your job or area of responsibility.

You have a choice of educational environments. You can attend courses offered by Oracle University at any one of our many Education Centers, you can arrange for our trainers to teach at your facility, or you can use Oracle Learning Network (OLN), Oracle University's online education utility.

Tip: For information about upcoming instructor-led training, please refer to Oracle University's course offerings.

In addition, Oracle training professionals can tailor standard courses or develop custom courses to meet your needs. For example, you may want to use your organization’s structure, terminology, and data as examples in a customized training session delivered at your own facility.


From on-site support to central support, our team of experienced professionals provides the help and information you need to keep Oracle Fusion Middleware 11g working for you. This team includes your Technical Representative, Account Manager, and Oracle’s large staff of consultants and support specialists, with expertise in your business area, managing an Oracle Database, and your hardware and software environment.

Do Not Use Database Tools to Modify Oracle E-Business Suite Data

Oracle STRONGLY RECOMMENDS that you never use SQL*Plus, Oracle Data Browser, database triggers, or any other tool to modify Oracle E-Business Suite data unless otherwise instructed.

Oracle provides powerful tools you can use to create, store, change, retrieve, and maintain information in an Oracle database. But if you use Oracle tools such as SQL*Plus to modify Oracle E-Business Suite data, you risk destroying the integrity of your data and you lose the ability to audit changes to your data.

Because Oracle E-Business Suite tables are interrelated, any change you make using an Oracle E-Business Suite form can update many tables at once. But when you modify Oracle E-Business Suite data using anything other than Oracle E-Business Suite, you may change a row in one table without making corresponding changes in related tables. If your tables get out of synchronization with each other, you risk retrieving erroneous information and you risk unpredictable results throughout Oracle E-Business Suite.

When you use Oracle E-Business Suite to modify your data, Oracle E-Business Suite automatically checks that your changes are valid. Oracle E-Business Suite also keeps track of who changes information. If you enter information into database tables using database tools, you may store invalid information. You also lose the ability to track who has changed your information because SQL*Plus and other database tools do not keep a record of changes.