错误提示：
SELECT * FROM LOG_MESSAGE ORDER BY LOG_DATE DESC;
--ORA-01422: 实际返回的行数超出请求的行数ORA-06512: 在 "STG.SAP_SO_BOM_PROC", line 494
--ORA-06512: 在 "STG.SAP_SO_BOM_PROC", line 1116
000000101001040220/2023/P229/000000102001002528/000000102001001400/2110
原因：SQL语句 二返回了两条工艺路径导致报错。
SQL语句 一：
SELECT SO_ID, SO_LINE_ID, SITE_ID, PITEM, CITEM, N_CITEM, LOC_ID, CTYPE || ROWNO AS CTYPE FROM SAP_SO_BOM WHERE SAP_SO_BOM.CTYPE = ‘P‘ and pitem=‘000000101001040220‘;
SQL语句二：
SELECT MAPL.PLNNR || ‘_‘ || MAPL.WERKS ROUTING_ID FROM SAP_MAPL_QMCUSTOMER MAPL WHERE MAPL.MATNR = ‘000000101001040220‘ --PITEM AND MAPL.WERKS = ‘2023‘ AND EXISTS (SELECT NULL FROM SAP_MAPL_QMCUSTOMER WHERE SAP_MAPL_QMCUSTOMER.MATNR = ‘000000101001040220‘ AND SAP_MAPL_QMCUSTOMER.WERKS = ‘2023‘)--SITEID
SAP_SO_BOM_PROC 实际返回的行数超出请求的行数
原文：https://www.cnblogs.com/Snowfun/p/14458091.html