EGP9: GPPIDNT1_I_ITERWRK Causing Unique Constraint Errors in Stream Processing (Doc ID 876653.1)

Last updated on JULY 09, 2013

Applies to:

PeopleSoft Enterprise HRMS Global Payroll Core - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

While attempting to run Global Payroll process in streams, the following error occurs.

ERROR
-----------------------
Application Program Failed
In Pgm Section :GPPIDNT1: JG000-INS-PYE-ITER-WRK
With RTNCD Of :00805
:Duplicate

GPPIDNT1_I_ITERWRK doesn't have the EMPLID range paritition. As a result, each stream is performing an insert of all iterative triggers from all streams and causing a "Unique Constraint" error.

STEPS
-----------------------
1. Navigate to Global Payroll & Absence Management > Payroll & Absence Processing > Calculate Absence & Payroll
2. Select run control value.
3. Select Calendar group, stream number, Identify & Calculate phases and click on run button.
4. Repeat steps 1,2 and 3 for all the streams.
5. Above error is noticed.


BUSINESS IMPACT
------------------------
Unable process Global Payroll for United Kingdom successfully.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms