My Oracle Support Banner

EAP: When Processing a Paid Invoice, the Voucher Build Process Triggers an Incorrect Error Message "Duplicate Payment Reference" in PS_TSE_PYMNT_FLD Table. (Doc ID 2995886.1)

Last updated on JANUARY 11, 2024

Applies to:

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

Symptoms

An invoice is paid externally and this invoice information along with the payment details( payment reference number and payment action) are staged in the voucher staging tables.

When the voucher build process is run, the process triggers an incorrect  error message in PS_TSE_PYMNT_FLD .

It states that the error message is "Duplicate Payment Reference". However, as per the data stagged the error should be “The maximum payment reference number length for this bank account is 6"


Steps to replicate

1) Review the Check number length from the bank configuration.
      Menu > Banking > Bank Accounts > External Accounts > Account Information.

2) Load the voucher staging table details with paid invoice data.
     ( Along with VCHR_HDR_STG,VCHR_LINE_STG and VCHR_DIST_STG, data is populated in VCHR_PYMT_STG table for the fields  PYMNT_ACTION = 'R', PYMNT_ID_REF, PYMNT_METHOD = 'MAN)

3) Now add new run control to run the voucher build process:
     Menu > Accounts Payables > Batch Process > Vouchers Voucher Build.

4) Voucher is placed in recycle status.

5) Locate the Message set and Message number from PS_TSE_PYMNT_FLD table.

6) review the error message.
       Menu > PeopleTools > Utilities > Administration > Message Catalog.

Note: EAP: Is it Feasible to Convert Vouchers that were Fully or Partially Paid in a 3rd Party System To PeopleSoft by Populating Voucher Staging? (Doc ID 2735508.1)

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
References


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