I defined the column as varchar2(50) not null. and added check constraint:
ADD CONSTRAINT CK_HDR_entity
CHECK ( entity IN ('class' , 'class_periodic' , 'deal' , 'deal_col_periodic' , 'deal_pool_periodic' , 'deal_property_periodic' , 'deal_scol_periodic' , 'deal_tenant_periodic' , 'deal_var' , 'deal_var_periodic' , 'map' ))
the rules check complains with : "entity default value violated permitted values";
am i missing smth ?
Thank you
Andrew