Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• Oracle Applications Overview
• Oracle Applications Adapter Overview
• Hardware Requirements
• Software Requirements

2 Installation and Configuration

• Installing the OA Adapter
• Preinstallation Tasks
• Installation Tasks
• Installing Multiple OA Adapters in the Same Oracle Home
• Configuring the OA Adapter
• OA Adapter Ini File Settings
• hub.ini Parameters
• adapter.ini Parameters

3 Design-Time and Run-Time Concepts

• OA Adapter Design-Time Concepts
• Designing with iStudio
• OA Adapter Run-Time Concepts
• How the OA Adapter Works
• OA Receiver
• OA Sender
• Starting the OA Adapter
• Log File of OA Adapter
• Stopping the OA Adapter

4 Sample Use Cases

• Sample Use Cases for Tables/Views/APIs
• Case One: Publish and Subscribe
• Design-Time Steps
• Case Two: Invoke and Implement
• Design-Time Steps
• Run-Time Steps
• Sample Use Cases for XML Gateway
• Case One: Publish and Subscribe
• Design-Time Steps
• Case Two: Invoke and Implement
• Design-Time Steps
• Customizing XML Gateway Payload Structures

A Frequently Asked Questions

• General
• What should I enter on the Database User Configuration dialog box during installation?
• Is it possible to edit the database configuration settings created during installation?
• How can I specify a listener port other than 1521?
• How do I secure my passwords?
• Design-Time
• Where is the PL/SQL code exported through iStudio saved?
• What is the Returned IN Args feature in iStudio and how do I use it?
• How do I export stored procedures to use with the OA adapter?
• Can OA messages contain arrays of arrays?
• Run Time
• When I run start, I do not see anything happening: no log files are created and I do not see any messages in the console: how do I get back to the command prompt?
• Why is the OA adapter using old information after I changed information in iStudio?
• How do I find a table or a view or an API under a certain module in the Oracle Applications Browser whereas I know the object is owned by that Oracle Applications module?
• Why do I get errors when trying to load PL/SQL code generated through iStudio?
• What are the steps to prepare a OA adapter that publishes events?
• What are the steps to prepare a OA adapter that invokes procedures?
• What are the steps to prepare a OA adapter that subscribes to events?
• What are the steps to prepare a OA adapter that implements procedures?
• What is the consumer name?
• How do I handle ANY tags in DTDs imported into iStudio?
• My OA adapter is not starting. What could be the reason?

Index