Pay Cycle Creation Failed With Unique Constraint Error For Payment Method Customer-Draft Intiated
(Doc ID 2435976.1)
Last updated on AUGUST 16, 2018
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.
On : 9.1 version, Pay Cycle
Pay Cycle creation failed with unique constraint error for payment method customer-Draft Intiated
The issue can be reproduced at will with the following steps:
1. Created two vouchers with same Remit Vendor with Separate Payment checkbox checked and Payment method Customer-Draft initiated.
2. Posted vouchers and run the pay cycle.
3.Payment Selection will select both vouchers and then Draft Staging Process get enabled.
4. Run the Draft Staging process and pay cycle status becomes selected and stage and both Drafts are pre-approved as per pay cycle draft option status.
5.Run Pay cycle creation process and process went to error -Unique constraint error on AP_PAYSELECT.Z0004000.Step03(SQL) PS_PYMNT_VCHR_XREF table.
unique constraint violated PYMNT_VCHR_XREF at AP_PAYSELECT.Z0004000.Step03
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!