To avoid such problems, you must follow one of the following rules for using sequences with shared and group-configured tables:

  • Ensure that all related tables have the same group definitions, with the same tenants defined as members of a given group defined in each table.
  • Have grouping at higher levels of join but not at lower levels.
  • Generate all foreign keys used in group or shared tables from a shared sequence, guaranteeing that each tenant will generate a unique value.

The best practice while working with group or shared tables is to always use a shared sequence to generate any field values to be used as a foreign key.

For more information on managing sequences and multi-tenant tables with groups, see Managing access to tables with groups.