1. Enterprise Integration Manager Administration Guide
  2. Activating Position Hierarchy

Activating Position Hierarchy

After importing or merging positions using EIM, or after merging positions through the user interface, it is necessary to generate reporting relationships to populate or rebuild the S_PARTY_RPT_REL. This happens automatically when you insert positions using the user interface.

The Generate Reporting Relationships process needs to be executed after the upgrade process and whenever the denormalized hierarchy structure (S_PARTY_RPT_REL) becomes out of sync with the data in the normalized tables (S_PARTY). As noted in Siebel Database Upgrade Guide, tables can become out of sync in the following cases:

  • After upgrading, the organizational hierarchy (even if there is only one organization) must be established to maintain appropriate visibility in the views.

  • When Siebel Enterprise Integration Manager is used to import or update any of the hierarchies (positions, organizations, or access groups).