>But perhaps somebody out there knows if generators are "transaction safe"?

Generators are not subject to transaction control, so there is no guarantee
that using gen_id(Partner_id, 1) will yield two consecutive numbers when
issued twice within a trigger. Rather than using gen_id twice, use it once
assigning it to a variable and then use this variable when inserting into
tables/views.

Set