Trigger Polling Page

Polling Page

The following table describes the key information on the Polling page.

Element	Description
Import Tables	Imports tables and the root database table for the service query. A maximum of five tables can be imported.
Remove Tables	Removes the selected table from the service query tables list.
Review and Manage relationships reachable from the root database table.	Appears after importing tables. Select Edit to open the Relations page where you can view, create, and remove relationships between tables.
Review and verify the attributes created from the imported tables and relationships.	Appears after importing tables. Select Edit to open the Attributes Filtering page where you can review, verify, select or deselect the attributes in the object model created from the imported tables and the defined relationships.
Polling Strategy and Options	Appears after importing tables. Select Edit to open the Polling Strategy and Options page where you can define the polling strategy and specify polling options.

Manage Tables Page

The following table describes the key information on the Manage Tables page. The Manage Tables page appears when you select Import Tables on the Polling page.

Element	Description
Schema	Select the schema for the tables and views you are importing. Special characters (for example, `#`) are not supported in schema names. See Special Characters are Not Supported in Schema Names.
Table Type	The type of the table to which the schema or view is applied. The list allows these selections: All — selects all available tables and views. Materialized View — selects materialized views. Materialized View Log — selects materialized view logs. Synonym — selects the alias for the schema object. Table — selects tables. View — selects views.
Table Name	Specify the table name. Table names are case sensitive.
Search	Click to search for the specified table.
Available Tables	Lists the tables that meet the selection criteria.
Selected Tables	Lists your table selection.
Primary Keys	Appears when you select tables without a primary key defined. Selects the virtual primary key for the table. Note: Having the primary key at the database level is the best practice.

Relations Page

The following table describes the key information on the Relations page. The Relations page appears when you select Edit for the Review and Manage relationships reachable from the root database table option on the Polling page.

Element	Description
Create New	Opens the Create Relation page with these options: Parent Table — selects the parent table for the relationship between tables. Child Table — selects the child table for the relationship between tables. Relationship — defines the relationship between the parent and child tables. Attribute Name — Applies attributes to the table relationship. Mapping — Displays the mapping for the table relationship.
Detach	Opens the Relationships list in a new window.

Element

Description

Create New

Opens the Create Relation page with these options:

Parent Table — selects the parent table for the relationship between tables.
Child Table — selects the child table for the relationship between tables.
Relationship — defines the relationship between the parent and child tables.
Attribute Name — Applies attributes to the table relationship.
Mapping — Displays the mapping for the table relationship.

Detach

Opens the Relationships list in a new window.

Polling Strategy and Options Page

The following table describes the key information on the Polling Strategy and Options page. The Polling Strategy and Options page appears when you select Edit for Polling Strategy and Options on the Polling page.

Element	Description
Logical Delete Field	Selects a field in the root database table. To allow the selection, polling must be enabled in the Status column.
Read Value	Identifies the value that is used to indicate a row has been read. For example, PROCESSED. Surrounding quotes are not required.
Unread Value	Indicates the rows to process. Only rows with Logical Delete Field and column values that match the Unread Value are read.
Rejected Value	Set to REJECTED. If the incoming message is greater than the threshold size, that particular record is updated to REJECTED instead of READ. If the outbound operation returns a response greater than the size allowed, the response message is ignored and a fault response is sent to the calling client. For details about supported sizes, see Service Limits in Provisioning and Administering Oracle Integration 3.
Polling Frequency (Sec)	Specifies the polling frequency (in seconds) for new records or events.