Resolution:
Description:
============
There is sometimes a request asking whether it is possible to add triggers to the TIBCO iProcess Engine (iPE) database tables. This may be, for example, to create a snapshot of information to run reports against.


Environment:
==========
All supported versions of  TIBCO iProcess Engine (Oracle).
All supported operating systems.


Resolution:
=========
Adding a trigger would not affect the customer support agreement but TIBCO has never encouraged customers to modify the data model.

Thorough testing should be performed but investigating any side-effects of the added triggers would not be undertaken by TIBCO Support.

Monitoring database performance and the effect of the trigger creation on the execution plans or run times for the iPE queries, which may actually increase as a result of the trigger execution, would be the customer's responsibility.

TIBCO Support may request the trigger be disabled to investigate any reported issues. If the iPE is upgraded, the trigger should be disabled prior to the upgrade.

TIBCO may change the structure of any table that may affect any trigger that has been added.