Skip Headers
Oracle® Application Server Integration InterConnect Adapter for Oracle Applications Installation and User's Guide
10g Release 2 (10.1.2)
B14360-02
  Go To Documentation Library
Home
Go To Product List
Solution Area
Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
Next
Next
 

3 Design-Time and Run-Time Concepts

This chapter describes the design-time and run-time concepts for the OA adapter. It contains the following topics:

OA Adapter Design-Time Concepts

The OA adapter acts as a highly flexible integration interface to the Oracle Applications. This section describes the design-time aspects of the OA adapter. The OA adapter provides the following interfaces to integrate with the Oracle Applications:

Designing with iStudio

OA adapter supports both the publish/subscribe and request/reply messaging paradigms. To create the message definitions, you must invoke the required wizards. For example, to create a publish event, you must use the Publish wizard, as described in the following steps:

  1. In the Design Navigation list, expand the Application node.

  2. Right-click Published Events and select New. The Publish Wizard is displayed.

    Description of 1.gif follows
    Description of the illustration 1.gif

  3. Enter following information in the fields:

    • Application: The name of the invoking application is selected by default.

    • Message Type: The mode of communication between OracleAS Integration InterConnect and the application. Select the Oracle Applications message type.

  4. Select the event name.

  5. Click Next. The Select Interface Type dialog box is displayed.

  6. Select the type of interface from which the definition is to be imported. The interface types are:

    • Tables/Views/APIs

    • XML Gateway

    • Workflow Business Event System

    • Custom Queue

    Description of 2.gif follows
    Description of the illustration 2.gif

  7. Click Next. The Define Application View dialog box is displayed.

    Description of 3.gif follows
    Description of the illustration 3.gif

    Once an event is selected to publish, the application view is defined. The application view dialog box is initially an empty table.

  8. Click Import to import the definitions. A list of Import options are displayed.

    Description of 4.gif follows
    Description of the illustration 4.gif

    Depending on the option selected in Step 6, the import menu options vary, as displayed in Table 3-1.

    Table 3-1 Import Menu Options

    If you had selected... Import Menu Options are...

    Tables/Views/APIs

    Common View, Application Data Type, Common Data Type, Tables/Views/APIs

    XML Gateway

    Application Data Type, Common Data Type, XML Gateway, XML

    Workflow Business Event System

    Application Data Type, Common Data Type, Tables/Views/APIs, XML

    Custom Queue

    Common View, Application Data Type, Common Data Type, Tables/Views/APIs, XML


    If you select Common View, Application Data Type, or Common Data Type, then the steps to be followed are identical to those explained in the Oracle Application Server Integration InterConnect User's Guide.

    If you select the XML option from the Import Menu, then go to Step 11.

    If you select Tables/Views/APIs, then the Oracle Applications Login dialog box is displayed as shown in Step 9.

  9. Enter information in the following fields:

    • User Name: The database log in name. By default, the user name for the application schema of the Oracle Applications is apps.

    • Password: The database log in password.

    • URL: The computer name: port number: database SID.

    • Driver: The JDBC driver used to connect to the database.

    • Save settings as default: Select this check box to save the settings for the workspace.

    Description of 5.gif follows
    Description of the illustration 5.gif

  10. Click Login. The Oracle Applications Browser is displayed.

    Description of newtree.gif follows
    Description of the illustration newtree.gif

    The browser displays the list of installed modules. You can use the following approaches to find the desired object:

    • Browse Modules: Browse through the list of modules displayed, and select the desired object. The attributes of the selected object are displayed on the right pane of the Browser. Select the desired attributes, and click Apply. The Define Application View dialog box is displayed with the selected attributes. Go to Step 14 to continue.


      Note:

      For PL/SQL APIs, the browse mode only displays the PL/SQL packages that start with the module short name.

      For example, if the Oracle Receivables module has the short name "AR", then AR_package name packages only will be displayed under this module. If the Oracle Receivables module has RA_package name and HZ_package name packages also, then these will not be displayed under this module.

      For all other PL/SQL packages that logically belong to a module but do not show up where expected, use the search functionality.


    • Search Object: Use the search facility to search for the desired object in the Oracle Applications schema. Enter the object name in the Object Name field, and select the required object types (Tables, Views, APIs, ADTs).

      Description of 6.gif follows
      Description of the illustration 6.gif

      If you are not sure of the complete name of the desired object, then you can enter the entire object name that you are looking for or use the wild card '%', for example, AMV_STOCK%. You must select at least one of the database object types listed at the top of the dialog box to enable the Search button.

      Click Search to display the list of matching object names. Select the desired object, the attributes of the selected object are displayed on the right pane of the Browser. Select the desired attributes, and click Apply. The Define Application View dialog box is displayed with the selected attributes. Go to Step 14 to continue.


      Note:

      To return from the Search option to the Browse option, click the Browse button.

    If you have selected XML Gateway in Step 6, then the XML Gateway Browser is displayed. In the Browser, the left pane displays a list of DTDs and the right pane displays the details of the DTD such as its root element, file name, version, description, and payload. Also, the payload details of the selected DTD are displayed, as shown in the following figure. Select a DTD, and click Apply. The Define Application View dialog box is displayed with the selected attributes. Go to Step 14 to continue.

    Description of 7.gif follows
    Description of the illustration 7.gif

  11. The Open dialog box is displayed. Select a DTD file, and click Open.

    Description of 8.gif follows
    Description of the illustration 8.gif

  12. The Choose Root Element dialog box is displayed. Select a root DTD element.

    Description of 9.gif follows
    Description of the illustration 9.gif

  13. Click OK. The Define Application View dialog box is displayed with the imported DTD.

  14. Click Next in the Define Application View page. The Define Mapping page is displayed. Mapping involves copying the individual fields or simple shape-change transformations.

    Description of 10.gif follows
    Description of the illustration 10.gif

  15. Click Define Mappings to define new mappings. The Mapping Parameters dialog box is displayed.

    Use a transformation to map fields in the application view to fields in the common view. For example, to map fields in the FirstName and LastName in the common view to Name in the application view, use the ExpandFields transform.

  16. Click OK to return to the Publish Event Wizard.

  17. Click Finish.

You have successfully created a publish event using iStudio, leveraging the OA adapter. The steps for the creation of subscribe events, as well as for invoking and implementing procedures, are similar to those described in the preceding steps.

OA Adapter Run-Time Concepts

This section describes the key run-time components of the OA adapter. You can choose one or more of the interface types to connect to a single Oracle Applications instance. The adapter is designed so that a single adapter instance can handle all the different interface types (inbound and outbound) for one application instance. You do not need to have dedicated adapters for each interface type.

How the OA Adapter Works

This section contains the following topics:

OA Receiver

On the subscribing/receiving side, the OA adapter receives the message from the hub, transforms it from common view to application view, and passes it to the bridge that

  • calls the required PL/SQL procedures to inform the application about the newly arrived message if the interface type is Tables/Views/APIs.

  • enqueues the message to the subscribe queue configured through the Deploy tab of iStudio if the message is for one of the queue interface types (XML Gateway, Custom Queue, and Workflow BES). The application should then pick this message from this queue.


Note:

The adapter subscribing to an event should be started before any other adapter can publish that event. If you publish an event before starting the subscribing adapter, then the event would not be delivered to the subscribing adapter.

OA Sender

The OA adapter is comprised of the bridge and the run-time agent. This bridge has two different modes of communication with the Oracle Applications instance:

  • Database Access: Interface Type: Tables/Views/APIs

    One part of the bridge component is constantly polling the MESSAGEOBJECTTABLE table in the oai schema, specified by the oa_bridge_schema_username parameter. A new row in this table indicates a new outbound OracleAS Integration InterConnect message waiting to be sent by this adapter. The adapter then picks up the message from the interface tables residing in the oai schema, builds the corresponding OracleAS Integration InterConnect message, persists it, transforms it to the common view, and routes it to the hub. From the hub, the message gets routed to the required subscriber based on configuration completed in iStudio, which can be content-based or subscription-based.

    The application and the OA adapter communicate in the form of direct database access through the interface tables residing in the oai schema for outbound messages and through iStudio PL/SQL generated procedures for inbound messages. Therefore, if the adapter is down while the application is publishing OracleAS Integration InterConnect messages using the iStudio generated PL/SQL procedures, the messages are held in the interface tables and will be picked up in a FIFO method by the OA adapter once it is up and running. If there are messages in the interface tables that no longer need to be published, then the DELETE FROM MESSAGEOBJECTTABLE using SQLPlus can be run in the oai schema.

  • Message Queues

    The second part of the OA adapter is constantly polling one or more queues (XML Gateway, Workflow BES, Custom Queue) selected for publishing messages in the apps schema. A new message in this queue indicates a new outbound OracleAS Integration InterConnect message waiting to be sent by the adapter. The adapter then picks up the message, builds the corresponding OracleAS Integration InterConnect message, persists it, transforms it to the common view, and routes it to the hub. From the hub, the message is routed to the required subscriber based on configuration done using iStudio, which could be content-based, or subscription-based.

    The application and the OA adapter communicate through the publishing and invoking queues, residing in the apps schema for outbound messages and through subscribing and implementing queues for inbound messages. Therefore, the OA adapter is down while the application is publishing OracleAS Integration InterConnect messages. These messages are held in the queues and will be picked up in the order they were enqueued by the OA adapter once it is up and running. If there are messages in the queues, which should no longer be published, dequeue them manually.

Starting the OA Adapter

Based on the operating system, the process for starting the adapter varies.

Log File of OA Adapter

You can verify the start up status by viewing the log.xml files. The files are located in the time-stamped subdirectory of the log directory of the OA adapter. Subdirectory names take the following form:

timestamp_in_milliseconds

The following is an example of the information about an OA adapter that started successfully:

The Adapter service is starting..
Registering your application (OAAPP)..
Initializing the Bridge oracle.oai.agent.adapter.ebusiness.EBSBridge..
Starting the Bridge oracle.oai.agent.adapter.ebusiness.EBSBridge..
oa_bridge_reader_1 has been started.
Service started successfully.
oa_bridge_writer_1 has connected to the database successfully.
oa_bridge_reader_1 has connected to the database successfully.

Stopping the OA Adapter

Based on the operating system, the process for stopping the adapter varies.