Configuring Siebel Business Applications > Localizing Siebel Business Applications >

Converting Your Current Data for an MLOV

After you configure Siebel CRM to use an MLOV, you use the MLOV Converter Utility to convert data for the current lists of values. The MLOV Converter Utility does the following:

  • For each column configured for an MLOV, locates values in lists of values in user data that are not in the S_LST_OF_VAL table.
  • Inserts these values into the S_LST_OF_VAL table as inactive.
  • Changes the display value of bounded columns to the language-independent code and sets the value for the Multilingual property to true.

Note the following:

  • It is recommended that you backup the Siebel database before you run the utility. You cannot reverse or undo a conversion.
  • You must perform this conversion even if you recently completed a new installation of your Siebel application.
  • You can run the utility as often as necessary. The utility only processes data that is not already converted.

You run the MLOV Converter Utility in one of the following modes:

  • Validation. Validates the current repository for data inconsistencies. If the utility finds inconsistencies, then the utility writes errors to a log file and then stops.
  • Translation. Does the following:
    • If a column is configured for an MLOV, then the utility changes the display value for the column to the language-independent code.
    • If you set the target column for a LOV Type to multilingual, then to make sure the multilingual state of the target column and the corresponding list of values in the S_LST_OF_VAL table are consistent with each other, the utility sets the MULTILINGUAL flag to TRUE in the S_LST_OF_VAL table.

      The MLOV Converter Utility sets the multilingual flag to TRUE for the header row and the Display Value rows for the MLOV.

    • Verifies that target columns that use the MLOV type are configured. A target column is a column that stores the display value or the language-independent code as part of user data.

To convert your current data for an MLOV

  1. In Siebel Tools, delete all indexes that reference the columns you must convert.

    You will recreate these indexes after you finish the MLOV conversion.

  2. Start the Siebel Database Configuration Wizard.

    For information, see Siebel Installation Guide for Microsoft Windows. If you use UNIX, then see Siebel Installation Guide for UNIX.

  3. Define the required parameters.

    For more information, see Parameters You Use to Run the MLOV Converter Utility.

  4. Choose Run Database Utilities.
  5. Choose Multi-Lingual List of Value Conversion.
  6. Choose Validate Mode.
  7. Run the MLOV Converter Utility.
  8. Review the log file and resolve errors, as necessary.

    The MLOV Converter Utility checks for errors and writes them to a log file. The default name of the log file is mlovupgd_verify.log. The default location of the file is the siebsrvr\LOG directory.

  9. If the utility reports an error, then resume the utility in validation mode.

    For more information, see Resuming the MLOV Converter Utility If an Error Occurs.

  10. Repeat Step 2 through Step 9 until the utility does not report any errors.
  11. Repeat Step 2 through Step 5 to restart the Siebel Database Configuration Wizard.
  12. Specify Translation Mode, and then run the MLOV Converter Utility.
  13. Recreate the indexes you deleted in Step 1.
  14. Compile and test your changes.

    For more information, see Using Siebel Tools.

Parameters You Use to Run the MLOV Converter Utility

Table 73 describes the parameters you use to run the MLOV Converter Utility.

Table 73. Parameters You Use to Run the MLOV Converter Utility
Name of Dialog Box
Values You Must Choose

Siebel Enterprise Parameters: Gateway Name Server Address

Gateway Name Server Address

Enterprise Server Address

Installation and Configuration Parameters: Siebel Server Directory

Siebel Server Directory

Installation and Configuration Parameters: Siebel Database Server Directory

Database Server Directory

Database Server Options: Siebel Database Operation

Run Database Utilities

Database Utilities: Database Utility Selection

Multilingual List of Values Conversion

MLOV Parameters: MLOV Operation

Validate or Translate, depending on the mode you must run.

Installation and Configuration Parameters: Language Selection

Base language of your Siebel application.

Installation and Configuration Parameters: RDBMS Platform

RDBMS Platform

Installation and Configuration Parameters: OBDC Data Source Name

OBDC Data Source Name

Installation and Configuration Parameters: Database User Name

Database User Name

Database Password

Installation and Configuration Parameters: Table Owner

Table Owner Name

Table Owner Password

MLOV Parameters: Repository Name

Repository Name

Configuration Parameter Review

Review the parameters you defined and then click Finish.

Configuring Siebel Business Applications Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.