Transaction validation after INSERT

Previous Next

When an inserted record is committed, the Rules Engine performs the following checks:

1.All mandatory Foreign Keys must have been entered.
2.Corrective, non-transitional constraints that have been set to Deferred, are evaluated.
3.Parent records and eventual subtype records of these parent records are locked.
4.Foreign keys are checked.
5.For subtypes, if the totality and exclusivity rules of subtype sets have been set to Deferred, these checks are performed now.
6.Checks on Relationships are performed:

Must this parent record have children?

The number of children must be between the minimum and maximum allowed, if specified.

7.Restrictive, non-transitional, multi-record constraints are evaluated.
8.Cardinality checks for relationships in which this record is a child record are executed.