My Oracle Support Banner

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 JUNE 18, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.