Using Siebel Tools > Managing Repositories > Viewing, Renaming, Comparing, and Configuring Repositories >

Configuring Siebel CRM to Read Data from a Single Repository

The example in this topic describes how to configure Siebel CRM to read data from a single repository when the Siebel database contains multiple repositories.

To configure Siebel CRM to read data from a single repository

1. Log in to the Siebel client with administrative privileges, and complete the following steps:
   1. Navigate to the Administration - Order Management screen, and then the Message Types view.
   2. Navigate to the Payload view, and then create a new record.
   3. In the new record, access the drop-down list for the Response Field.

      If the Response Field drop-down list:

      • Does not display duplicate values. The Siebel database does not contain multiple repositories, and you can exit this task.
      • Displays duplicate values. The Siebel database contains multiple repositories, and you must configure Siebel CRM to read data only from a single repository. Continue to Step 2.
   4. Delete the new record that you created.
2. Configure Siebel CRM to read data only from a single repository:
   1. Log in to Siebel Tools.
   2. In the Object Explorer, click Pick List.
   3. In the Pick Lists list, query the Name property for the following value:

   UMS PickList Response Field

   4. Modify the Search Specification property using the value from the following table.

      Property	Value
      Search Specification	[Buscomp] = 'UMS Response' and [Repository Id] = RepositoryId()

      Siebel CRM displays the UMS Type Variables List Applet in Step 2. This applet references the UMS Type Variable business component. It displays the Response Field Name field and uses the UMS PickList Response Field picklist for this field. This picklist uses the following search specification when it references the UMS Pick List Field business component:

   [Buscomp] = 'UMS Response'

   The UMS Pick List Field business component references the S_FIELD table. It does not include a search specification, so Siebel CRM does not filter the records that it gets according to the specifications that the repository contains. If the Siebel database contains multiple repositories, then Siebel CRM gets all the field names from all repositories, and then displays them in the picklist. This configuration might result in Siebel CRM displaying duplicate values that you cannot choose in the picklist. To correct this situation, you create a search specification that configures Siebel CRM to read data only from the current repository.

3. Compile your modifications.
4. Repeat Step 1 to make sure the Response Field drop-down list does not display duplicate values.