Oracle Error ORA-24173: nested query not supported for rule condition

Oracle Error Message

ORA-24173: nested query not supported for rule condition

Reason for the Error

user specified nested query in rule condition.

Solution

do not use nested query in rule condition.