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.
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
unique constraint (SYSADM.PS_GPIN_EE_DTL) violated
INSERT INTO PS_GPIN_IT_EE_DTL (PROCESS_INSTANCE
SELECT DISTINCT A.PROCESS_INSTANCE
, B.GPIN_ITCS_LBL ......
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
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