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

ERRORquery derived from USING clause found zero or many rows
CAUSEThe USING clause defined a query that either did not return any values, or returned more than one value.
ACTIONCorrect the USING clause.