Friday 28 March 2014

Increase Display value size for an LOV

Maybe you have created a static picklist in siebel and picklist may be using an LOV for which you have may defined values in the Application. What if you have lengthy LOV value to display? Suppose you have a picklist field reason and this field uses a picklist of type XXXXX and the LOV needs to show a list of values ranging from 30-40. Normally what we do is we create list of values in the application and the for the field reason you create a pick map and in the pick map you specify the field to be reason and the picklist field to be value. The picklist field value hold the Display value and using the pick map a copy operation is done whereby the value from the picklist field is copied to the BC field. Unfortunately we have a limitation and that is the value(Display Value) field in the picklist can store only upto 30 characters and if the the value that we need to store exceeds 30 characters then siebel will store the first 30 characters and the rest is truncated. My reserch ended up in aconclusion that we cannot extennd the size of the value field however i came across a workaround.

Instead of using the Display Value we can use the Description field which has a length of 250. You can enter the values in the description field and then use it to construct the pick map. This time for picklist field reason i have modified the pick map and the picklist field in the pick map was updated to Description. That helped me resolve my requirement.

1 comment:

  1. The above solution will not work in a multilingual implementation. The value selected in the dropdown for one language, will remain the same in another.

    ReplyDelete