Message Schemas for the Notification Operation

The Microsoft BizTalk Adapter for Oracle E-Business Suitesurfaces the Notification operation to receive database change notifications from the underlying database in Oracle E-Business Suite.

You configure the Notification operation by setting binding properties in the Oracle E-Business adapter. For more information about the Notification-related binding properties, see Read about the BizTalk Adapter for Oracle E-Business Suite binding properties. You set the NotificationStatement binding property to specify a SELECT statement for the query notification.

Message Structure for the Notification Operation

The following table shows the XML message structure for the Notification operation.

Operation XML Message Description
Notification <?xml version="1.0" encoding="utf-8" ?> <Notification xmlns="http://schemas.microsoft.com/OracleEBS/2008/05/Notification"> <Info>Value</Info> <Source>Value</Source> <Type>Value</Type> </Notification> This is the inbound message that is sent by Oracle E-Business Suite to the adapter clients. In the message:

- The <Info> tag indicates the reason for the notification. For example, an “insert” value in this tag indicates that data has been inserted in one or more of the tables referenced in the notification statement.

- The <Source> tag indicates the source for the notification. For example, a “data” value in this tag indicates a change in the data in a referenced object. Similarly, an “object” value in this tag indicates a change in a referenced object.

- The <Type> tag indicates the type of data change. For example, an “Update” value in the <Type> tag indicates that the results of the query have been updated.

Message Action for the Notification Operation

The message action for the notification operation is “Notification.”

See Also

Messages and Message Schemas for BizTalk Adapter for Oracle E-Business Suite