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 JUNE 07, 2021

Applies to:

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


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

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

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'




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

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