Retiree Payment Program Fails with Unique Constraint Error: ORA-00001: unique constraint (SYSADM.PS_PA_RT_PAY_DETL) violated (Doc ID 1606879.1)

Last updated on AUGUST 29, 2016

Applies to:

PeopleSoft Enterprise HRMS Pension Administration - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When running the Retiree Payment Process for a number of employee contribution withdrawals that results in a commit occurring before the processing is completed fails with the following error:

ERROR
=====
SEVERE ERROR IN PGM:(16005,27771) PI(317408) Program(PAPPPYMT)        
SQL Update Error-  .  . RA1300-INSERT-PAYMENT-DETAIL(I EmplId is xxxxxx                                                              

Application Program Failed
In Pgm Section  : RA1300-INSERT-PAYMENT-DETAIL(INSERT)                
With Return Code: 00000
Error Message   : ORA-00001: unique constraint (SYSADM.PS_PA_RT_PAY_DETL) violated

STEPS TO REPLICATE
===============
The issue can be reproduced at will with the following steps:
1. Request over 20 contribution withdrawals (Navigation: Pension > Payments > Withdraw Contributions).
2. Run the process to create the payments (Navigation: Pension > Payments > Create Retiree Payments).

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