You can use iWay Explorer to:

• Establish a connection to Oracle E-Business Suite.
• View metadata that describes Oracle interface tables or custom interface tables. You can use this metadata when you create request documents and when you develop logic for processing response documents.
• Search for stored procedures under a package.
• Interact directly with Oracle base tables and views. This integration method is most appropriate when you need to query data located in Oracle base tables and views.
• Generate XML schemas that define request and response documents for Oracle interface tables or custom interface tables, stored procedures under a package, or base tables and views. You can use these schemas when you create request documents and when you develop logic for processing response documents.
• Create business services (also known as web services) for your interface tables, stored procedures under a package, or base tables and views.
• Create iterative batch processes.
• Create parameterized SQL statements.