List of values too long

[nalmond]

I need to query an accounts payables universe with a long list of purchase order numbers, approx 550 POs. The list is stored in a spreadsheet and when I create a LOV using it Bobj reports that the list is too long. Is there any way around this?

 

[VinayP]

One way is to create multiple conditions for the same PO object and split the Lov values to each condition using OR.
If you are using ALL the po's there is another way to do that.
Checkout in this forum

http://www.forumtopics.com/busobj/viewtopic.php?t=15384&highlight=prompts

if you are interested.
Vinay

 

[nalmond]

Cheers Vinay,

Any idea what the LOV limit is on a condition?

 

[VinayP]

I think ~250 values is the limit. Document says this can be customized by modifying the max_inlist_values in the .prm file.

 

[skrandel]

The default is 99 unless you update the PRM file. The max is 250.

In V6, there is a cool new feature, where you can use 1 data provider as input to another. I have just tested this, you can have as many values as you want in this mode.

Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group

http://www.knightsbridge.com

 

[nalmond]

Steve,

Thanks for the info. We're using v5.1.6 so it looks as though I'll be using multiple conditions for now. Fingers crossed for an upgrade to version 6!