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:
- 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"
- Run the Direct Deposit PY_DIRDEP
Navigation: Payroll for North America > Payroll Processing USA > Create Direct Deposits > Create Direct Deposit File
- 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