Using iWay Application Adapter for Oracle E-Business Suite, you can now interact with Oracle E-Business Suite in three ways: using Oracle interface tables and custom interface tables, stored procedures under a package, or base tables and views. These integration methods are listed and briefly described in the following section.
Interface tables are one mechanism Oracle E-Business Suite uses to expose its business processing. Through this mechanism, data is never modified directly in Oracle E-Business Suite base tables and views. The iWay Application Adapter for Oracle E-Business Suite enables you to import data into Oracle E-Business Suite using specific Oracle-supplied interface tables or custom interface tables. Instead of transforming input documents into standards-based XML structures, the request document is transformed to match the appropriate Oracle-specific interface table.
Oracle recommends that users do not interact directly with application tables. The open interface APIs serve as bridges between the Oracle application modules and external systems. The iWay Application Adapter for Oracle E-Business Suite utilizes these tables to interact with Oracle. They are categorized according to functional area. This is achieved as a two-step process through the adapter. First, a record is inserted into the interface table and then an Oracle-supplied concurrent program moves the data from interface to base tables and views, ensuring that all business logic and processing is handled through Oracle-authored components. In Oracle E-Business Suite, concurrent processing simultaneously executes programs running in the background with online operations to fully utilize your hardware capacity.
For more information on integration using Oracle interface tables or custom interface tables, see Browsing Interface Table Metadata.
Oracle E-Business Suite supports PL/SQL blocks, package. A package is a PL/SQL construct that allows related objects to be stored together. The adapter is able to expose all the packages and interact with its stored procedure element. In the iWay Application Adapter for Oracle E-Business Suite, packages are categorized by the schema that owns the object. Using iWay Explorer, you can search for specific packages and specific stored procedures.
Note: If you do not see a package under a schema, you may need to create a public synonym. For more information, see How to Search for Packages.
You can now interact directly with Oracle E-Business Suite base tables, bypassing interface tables and concurrent programs. This integration method is most appropriate when you need to query data located in Oracle base tables and views.
Important: The use of INSERT, DELETE, or UPDATE to directly modify data in Oracle base tables is not recommended, as it may jeopardize database referential integrity.
For more information on interacting with Oracle base tables and views, see Browsing Interface Table Metadata.