Error: Application Program Failed
In Pgm Section : INSERT-BALANCE
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_TAX_BALANCE) violated
PAGE_NUM= 21,LINE_NUM= 1,SEPCHK=0,EMPLID=098772,NAME=
This error is specifically for Pennsylvania employees.
Resolution:
=================================================================================
Bug 13600773: PA EE RESIDENT LOCALITY CHANGES MAY RESULT IN PAY CONFIRMATION ERRORS
=================================================================================
The following two Pay Confirmation problems related to changes in an employee?s resident locality are reported after implementing new product functionality delivered in Tax Update 11-F to
support Pennsylvania Act 32
-----------------------------------------
Scenario#1
----------
Pay Confirmation abends with a unique constraint (duplicate key)error when attempting to process a Pennsylvania employee with a confirmed check in a prior month who subsequently moves
from a resident locality with a lower PSD code to a resident locality with a higher PSD code.
Here is the scenario we encountered:
Emplid has one entry in month 2 for the current work psd/resident psd codes and has 2 distinct entries in month 1..one entry matches the current entry, the other has a different resident psd code.
Update ID : upd876759.zip
This report delivers modifications to PSPTBUPD.CBL and PSPTBUPD.DMS to resolve two Pay Confirmation issues which could occur as a result of changes in the resident locality of an employee subject to Pennsylvania local earned income tax withholding as required by Pennsylvania Act 32
In Pgm Section : INSERT-BALANCE
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_TAX_BALANCE) violated
PAGE_NUM= 21,LINE_NUM= 1,SEPCHK=0,EMPLID=098772,NAME=
This error is specifically for Pennsylvania employees.
Resolution:
=================================================================================
Bug 13600773: PA EE RESIDENT LOCALITY CHANGES MAY RESULT IN PAY CONFIRMATION ERRORS
=================================================================================
The following two Pay Confirmation problems related to changes in an employee?s resident locality are reported after implementing new product functionality delivered in Tax Update 11-F to
support Pennsylvania Act 32
-----------------------------------------
Scenario#1
----------
Pay Confirmation abends with a unique constraint (duplicate key)error when attempting to process a Pennsylvania employee with a confirmed check in a prior month who subsequently moves
from a resident locality with a lower PSD code to a resident locality with a higher PSD code.
Here is the scenario we encountered:
Emplid has one entry in month 2 for the current work psd/resident psd codes and has 2 distinct entries in month 1..one entry matches the current entry, the other has a different resident psd code.
Update ID : upd876759.zip
This report delivers modifications to PSPTBUPD.CBL and PSPTBUPD.DMS to resolve two Pay Confirmation issues which could occur as a result of changes in the resident locality of an employee subject to Pennsylvania local earned income tax withholding as required by Pennsylvania Act 32
