Oracle Error ORA-19123: FORG0003: fn:zero-or-one() called with a sequence containing more than one item

Oracle Error Message

ORA-19123: FORG0003: fn:zero-or-one() called with a sequence containing more than one item

Reason for the Error

sequence with more than one item was passed into fn:zero-or-one() function

Solution

correct input argument to fn:zero-or-one() function