Advanced Benefits - PSFT (MOSC)

MOSC Banner

Leave Accrual Process - PSPACCRL - Inserting same rows twice - Unique Constraint Error

Hi All,

We are in PeopleSoft HCM 9.0 and PeopleTools 8.54.

We are facing a strange scenario. PFB.

We have an active employee who has an active enrollment in Leave Plan - Plan Type: 52.

When we are running the delivered leave accrual process: PSPACCRL we are getting the below error:

"Leave Accrual started for Company: ABC        at 20:37:16.93
DATE = 2025-09-21 EMPL = XXXXX             
Application Program Failed
 In Pgm Section  : INSERT-LEAVE-ACCRUAL                                 
With Return Code: 00805  
Error Message   : ORA-00001: unique constraint (SYSADM.PS_LEAVE_ACCRUAL) violated  
Application Program Failed 
In Pgm Section  : PROCESS-ACCRUAL(PSPACCPR)                            
With Return Code: 00805  
Error Message   : ORA-00001: unique constraint (SYSADM.PS_LEAVE_ACCRUAL) violated 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center