Using the Siebel Tools Version 8.0, Columns can be configured for CIAI, by easy to use Case Insensitivity UI wizard. This helps application users to query records irrespective of any case (Upper/Lower). E.g. to enable CIAI on column LAST_NAME of table S_CONTACT, follow the steps mentioned below.
 
Configuration:
 
·         Log in to Siebel Tools
 
·         In OE Select Table for S_CONTACT
 
·         In OE Select Column and Query the LAST_NAME Column
 
·         In the OBLE Right click the column and click on Case Insensitivity
 
·         CIAI wizard appears
 
·         Click Next and Finish on the Screen
 
·          In Table OBLE Apply and Activate the changes made
 
·         Compile the client srf
 
 
 
Steps to Test:
 
·         Login to the application
 
·         Go to Contact Screen
 
·         Create 7 to 10 records of the same name of different cases under the Last Name field
 
·         Query for any one of the created record on same field
 
·         It returns all the created records irrespective of the case