Hi
What is the advantage of ‘export with universe’ option? If I have some custom LOV (like if I re-write LOV defenition and set option to do not generate query) if I choose option ‘Refresh before use’, can’t it create LOV dynamically?? I am little concern, what is the real purpose of ‘Export with Universe’ option??
You were provided good answers above but I wanted to add convenience. Say you have a large table with somewhat static values if you create the LOV in designer and export it with the Universe the user will see those values pop up almost instantaneuouly when they select show LOV; otherwise, each user will sit through a select distinct the first time they try to see the values. Depending on the size of the table this can be somewhat painful.
I know, I know, we try and avoid creating any LOV’s based on any large/detail level table but in reality this does happen and taking the initial hit when building the object adds a little convenience for the user.
There is another alternative to this “painful” procedure – and that is, that a small dimension table could be used as the source of such an object – and the LOV could be more quickly refreshed.