3 Replies Latest reply: Jun 3, 2013 9:32 AM by 1007574 RSS

    POPLIST LOV lengh limited 11.5.10.2

    1007574
      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 11.5.10.2:


      It is defined per code restriction maximum 255 values for a PopLOV:
      java/integrator/document/macro/msoffice/excel/BneVBALayout.java vers. 120.11.12010000.16
      618 int maxPopVals = 255;
      619
      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?
        • 1. Re: POPLIST LOV lengh limited 11.5.10.2
          Hussein Sawwan-Oracle
          1004571 wrote:
          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 11.5.10.2:
          The class file exist in 11i -- $JAVA_TOP/oracle/apps/bne/integrator/document/macro/msoffice/excel/BneVBALayoutColumn.class
          It is defined per code restriction maximum 255 values for a PopLOV:
          java/integrator/document/macro/msoffice/excel/BneVBALayout.java vers. 120.11.12010000.16
          618 int maxPopVals = 255;
          619
          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?
          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

          Thanks,
          Hussein
          • 2. Re: POPLIST LOV lengh limited 11.5.10.2
            1007574
            Hi Hussein,

            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
            • 3. Re: POPLIST LOV lengh limited 11.5.10.2
              1007574
              Is Somebody known how to create table LOV in 11i?