GPIN_ITC Processing To No Success With Unique Constraint Error on PS_GPIN_IT_EE_DTL
(Doc ID 2471592.1)
Last updated on FEBRUARY 05, 2019
Applies to:
PeopleSoft Enterprise HCM Global Payroll India - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
On : 9.2 version, Performance
GPIN_ITC Processing to no Success with Unique constraint error.
Process fails only when a new effective dated row is added and if any element against a line item is changed, for example added new effdt row and modified line item 60 (Tax on Employment), Upon running GPIN_ITC, process is running to No Success.
Main Menu >> Set Up HCM >> Product Related >> Global Payroll & Absence Mgmt >> Taxes >> Define IT Sheet Template IND
ERROR
-----------------------
unique constraint (SYSADM.PS_GPIN_EE_DTL) violated
Failed statement:
INSERT INTO PS_GPIN_IT_EE_DTL (PROCESS_INSTANCE
, EMPLID
, EMPL_RCD
, GPIN_TAX_YEAR
, GPIN_SECTION_ID
, KEY_SERIAL_NBR
, GPIN_IT_COLMN
, PIN_NUM
, CALC_RSLT_VAL
, GPIN_ITCS_LBL)
SELECT DISTINCT A.PROCESS_INSTANCE
, A.EMPLID
, A.EMPL_RCD
, A.GPIN_TAX_YEAR
, '2CL'
, B.KEY_SERIAL_NBR
, 'C'
, B.PIN_NUM
, 0
, B.GPIN_ITCS_LBL ......
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add new effective dated row, change the existing elemetn
2. Run GPIN_ITC process, observe the error
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |