Generally we maintain our fields unique using User keys or creating of Index at Table level or else we move with the scripting, but we have simple solution with simple configuration. This post has been shared by Manjula Vani.
Solution follows… here
We have very good function in Siebel called “BCHasRows”.
Syntax: BCHasRows (BO, BC, search_expr, visibility)
Scenario: Maintain “PAN Card Number” as unique.
BCHasRows ("Account", "Account", "[PAN Card Number*] = '"+ [PAN Card Number*] +"'", "All")
The following 2 steps we need to do……
STEP1: Create Calculated Field
STEP2: Give the Calculated Filed in Validation property of the Filed for which we want to maintain uniqueness.