My Oracle Support Banner

EAP: Voucher Build Recycle Error "Voucher Pay Amount Xxxxx <> Sum of Scheduled Payment Amounts Xxxx", When Processing an Invoice Staged Multiple Distribution Lines and Different Payment Messages for Each Distribution Line. (Doc ID 2982457.1)

Last updated on OCTOBER 27, 2023

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 with multiple distribution lines is stagged using the exceluploadforvoucher.xlsm template.

A different payment message was entered on VCHR_PYMT_STG.PYMNT_MESSAGE for each distribution line such that this voucher can be paid in multiple schedules.

When the voucher process created the voucher with the following error:

"Voucher pay amount xxxxx <> sum of scheduled payment amounts xxxxxx".

Replication steps 

1. Using the ExcelUploadforVoucher.xlsm template stage an invoice with one voucher line and multiple distribution lines( say 25).

2. Enter a different payment message for each distribution line on the data input sheet for the VCHR_PYMT_STG.PYMNT_MESSAGE field.

3. Generate and post the XML.

4. Review the data in the staging tables.

5. The VCHR_DIST_STG has 25 lines.

6. The VCHR_PYMT_STG has 25 lines and each payment line has a different message the payment count is incremented in series starting from 1-25.

7. Run voucher build process the above recycle error observed.
    Menu > Accounts Payables > Batch Processes > Voucher > Voucher Build.

It was also observed that the 25 payment schedules were created, the total invoice header amount is equally distributed over the 25 payment schedules. 

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.