Skip Headers

Oracle Fusion Middleware Adapter for Oracle Applications User's Guide
11g Release 1 (
Part Number E10537-03
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 E-Business Suite product information.

Deaf/Hard of Hearing Access to Oracle Support Services

To reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at, and a list of phone numbers is available at

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at

Accessibility of Code Examples in Documentation

Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.

Accessibility of Links to External Web Sites in Documentation

This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.


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

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). If you require printed guides, you can purchase them from the Oracle Store.

To download free release notes, installation documentation, white papers, or other collateral, please visit the main OTN page. You must register online before using OTN; registration is free and can be done at the OTN registration 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.