已经完成的算薪能有什么办法重新计算吗

可以参考：

重新打开finalized的月份的薪资

UPDATE sysadm.PS_GP_CAL_RUN SET RUN_FINALIZED_IND='N',RUN_FINALIZED_TS=NULL,RUN_OPEN_IND='Y', RUN_OPEN_TS='', PMT_SENT_IND ='N' WHERE CAL_RUN_ID=:1;
UPDATE sysadm.PS_GP_CAL_RUN_DTL SET CAL_FINAL_TS=NULL, CAL_IDNT_TS='' WHERE CAL_RUN_ID=:1;

UPDATE sysadm.PS_GP_PYE_SEG_STAT SET PYE_CALC_STAT='50' WHERE CAL_RUN_ID=:1;

执行这三条SQL后commit，然后马上运行薪资取消。然后再重新标示计算。

UPDATE PS_GP_CAL_RUN SET RUN_FINALIZED_IND='N',RUN_FINALIZED_TS=NULL,RUN_OPEN_IND='Y' WHERE CAL_RUN_ID='日历组ID';
UPDATE PS_GP_CAL_RUN_DTL SET CAL_FINAL_TS=NULL WHERE CAL_RUN_ID='日历组ID';
UPDATE PS_GP_PYE_SEG_STAT SET PYE_CALC_STAT='50' WHERE CAL_RUN_ID='日历组ID';
UPDATE PS_GP_CAL_RUN SET PMT_SENT_IND ='N' WHERE CAL_RUN_ID='日历组ID';