Last time I said that I will be presenting a Solution to make Required Fields dynamic and SRF independent. So I am back with What I promised.
Requirement:
Siebel Service Request module was to be implemented because of a new implementation the business requirements were being changed all the time. One Strange requirement was to make the Required Fields of a business component dynamic. So that they can be changed without a release. Now, we all know one way to make a field required is to set the Required Property of the field to true. But that would mean that if I were to change that a new SRF deployment will be required.
Solution:
LOV’s again were the life saver for us. We created an LOV called SRV_REQ_FIELD and in the Display value we provided the names of the fields that we wanted as Required Fields. In the Business Component PreWrite Record we queried for that particular LOV and traversed through the records that were active. If the Field provided in the LOV did not contained a value then an error was raise stating that the value for that particular required field was not supplied. I am giving the Pseudo Code below to what that script might look like
BOLOV = TheApplication().GetBusObject(”List Of Values”);
BCLOV = BOLOV.GetBusComp(”List Of Values”);
with (BCLOV)
{
Query for LOV Type as ‘SR_REQ_FIELD’ and Active Flag = ‘Y’
}
IsRecord = BCLOV.FirstRecord();
while( Last record is not reached)
{
this.ActivateField(BCLOV.GetFieldValue(”Name”));
if ( this.GetFieldValue(BCLOV.GetFieldValue(”Name”)) == “” )
Raise Errro Text (”Value not given”)
BCLOV.NextRecord();
}
This solution is not recommended if the number of fields that are required is fairly large. But still can be really handy in many situations.
Hope you liked this post! If yes, Do post your comments.

7 Comments at "Siebel List of Values - A Strategic Move - Continued."
Hi Neelmani,
I am not convinced with what you did as you can always use user propety “Required” to make your functionality dynamic.
Pls throw some light on this!!!!
Namrata
hi,
I believe the post talks about changing the “Required Field” functionality dynamically with out an SRF change.
User property “Required” is always handy…but if functionality changes are expected after deployment then..LOV approach is supposedly a easier and smart option.
Yes, M that is exactly what I am talking about.
If we want to change the required field without SRF release then we can go for this option
hi ,
Got ur point!
NS
[...] I have already explained one approach in the Post to make Required field SRF Independent using LOV’s and [...]
hi i need this solution very urgently , can some one suggest me pls
Hi ,
I am giving an example to update name and val for a specific lov type:
update s_lst_of_val set name = ‘gk’ , VAL = ‘gk’ where type = ‘ABS_COST_FCT_AREA’ and name = ‘xxx’
If you need to update many rows then copy above in excel and make changes accordingly and run in sql plus. At the same time multiple rows can be updated.
Thanks,
Kaushik
Comment Now!