Generating XML Schemas for Interface Tables

In this section:

When you deploy the iWay Application Adapter for Oracle E-Business Suite in the iWay Business Services Provider (iBSP) environment or an iWay Enterprise Connector for J2EE Connector Architecture (JCA) environment, you can generate schemas that define a service request document and the corresponding response document.

If you plan to deploy the iWay Application Adapter for Oracle E-Business Suite in a business services environment, you are not required to generate a schema.
Top of page
x
Schema Location

By default, iWay Explorer stores the schemas it creates in subdirectories under the iWay home directory of the machine where it is installed. However, you can also export these schemas using iWay Explorer to any location you specify on your file system.

The exact location of the schemas differs depending on whether you deploy iWay Explorer with an iBSP or a JCA configuration.

When the adapter is used with an iBSP configuration, iWay Explorer stores the schemas in a subdirectory of the iWay installation directory, for example,

					iWayHome\config\base\wsdl\schemas\service\Oracle\Oracle_Target

where:

Oracle_Target

Is the name of the connection (target) to the Oracle Applications system that you defined using iWay Explorer. Under this directory, iWay Explorer creates subdirectories containing schemas.

When the adapter is used with a JCA configuration, iWay Explorer stores the schemas under a \schemas subdirectory of the iWay home directory, for example,

					iWayHome\config\base\schemas\Oracle\Oracle_Target

where:

Oracle_Target

Is the name of the connection (target) to the Oracle Applications system that you defined using iWay Explorer. iWay Explorer stores the schemas in this directory.

You can generate schemas for interface tables, stored procedures under a package, and base tables and views. The procedure for generating a schema is identical for all three integration methods. The following procedures show examples of actual schemas generated for each integration method.
x
Procedure: How to Generate a Schema for an Interface Table

To generate a schema for an Oracle E-Business Suite interface table using iWay Explorer:

  1. Connect to an Oracle E-Business Suite target, as described in Connecting to Oracle E-Business Suite.
  2. Locate an interface table, as described in Browsing Interface Table Metadata.

    Note: The user ID for this target connection must have read access to the selected table; otherwise you cannot create schemas.

  3. Select a specific table on the left, for example, WIP_MOVE_TXN_INTERFACE.

    XML request and response schemas for the table are automatically created and displayed.

    The Detail, Data Elements, Request Schema, and Response Schema tabs appear on the right.

  4. Click the Request Schema tab in the right pane.

    The XML request schema appears in the right pane, as shown in the following image:

  5. Click the Response Schema tab in the right pane.

    The XML response schema appears in the right pane, as shown in the following image:

  6. To export XML schemas, right-click the table in the left pane, and select Export Schemas, as shown in the following image:

    The Select Export Directory dialog box opens, as shown in the following image:

  7. Navigate to a directory on your file system where you want to export the XML schemas.

    The file path displays in the File Name field.

  8. Click OK.

    The XML request and response schemas are now exported to your local file system.

iWay Software