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 NOVEMBER 09, 2023

Applies to:

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.