"SOUNDSLIKE" operator in siebel


Requirement:

End users use different spellings when they write down the names of Contacts. In our case, it’s really difficult to find the duplicate Contacts that are created with different Spellings. For Example, Tracey can also be spelled as Tracy , Traecey, etc. 

Solution:
In order to find the records that are duplicate, we can use SOUNDSLIKE operator in Siebel. Before creating a contact we can use the Soundslike operator to check whether the desired contact is already existing in the application or not and then we can continue further.

Below Screenshot depicts the usage:

Output generated after using the operator :
 
 Siebel maps the SOUNDSLIKE operator to the SOUNDEX function at the database level and the same can be viewed by performing a spool.

Comments

Popular posts from this blog

Refresh Siebel Applet not Buscomp - "RefreshBusComp" Alternative

BCHasRows - Validation with no scripts

Deploying Integration Object at Runtime (Siebel)