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. NOTE: The paragraphs that follow provide a generalized description of how seed data for U.S. English (ENU) is imported during the upgrade process, including whether existing data is replaced. This description does not apply to all types of seed data, including seed data for non-ENU languages. The ROW_ID value for ENU 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 column stores the date when the record was last updated. If you modify an ENU 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 value 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 ENU seed data records as follows:
For ENU 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, then you must, before executing the UPDATE statements on the S_LST_OF_VAL table, make sure to reactivate the corresponding standard Siebel LOVs 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 value beginning with 0, but the LAST_UPD value will no longer be 1980-01-01. For more information, see Running the Siebel Database Configuration Wizard on Windows or Running the Siebel Database Configuration Wizard on UNIX. Discarding Seed Data ModificationsUse the following procedure to discard seed data modifications. To discard seed data modifications
Related Topics |
Siebel Database Upgrade Guide | Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |