Pay confirmation failed with Unique constraint error
Application Program Failed
In Pgm Section : INSERT-BALANCE
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_CHECK_YTD) violated
PAGE_NUM= 240,LINE_NUM= 1,SEPCHK= 0,EMPLID=987162
Application Program Failed
In Pgm Section : PROCESS-CHECK(PSPCBUPD)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_CHECK_YTD) violated
Solution:
Pay confirmation ran for October Period.
Verified EE 987162 has balances for period 11 for paycheck, earnings and taxes and that is why the confirm is erring. We need to update 987162 to OK_TO_PAY = N
UPDATE ps_pay_earnings SET OK_TO_PAY = 'N' where emplid = '987162' and company = 'XXX' AND PAYGROUP = 'XXX'
UPDATE PS_PAY_CALENDAR SET PAY_CONFIRM_START = 'N' WHERE COMPANY = 'XXX' AND PAYGROUP = 'XXX' AND PAY_END_DT = '30-OCT-2012' Now they can calc where needed and then rerun the confirm. Or other way is that they can Update 987162 to remove balances for period 11 and flip okay to pay back to Y. Later run Recalc where needed and confirm.
Application Program Failed
In Pgm Section : INSERT-BALANCE
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_CHECK_YTD) violated
PAGE_NUM= 240,LINE_NUM= 1,SEPCHK= 0,EMPLID=987162
Application Program Failed
In Pgm Section : PROCESS-CHECK(PSPCBUPD)
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_CHECK_YTD) violated
Solution:
Pay confirmation ran for October Period.
Verified EE 987162 has balances for period 11 for paycheck, earnings and taxes and that is why the confirm is erring. We need to update 987162 to OK_TO_PAY = N
UPDATE ps_pay_earnings SET OK_TO_PAY = 'N' where emplid = '987162' and company = 'XXX' AND PAYGROUP = 'XXX'
UPDATE PS_PAY_CALENDAR SET PAY_CONFIRM_START = 'N' WHERE COMPANY = 'XXX' AND PAYGROUP = 'XXX' AND PAY_END_DT = '30-OCT-2012' Now they can calc where needed and then rerun the confirm. Or other way is that they can Update 987162 to remove balances for period 11 and flip okay to pay back to Y. Later run Recalc where needed and confirm.
