My Oracle Support Banner

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 later
Information 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


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