Cause
Subuqery in the SELECT list is not supported in the SQL assertion definition.
Action
Remove the subquery from the SELECT of the SQL assertion definition.
Oracle 26ai
ORA-08658
Error Message
Subquery in the SELECT list not supported.