you must explicitly say what your property type is "NUMBER(1)" , not "BOOLEAN" in the entity configuration.

add this config in entity configuration

builder.Property(e => e.Active).HasColumnType("NUMBER(1)");