Retiree Payment Program Fails with Unique Constraint Error: ORA-00001: unique constraint (SYSADM.PS_PA_RT_PAY_DETL) violated
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.
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:
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).
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