EPY: Pay Calc Is Failing In GET-ST-TAX-TYPE(FETCH) Section After Tax Update 19-B (Doc ID 2556608.1)

Last updated on JULY 14, 2021

Applies to:

Symptoms

 process failed in test environment 
Pay calculation process failed in test environment with the following error message GET-ST-TAX-TYPE(FETCH) section after applying tax update 19-B


Full Error Message:
Application Program Failed
 In Pgm Section : GET-ST-TAX-TYPE(FETCH)
 With Return Code: 00001
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_CAL_BAL_ID) violated
 
 
Application Program Failed
 In Pgm Section : GROSS-CALC(PSPTGCTB)
 With Return Code: 00001
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_CAL_BAL_ID) violated
 
PAGE_NUM= 46,LINE_NUM= 2,SEPCHK= 0,EMPLID=<Emplid> ,EMPLRCD#= 0,NAME= Employee Name
 
Application Program Failed
 In Pgm Section : NET-PROCESS(PSPPYNET)
 With Return Code: 00001
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_CAL_BAL_ID) violated
 
 
Application Program Failed
 In Pgm Section : MAIN(PSPPYCAL)
 With Return Code: 00001
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_CAL_BAL_ID) violated


The issue can be reproduced at will with the following steps:
  1. Apply Tax Update 19-B
  2. Create Paysheet
  3. Run Calculate Pay

Changes

 Tax Update 19-B applied

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.