My Oracle Support Banner

Pay Cycle Creation Failed With Unique Constraint Error For Payment Method Customer-Draft Intiated (Doc ID 2435976.1)

Last updated on OCTOBER 01, 2018

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Pay Cycle

Pay Cycle creation failed with unique constraint error for payment method customer-Draft Intiated




STEPS
-----------------------
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.

ERROR
-----------------------
unique constraint violated PYMNT_VCHR_XREF at AP_PAYSELECT.Z0004000.Step03

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


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