My Oracle Support Banner

GP_PAYE Fails with Unique Constraint Error When Running the Absence Management Calculation Process (Doc ID 2523373.1)

Last updated on DECEMBER 25, 2019

Applies to:

PeopleSoft Enterprise HCM Absence Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

When running the Absence Management Calculation (GPPDPRUN, which includes sub process GP_PAYE) the process fails with the following errors:

Application Program Failed
 In Pgm Section : GPPIDNT7: XE000-INSERT-SEG-STAT
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_GP_PYE_SEG_STAT) violated
 
Application Program Failed
 In Pgm Section : GPPIDNT1: XA000-CALL-GPPIDNT7
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_GP_PYE_SEG_STAT) violated
 
Application Program Failed
 In Pgm Section : GPPSERVC: LJ000-CALL-IDENTIFY-PGM
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_GP_PYE_SEG_STAT) violated
 
Application Program Failed
 In Pgm Section : GPPDPRUN: JA000-CALL-SERVICE
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_GP_PYE_SEG_STAT) violated


The issue can be reproduced at will with the following steps:
1. Identify and Calculate Calendar
2. Run Calculation/ReCalculation and note above errors are returned

Changes

 

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
Changes
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.