Clarity

Expand all | Collapse all

Max Entries in Static Lookup?

  • 1.  Max Entries in Static Lookup?

    Posted 11-22-2018 06:01 AM

    Hi, Can you please let me know how many records at max can be there in the static lookup.



  • 2.  Re: Max Entries in Static Lookup?

    Posted 11-22-2018 06:17 AM

    Hi Kritika, 

     

    I do not think there is any limitation in the number of Lookup Values that you can add in a Static Lookup. 

    If you go by the limit of individual field lengths from the DB end then this is what it is: 

     

    ID N NUMBER(22)
    LOOKUP_TYPE N VARCHAR2(255)
    LOOKUP_CODE N VARCHAR2(30)
    PARENT_LOOKUP_CODE Y VARCHAR2(30)
    LOOKUP_LEVEL Y NUMBER(22)
    LOOKUP_ENUM Y NUMBER(22)
    SORT_ORDER Y NUMBER(22)
    IS_SYSTEM N NUMBER(22)
    IS_ACTIVE N NUMBER(22)
    IS_ADMIN_VISIBLE N NUMBER(22)

     

    I just referred to the CMN_LOOKUPS table. Hope that helps. 

     

    Thanks,

    Abhisek Dhar



  • 3.  Re: Max Entries in Static Lookup?

    Broadcom Employee
    Posted 11-27-2018 02:02 AM

    Hi Kritika, 

     

    If you use Oracle and Pull Down type lookup, it will generate below sql.

     

          SELECT… IN (xxxxx,xxxxx…

     

    If 'IN' operator exceeds 1000, then you will get ORA-01795 and you will get unexpected problem. 

    (ORA-01795 maximum number of expressions in a list is 1000.)

     

    I think it is Oracle limitation. 

    If you encounter this situation, please use Browse type lookup.

     

    Regards,

    Shoichi



  • 4.  Re: Max Entries in Static Lookup?

    Posted 11-27-2018 02:51 AM

    Hi Shoichi_Sugawara,

    My question is to know how many entries can be put into a static lookup i.e. when we insert data into lookup, Not 'How many can be rendered in different types of lookups'. 

    I hope I am clear on this point.



  • 5.  Re: Max Entries in Static Lookup?

    Broadcom Employee
    Posted 11-27-2018 05:40 AM

    Hi Kritika,

     

    There is no hard defined limit as far as I am aware. Are you hitting any limit?

     

    Regards
    Suman Pramanik