Hi, Can you please let me know how many records at max can be there in the static lookup.
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.
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.
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.
There is no hard defined limit as far as I am aware. Are you hitting any limit?