Bookshelf Home | Contents | Index | PDF |
Siebel Global Deployment Guide > Deploying Siebel CRM with Global Time Zone > Converting Historical Data to UTC > About the UTC Conversion UtilityThis topic is part of Converting Historical Data to UTC. To update existing date and time data in your data tables to UTC, you need to run the UTC conversion utility from the Database Configuration Wizard, as described in Running the UTC Conversion Utility. This utility helps you define the required parameters for UTC conversion. After conversion is complete, the UTC conversion utility sets the Universal Time Coordinated system preference to True. (When you start the utility, the setting can be either True or False.) Running the UTC conversion utility reads a series of input files that control the conversion of your date-time data to UTC. Several input files are provided by default. On the Siebel Server computer or operating system instance where you installed the Database Configuration Utilities, these input files are located in the directory The file driver_utc.ucf identifies the UTC conversion input files, which contain parameters specifying the columns that you are converting to UTC. Each of these input files updates the appropriate database columns to the UTC format in a single database transaction. Each input file entry contains the table name, a WHERE clause, and a list of columns with their conversion methods. The conversion method defines how to link each record to the user record from which the default time zone is derived. The value specified as the conversion method corresponds to a column whose value identifies a unique user record. NOTE: It is recommended to modify the default input files, or to create additional input files, to specify all of the applicable date-time columns to be converted, and to specify the most suitable conversion method for each column. The conversion methods are explained later in this topic. Each input file entry is structured as follows: [
Conversion Methods Used by the UTC Conversion UtilityThe UTC conversion utility uses the following conversion methods:
|
Siebel Global Deployment Guide | Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |