EAP: Electronic Payment Process (FIN2025) Fails With Unique Constraint at PS_EFT_FILE_RPT for DTALSV Layout (Doc ID 1916836.1)

Last updated on MARCH 18, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When creating a bank file for layout DTALSV, FIN2025 goes to Error.

Steps:
---------
1) Create 2 Vouchers (for 2 Vendors) with 3 Payment Schedules each.
2) Both Vouchers has different Bank Accounts. Payment Method = EFT and Layout = DTALSV.
3) Run Pay Cycle to create Payment for both vouchers.
4) Run Electronic Payment Process - FIN2025 SQR.

Error message:
SQL Status = 1, SQL Error = ORA-00001: unique constraint (SYSADM.PS_EFT_FILE_RPT) violated.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms