Absence Forecasting - Unique Constraint Error on GP_ABS_EVT_FCST Record (Doc ID 1446523.1)

Last updated on APRIL 25, 2016

Applies to:

PeopleSoft Enterprise HRMS Absence Management - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

Unique constraint error in GP_ABS_EVT_FCST table on forecasting absences.

STEPS TO REPLICATE
--------------------
1. Go to Self Service -> Time Reporting -> Report Time -> Absence Request .
2. Select the required Absence.
3. Click on the Forecast button.

ERROR MESSAGE
-----------------------
Application Program Failed
In Pgm Section : GPPRDM01: GJ100-INSERT-ABS-EVENT-FCST
With Return Code: 00805
Error Message : ORA-00001: unique constraint (PHAPPADM.PS_GP_ABS_EVT_FCST) violated
with reason: GPPRDM01: GJ100-INSERT-ABS-EVENT-FCST

LOSS OF FUNCTIONALITY/IMPACT:
-----------------------------------------
This issue is happening for few employees from time to time causing problems to forecast absence.

WHAT IS WORKING:
-------------------------
This issue is not occurring for all the employees on forecasting absences, but only for a few employees.

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