Upgrade Planning for Siebel String Translation

Platforms: Windows, UNIX, IBM z/OS.

Based on the language for the Siebel upgrade process, the Siebel upgrade scripts are created accordingly.

Note: To avoid unintended results, you must perform your upgrade in the same language as that of the base language in the prior release.

When the Database Configuration Wizard is started, the sqlgen utility generates the Siebel upgrade scripts based on the information located in the upgfile.xml file. When the Database Configuration Wizard completes, SQL scripts are generated, and replace the placeholders in the upgfile.xml with the language-specific values located in the DBSRVR_ROOT/lang_code/upglocale.lang_code file.

In the following example, the locale file is upglocale.fra, for a FRA based installation. The upgfile.xml contains the following statement:

update S_DOC_QUOTE

Set the QUOTE_SUB_TYPE_CD value to &apos;<XTL_STRING>Private</XTL_STRING>&apos;

Where the QUOTE_TYPE equals &apos;<XTL_STRING>Template</XTL_STRING>&apos;

The placeholders <XTL_STRING>Private</XTL_STRING> and <XTL_STRING>Template</XTL_STRING> are values that the sqlgen utility changes during the upgrade. The XTL_STRING values are replaced based on what the sqlgen utility locates as a match for the Private and Template strings in the upglocale.fra file, located under dbsrvr/FRA. For this example, the FRA base language dictates Template = Modèle and Private = Privé.

Caution: If you modified string mappings in your previous Siebel release, then you must contact your Oracle sales representative for Oracle Advanced Customer Services to request assistance from Oracle’s Application Expert Services in order to modify standard upgrade scripts accordingly. If you do not, then your Siebel application data from the prior release might not be migrated to the new Siebel release’s data model.