Adapter Notifications

An adapter notification enables Oracle Apps Adapter to retrieve data from an Oracle Applications system at regular intervals and publish a document. The notification retrieves the data based on query conditions specified in either an SQL Tree or a stored procedure.

You must create a trigger on the Integration Server for the publishable document associated with the notification. This trigger identifies the receiver of the published document. For more information about creating triggers and working with publishable documents, see the Publish-Subscribe Developer’s Guide for your release.

Note:
Adapter notifications do not use Acknowledge services. Without an Acknowledge service you may not be able to guarantee that the Oracle Applications event is only retrieved once. If you need to guarantee that the Oracle Applications event is retrieved only once, you should create the notification using a stored procedure, and that stored procedure should update the record in Oracle Applications to indicate that it is being processed.

Any exception produced by the notification is logged in the Integration Server Error Audit Log.

Use Designer to configure, edit, and delete polling notifications. All notifications are configured from a notification template and require a configured connection.

Beginning with Integration Server 8.0, you can choose whether the asynchronous notification templates use JMS APIs to publish messages to Integration Server or webMethods Broker APIs to publish notification messages to webMethods Broker. For more information, see Adapter Notifications.

Note:
To use the JMS protocol with both polling and listener asynchronous notifications, you must first configure a JMS connection alias on Integration Server. For more information about configuring Integration Server for JMS messaging, see the webMethods Integration Server Administrator’s Guide for your release.

Using Integration Server Administrator you can display all polling notifications that have been configured for Oracle Apps Adapter. You can also enable notifications and schedule them for execution. A notification can also be disabled; however, this is separate from the containing Integration Server package being disabled. If the Integration Server package is disabled, the notification is suspended, but the notification is not disabled. When the package containing the notification is enabled, the scheduled execution resumes. If the notification is disabled it will not be executed until it is enabled.