Max Entries in Static Lookup?

[Kritika Rana]

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

[Legacy User]

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

[Shoichi Sugawara]

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

[Kritika Rana]

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.

[Suman Pramanik]

Hi Kritika,

 

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

 

Regards
Suman Pramanik