Message Oracle ORA-24173 - nested query not supported for rule condition

ERRORnested query not supported for rule condition
CAUSEuser specified nested query in rule condition.
ACTIONdo not use nested query in rule condition.