Pay confirmation Process failed with error : "ORA-00001: unique constraint (SYSADM.PS_TAX_BALANCE) violated "

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  

Pay confirmation Process failed with error : "Error Message : Invalid SELECT item number "

Error :Application Program Failed
Action Type : SQL SELECT
In Pgm Section : SQLRT: PROCESS-SETUP(SELECT)
With Return Code: 08003
Error Message : Invalid SELECT item number
Stored Stmt : PSPTBUPD_S_PA_RES
SQL Statement : SELECT RES_PSD_CD ,NLGRS_MTD ,NLGRS_QTD ,NLGRS_YTD ,TXGRS_MT
D ,TXGRS_QTD ,TXGRS_YTD ,TAX_MTD ,TAX_QTD ,TAX_YTD ,TIPS_MTD
FROM PS_TAX_BALANCE WHERE EMPLID=:1 AND COMPANY=:2 AND BALA
NCE_ID=:3 AND BALANCE_YEAR=:4 AND STATE=:5 AND LOCALITY=:6 A
ND TAX_CLASS=:7 AND WORK_PSD_CD=:8 AND RES_PSD_CD=:9_



Application Program Failed
In Pgm Section : SELECT-PA-PSD
With Return Code: 08003
Error Message : Invalid SELECT item number

PAGE_NUM= 12,LINE_NUM= 1,SEPCHK=0,EMPLID=0987678,NAME=

Application Program Failed
In Pgm Section : PROCESS-CHECK(PSPTBUPD)
With Return Code: 080   Observation when we receive this error: The PSPTBUPD.CBL COBOL program was recompiled but the dms script came with that patch was not ran. Resolution:  The Invalid SELECT item number error that was received in the most recent run of Beta indicates that the cobol and dms objects are out of sync.  Need to recompile the PSPTBUPD.CBL COBOL program and run the dms script.