Browsing Interface Table Metadata

How to:

Browsing interface table metadata in iWay Explorer can be useful when creating request documents.

In this release, iWay Application Adapter for Oracle E-Business Suite supports two new categories of interface tables: Human Resources (HR) and Customer Relationship Management (CRM). CRM is a new feature in Oracle Applications Release 11.5.10.

Procedure: How to Browse Interface Table Metadata

To browse Oracle E-Business Suite interface table metadata:

  1. Connect to an Oracle E-Business Suite target, as described in Connecting to Oracle E-Business Suite.
  2. In the left pane, expand the target node.

    Interface table metadata is located under the Database node.

  3. Expand Database, then the Services node, and then select a table that contains the metadata you want to view, for example, WIPMove.

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

    When you select a specific table on the left, for example, WIP_MOVE_TXN_INTERFACE, the Detail, Data Elements, Request Schema, and Response Schema tabs appear on the right.

  4. Click the Data Elements tab.

    A detailed table appears on the right. The following image shows an example of an interface table that includes columns for the field name, the SQL data type, and for indicating whether the parameter is required.

    You can use this information to determine which tables and fields you want to use when creating an XML request document or iWay Business Service.

    For more information on supported interface tables, see Supported Interface Tables for Oracle Release Apps 11i.