请假单提交生效,如果在列表内提交生效,提示null.点进单据内提交生效,提示操作失败,请联系管理员。

[适用版本]
通用
[解决方案]
问题:请假单提交生效,如果在列表内提交生效,提示Null.点进单据内提交生效,提示操作失败,请联系管理员。
处理方案:
档案重复导致,已后台修复,参考sql:
--备份
select * into attendancefile0307 from T_hr_ats_attendancefile
select * into attendancefilehis0307 from T_hr_ats_attendancefilehis
--查询考勤档案的多条重复数据
select * FROM T_hr_ats_attendancefile m
where exists (
select fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid from T_hr_ats_attendancefile
where m.fproposerid = fproposerid
group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)
and fleffdt = {ts '2099-12-31'}
and fid not in (select min(fid) from T_hr_ats_attendancefile group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)
--删除考勤档案的多条重复数据
delete FROM T_hr_ats_attendancefile m
where exists (
select fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid from T_hr_ats_attendancefile
where m.fproposerid = fproposerid
group by fproposerid,feffdt,fleffdt,fadminorgunitid,fpositionid having count(*)>1)
and fleffdt = {ts '2099-12-31'}
and fid not in (
请假单提交生效,如果在列表内提交生效,提示null.点进单据内提交生效,提示操作失败,请联系管理员。
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。



