ORA-29507: query derived from USING clause found zero or many rows

ORA-29507: query derived from USING clause found zero or many rows

Cause: The USING clause defined a query that either did not return any values, or returned more than one value.

Action: Correct the USING clause.