Validate multiple mandatory fields

Hello Siebel Community,

We are looking for an optimized solution for one of our business needs. The aim is to validate a Service Request, by checking if all mandatory fields are set by the user.

We have a matrix, with 3 hierarchical fields :

     For each [Field i, Field j, Field k] values, we have a set of mandatory Fields (from 5 to 15)

    

     We have a matrix with 300 occurences of [Field i, Field j, Field k]

Field 1	Field 2	Field 3	Mandatory 1	Mandatory 2	Mandatory 3	Mandatory 4
value i	value j	value k	N	Y	Y	N
value i	value j	value l	Y	Y	Y	Y