My Oracle Support Banner

Online Confirmation Statement Process Errors: Return: 805 - ORA-00001: unique constraint (SYSADM.PS_BAS_STMT_DEPENR) violated (Doc ID 2532484.1)

Last updated on JULY 25, 2019

Applies to:

PeopleSoft Enterprise HCM eBenefits - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When running the Online Confirmation Statement Process for Individual Employees with an Event Maintenance Schedule ID, the error below occurs.

ERROR
-----------------------
 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_BAS_STMT_DEPENR) violated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in as a Benefit Administrator and run process to generate the benefit confirmation statement for an employee (Workforce Administrator> Benefits Administrator> Benefits Management> Online Confirmation Statements)
2. Process completes successfully, log in as employee and verify if they can see the benefit statement and all information:
3. Log back in as Benefit Administrator and run the process again to generate the benefit confirmation statement for another employee
4. For second employee, process ran to 'No Success'

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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