Using the Adapter with Oracle APIs

The iWay Application Adapter for Oracle E-Business Suite uses an iWay wrapper to interact with Oracle APIs with complex data types, such as table and record types. The wrapper, which must be manually installed, contains two stored procedures, get_api_definition and run_api. These stored procedures are internally executed as 'APPS' user. The adapter interacts with the wrapper at design‑time through the get_api_definition stored procedure, and at run‑time through the run_api stored procedures. The adapter uses an Oracle thin driver, such as ojdbc14.jar, to interact with the Oracle database. For installation instructions, see Installing the iWay Oracle API Wrapper.

Note: It is presumed that the following initialization parameters are required to run the standard APIs; org_id, application_id, responsibility_id, and user_id.

An additional parameter (iway_oraapps) is also included in the XML request schema to support APIs in non-Oracle application environments.


iWay Software