Running the Case Insensitivity Wizard Using an Input File

Oracle provides a recommended input file for Siebel Business Applications and for Siebel Industry Applications. The input files have a .csv extension and are located in the following directory:

Windows: $SIEBEL_HOME\objects

These files list columns that are frequently used for queries and are provided as a recommendation. You can edit these files or create new input files as desired.

Requirements: See About the Siebel Case Insensitivity Wizard for information on how the Case Insensitivity Wizard works, eligibility criteria, and how to edit input files.

To run the Case Insensitivity Wizard using an input file

1. Review the input file and verify the following:

   • The syntax for all records is correct.

   • The tables and columns are eligible.

   • The specified configuration options are correct.

   • The configuration defaults are acceptable if any configuration options are omitted.

2. In Siebel Tools, open the repository.

3. Lock the tables listed in the input file.

4. From the Tools menu, choose Utilities, then Case Insensitivity.

   The Case Insensitivity Wizard displays.

5. Select "Administer the columns listed in this file".

6. Click Browse.

   The $SIEBEL_HOME\objects directory displays, containing the default .csv input files.

7. Select the desired .csv file, and click Open.

8. In the wizard, click Next.

   The Case Insensitivity Wizard validates the syntax of the file and validates the eligibility of all tables and columns. If the file contains errors or eligibility problems, then the wizard lists the records containing errors. If you continue, then the wizard skips records containing errors or eligibility problems.

   If there are errors, then export the listing to a file, correct any errors in the input file, and restart the Case Insensitivity Wizard. Click Export to export the error listing to a text file.

   If there are no errors, then click Next.

   The Wizard displays the records in the input file.

9. Review the configuration settings, and verify that they are correct.

10. If you want to change any configuration settings, then click Export.

    The Wizard exports the listing to a text file in input-file format.

11. Edit the text file, restart the Case Insensitivity Wizard, and specify the edited text file as the input file.

12. If the configuration settings are correct, then click Next.

    The Wizard displays the changes it will make to repository tables and indexes.

13. If you want to save a record of the changes, then click Export.

    The Wizard writes the changes to a text file.

14. Click Finish.

    The Wizard configures the columns in the repository to support CIAI queries.