ORA-01427: Single-line subquery returns multiple rows

This problem was encountered today when resolving a problem, ORA-01427: Single row subqueries return multiple rows

It was later discovered that the SQL statement returned multiple results in the subquery.

Sub-query:

Select DISTINCT Cus_goodsno from V_biz_goods_match D
where D.sup_goodsno = i.goodsid and D.flag = 0 and d.deleted = 0 and D.cus_orgid = i.customcodeinsys and D.sup_orgid = ' S0 0000001 '

SQL statement:

Select
I.create_date,
I.create_user,
I.id,
I.update_date,
I.update_user,
I.deleted,
(select distinct Cus_goodsno from V_biz_goods_match D
where D.sup_goodsno = i.goodsid and D.flag = 0 and d.deleted = 0 and D.cus_orgid = i.customcodeinsys and D.sup_orgid = ' S0 0000001 ' and rownum=1) Cusgoodsno,
From Biz_hrhn_return_invoice I
where I.customcodeinsys = ' H00000012 ' ORDER by i.create_date Desc;

Add and rownum = 1 in the subquery to force the return of a result.