报错信息:PLANO20150318-046683 Sql1 execute exception : update VTZ15BCBCSZ1OVVQIA62QV454C12V t set (FPurUnitId, FBaseUnitId, FBaseCurrencyId, FCompanyOrgUnitId, FExchangeTableId, FPricePrecision, FBaseQty) = (select t1.FUnitId, t5.FMeasureUnitId, t2.FBaseCurrencyId, t2.FID, t2.FBaseExgTableId, t6.FPricePrecision,
round(decimal(t.FQty*t7.FBaseConvsRate,21,8), t5.FQtyPrecision)
from t_bd_MaterialPurchasing t1, t_Org_Company t2, T_ORG_UnitRelation t3, t_bd_Currency t4,
t_bd_MultiMeasureUnit t5, t_bd_material t6, t_bd_MultiMeasureUnit t7
where t.FMaterialId=t1.FmaterialId and t.FPurchaseOrgUnitId=t1.FOrgUnit
and t.FPurchaseOrgUnitId=t3.FFromUnitId and t3.Ftyperelationid='00000000-0000-0000-0000-0000000000030FE9F8B5'
and t3.FTOUnitId=t2.FID
and t.FCurrencyId=t4.FID and t.FMaterialId=t5.FMaterialID and t5.FIsBasicUnit=1
and t.FMaterialId=t6.FID and t.FMaterialId=t7.FMaterialID and t.FUnitId=t7.FMeasureUnitId)
Caused exception message is: ORA-01427: single-row subquery returns more than one row
只有这一颗料报错,其他物料都可以正常投放。物料属性已核对,未发现异常,不知道该如何处理了,望各位大神给予帮助。
另外,手工新增采购申请单时,选择这颗物料(126010067),系统也会报错。
采购申请单.jpg(198.22KB)
计划订单投放失败.jpg(154.46KB)
推荐阅读