Bookshelf Home | Contents | Index | PDF |
Siebel Database Upgrade Guide > Postupgrade Tasks for Siebel Applications > Generating Siebel Reporting RelationshipsUpgrades from: All Supported Siebel releases. Environments: Development, production test, production. Platforms: Windows, UNIX, IBM z/OS. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. 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). Tables can become out of sync in the following cases:
There are three visibility hierarchies—position, organization, and access groups. These hierarchies are denormalized and maintained in the table S_PARTY_RPT_REL. These denormalized hierarchies are necessary for executing visibility modes that go up or down a hierarchy. For example:
The Generate Reporting Relationships process rebuilds the denormalized relationships in the S_PARTY_RPT_REL table so that the hierarchical view modes display the correct information. The basic operation of the function is to empty the S_PARTY_RPT_REL table and then walk through each S_PARTY record to re-create the denormalized hierarchical structures in the table. This process generates a large number of transactions for Siebel Remote users and regional nodes. This operation is time and CPU/memory-intensive. The process may take several minutes, depending on the size and complexity of your organizational structures. Do not perform this when you are running other memory-intensive processes. To generate reporting relationships
|
Siebel Database Upgrade Guide | Copyright © 2008, Oracle. All rights reserved. | |