Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Database Upgrade Guide > Postupgrade Tasks for Siebel Business Applications > Generating Siebel Reporting RelationshipsEnvironments: Development, production test, production. Platforms: Windows, UNIX, IBM z/OS. 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 might 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 © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |