Bookshelf Home | Contents | Index | PDF |
Siebel Database Upgrade Guide > Preparing Siebel Application Data for Upgrade > Preparing Siebel Customized Seed Data for UpgradeEnvironments: Development, production test, production. Platforms: Windows, UNIX, IBM z/OS. Modified seed data are not upgraded, even if the upgraded seed data are required for an application to run normally, with the following exceptions:
Before starting the upgrade, evaluate whether you must retain your seed data modifications. If practical, consider discarding the modifications. After the upgrade, you can reimplement those modifications that do not interfere with operation of applications. Seed data are records provided in the Siebel database tables as part of a Release. Seed data provides information needed to run a Siebel application. Examples of seed data are the values in a List of Values (LOV) definition, default mappings of views to responsibilities, and predefined queries. The ROW_ID value for seed data records provided in a Release begins with 0 (zero). In addition, these records have a default LAST_UPD value of 1980_01_01. The LAST_UPD field stores the date when the record was last updated. If you modify a seed data record, then the value of LAST_UPD is changed from 1980_01_01 to the date the modification was made. If you add a new seed data record, then the ROW_ID does not begin with 0, and the LAST_UPD value is the record creation date. When you perform the upgrep part of the upgrade, the dataimp utility upgrades seed data records as follows:
For seed data records you have modified, you can discard the modifications by changing the value of LAST_UPD to 1980-01-01. This causes dataimp to replace these records with those from the new Release. For seed data records you have created, the upgrade process retains these records. About Deactivated LOVsIf you deactivated any standard Siebel LOVs in your prior release you must, before executing the UPDATE statements on the S_LST_OF_VAL table, make sure to reactivate the corresponding standard Siebel LOV through the prior release's UI. Standard Siebel LOVs that were manually deactivated through the Siebel UI (by changing the Active value to N) will have a ROW_ID beginning with 0, but the LAST_UPD field will no longer be set at 1980_01_01. For more information, see Running the Siebel Database Configuration Wizard Under Windows, or Running the Siebel Database Configuration Wizard Under UNIX. To discard seed data modifications
Related Topics |
Siebel Database Upgrade Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |