Oracle Error ORA-19125: FORG0005: fn:exactly-one() called with a sequence containing zero or more than one item

Oracle Error Message

ORA-19125: FORG0005: fn:exactly-one() called with a sequence containing zero or more than one item

Reason for the Error

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

Solution

correct input argument to fn:exactly-one() function