Intended Audience

Welcome to the Oracle Fusion Middleware Oracle E-Business Suite Adapter User's Guide, 12c (

This documentation is written for the technical consultants, implementers and system integration consultants who use Oracle Fusion Middleware Oracle E-Business Suite Adapter (formerly known as 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 that have purchased support 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
2  Introduction to Oracle E-Business Suite Adapter
3  Oracle E-Business Suite Adapter Features
4  Oracle E-Business Suite Adapter 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
11  Runtime Configuration for Oracle E-Business Suite Adapter
A  Troubleshooting and Workarounds
B  Oracle E-Business Suite Adapter 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 Oracle E-Business Suite Adapter.


You may want to refer to other Oracle Fusion Middleware guides when you set up and use Oracle Fusion Middleware Oracle E-Business Suite Adapter. 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 12c 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 12c 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.