This content has been marked as final. Show 3 replies
1004571 wrote:The class file exist in 11i -- $JAVA_TOP/oracle/apps/bne/integrator/document/macro/msoffice/excel/BneVBALayoutColumn.class
I created custom Integrator and trying to attach a POPLIST LOV but only few first values are retrieved in.
I found on my oracle support the note: Standard Type LOV Limits To 256 Char For WEB ADI [ID 1540715.1]
This note show the following restriction Version 12.1.2, but I didn't find the BneVBALayout.java on 126.96.36.199:
It is defined per code restriction maximum 255 values for a PopLOV:You can't increase the value as per (Bug 15881538 : RESTRICT POPLIST VALUE NUMBER TO BE NO MORE THAN 255, BUT NOT DESCRIBED IN DOC) -- Pop list is for no more than 255 values inside. If value more than 255, please use Standard LOV
java/integrator/document/macro/msoffice/excel/BneVBALayout.java vers. 120.11.12010000.16
618 int maxPopVals = 255;
620 //Restricting the size of the pop list values to the maxPopVals value
621 //Argue that an integrator developer should not create a poplist with a large number of values
How can't I increase number of poplist values?
Thanks for your answer, I'd like to retrieve more than 100 000 results in the list, so I'll use standard List.
Do you know how to create it?
I used thread "Drop-Down (LOV) in Web ADI" to use the R12 API package function CREATE_TABLE_LOV in our 11i instance but doen't completelly work.In fact ont the spreadsheet, when click in the fiel, the list appears with all recaords but with blank results.
Edited by: 1004571 on 3 juin 2013 07:35
Is Somebody known how to create table LOV in 11i?