Siebel Connector for Oracle Applications > System Administrator Procedures > Monitoring Integrations >

Monitoring Inbound Integrations

The Siebel Administrator can monitor any inbound integrations from Oracle Applications to Siebel Applications.

The Oracle Receiver Server Task performs the Inbound integration. Because the Task is driven by the Siebel Notification Table (SIE_NOTIFY_TBL), you can monitor the integration by running a SQL query against the Notification Table.

For example, the following query will yield a list of current entries in the Notification Table:

select seq_num, status, type, object_name, tbl_name, PRI_KEY1, PRI_KEY2, original_system_reference, operation

from sie_notify_tbl order by seq_num;

For a high level overview, the following query will yield a summary of the entries in the Notification Table:

select object_name, tbl_name, status, count(*) from sie_notify_tbl

group by object_name, tbl_name, status;

Entries waiting to be processed have STATUS='NEW'. When a notification entry is successfully completed, the entry is removed from the Notification Table.

If an error occurs while an entry or set of entries is processing, the entries are marked with STATUS='ERROR'. In this case, the Oracle Administrator can read the Oracle Receiver Task Log to learn why the process failed. Indicative trace files can be found in the log directory of the Siebel Server installation.