后台事务“计算工作年限”测试报错

栏目：s-hr cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-22浏览：1

后台事务“计算工作年限”测试报错

后台事务[计算工作年限]执行失败,报错如下:

Caused exception message is: Sql1 execute exception : update T_HR_EmpLaborRelation labor set fenteryears = (select fenteryears from T_HR_EmpLaborRelationHis where labor.Fpersonid = Fpersonid and FisInner=1 and fendDateTime >= {ts '2199-12-31 23:59:59'})where exists(select fenteryears from T_HR_EmpLaborRelationHis where labor.Fpersonid = Fpersonid and FisInner=1 and fendDateTime >= {ts '2199-12-31 23:59:59'})

Caused exception message is: ORA-01427: single-row subquery returns more than one row

现场存在二开写入的数据,需确保用工关系历史表员工只有一条结束日期为“2199-12-31”的记录。