8.5sp1 组织无法封存,组织下所有职员已离职。所有职位已禁用情况下还是无法封存组织
版本:8.5 sp1
分析:已知的程序漏洞,后面会发补丁解决,目前暂时就只能通过sql语句更新一下(20200615),
需要依次执行一下下面的sql语句
SELECT * FROM t_org_admin where fnumber = '组织编码' --1
SELECT * FROM T_BD_Person PERSON LEFT OUTER JOIN T_ORG_PositionMember PM ON PERSON.FID = PM.FPersonID WHERE PM.FPositionID IS NULL AND PERSON.FDeletedStatus =1 AND PERSON.FGKAdmin = '组织id' --2 如果查出的数据为空就不用执行第3步
update T_BD_Person set FDELETEDSTATUS = 2 where fid in (SELECT PERSON.fid FROM T_BD_Person PERSON LEFT OUTER JOIN T_ORG_PositionMember PM ON PERSON.FID = PM.FPersonID WHERE PM.FPositionID IS NULL AND PERSON.FDeletedStatus =1 AND PERSON.FGKAdmin = '组织id') --3
版本:8.5 sp1
分析:已知的程序漏洞,后面会发补丁解决,目前暂时就只能通过sql语句更新一下(20200615),
需要依次执行一下下面的sql语句
SELECT * FROM t_org_admin where fnumber = '组织编码' --1
SELECT * FROM T_BD_Person PERSON LEFT OUTER JOIN T_ORG_PositionMember PM ON PERSON.FID = PM.FPersonID WHERE PM.FPositionID IS NULL AND PERSON.FDeletedStatus =1 AND PERSON.FGKAdmin = '组织id' --2 如果查出的数据为空就不用执行第3步
update T_BD_Person set FDELETEDSTATUS = 2 where fid in (SELECT PERSON.fid FROM T_BD_Person PERSON LEFT OUTER JOIN T_ORG_PositionMember PM ON PERSON.FID = PM.FPersonID WHERE PM.FPositionID IS NULL AND PERSON.FDeletedStatus =1 AND PERSON.FGKAdmin = '组织id') --3
8.5sp1 组织无法封存,组织下所有职员已离职。所有职位已禁用情况下还是无法封存组织
本文2024-09-22 21:02:09发表“s-hr cloud知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-shr-117460.html
