My Oracle Support Banner

EPY: Off-Cycle Direct Deposit Causes a 805 - ORA-00001: Unique Constraint Error for Some Employees With Multiple Jobs for PY_DIRDEP App Engine (Doc ID 2774985.1)

Last updated on OCTOBER 27, 2022

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When running the Off-Cycle Direct Deposit Application Engine, PY_DIRDEP, am receiving a unique constraint error:

Steps to Produce:
The issue can be reproduced at will with the following steps:

  1. Navigate to: Set Up HCM > Install > Product Specific > Payroll for NA Installation 
         - Under the title "U.S. Off-Cycle Files" Check both Create Off-Cycle Files and Use Check Date on Advice "On"
         - Save
  2. Run the Direct Deposit PY_DIRDEP
         Navigation: Payroll for North America > Payroll Processing USA > Create Direct Deposits > Create Direct Deposit File 
  3. The process does not complete and you receive the 805 unique constraint error


 The enhanced Direct Deposit for Off-cycle from PUM 34 was applied and was turned on on the installation table.


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.