Source Table

If loop detection is enabled, the ADB_SOURCE and ADB_TRACKINGID columns are added to the source table.

If the source table contains the ADB_TRACKINGID field, the source table is updated using the tracking ID of the message. If the ADB_TRACKINGID field is not present, the tracking ID is ignored.

The following table lists and describes the additional columns of the source table:

Column Name	Type	Description
ADB_SOURCE	CHAR	Used for loop detection. Indicates whether the row is inserted or updated as a result of a TIBCO Rendezvous message, rather than user intervention. The valid values are T or NULL: T indicates that the row is not to be published. NULL indicates the row can be published.
ADB_TRACKINGID	VARCHAR2 (40)	Tracking ID of the message.

The source table cannot contain any user-created columns where the column name starts with ADB_. These characters are reserved for adapter use.