EAP: Payment Inquiry page does not show all Vouchers paid (including the overflow checks) on the same Check

(Doc ID 1329762.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

The Payment Inquiry page does not show all Vouchers paid (including the overflow checks) on the same Check (Payment Reference ID) after applying FMS Financials 8.9 Bundle #40.

STEPS

TEST 1 -- After Bundle #40 (ERROR)
1.  Payment Form CHECK3: Advice Lines: 2
2.  Create 5 Vouchers for the same Vendor
3.  Run the Pay Cycle
4.  Payment Inquiry page
Payment Reference ID = 009016 shows 2 Vouchers/Payments
Payment Reference ID = 009017 shows 2 Vouchers/Payments
Payment Reference ID = 009018 shows 1 Vouchers/Payments

ERROR:  Only 2 Vouchers are included for Payment Reference ID = 009016.  Does not include Overflow records.  Must include all Payment Reference IDs to see all Vouchers.

PS_PAYMENT_TBL
PYMNT_ID     PYMNT_ID_REF     PYMNT_AMT
0000010015      009016                     15000.000
0000010016      009017                     0.000
0000010017      009018                     0.000

PS_PYMNT_ADVICE
PYMNT_ID_REF     PYMNT_OVERFLOW_ID     PAID_AMT     PYMNT_ID
009016                     009016                                   2000.000         0000010015
009016                     009016                                   1000.000         0000010015
009017                     009017                                   4000.000         0000010016
009017                     009017                                   3000.000         0000010016
009018                     009018                                   5000.000         0000010017


TEST 2 - Before Bundle #40 (OK)
1.  Payment Form CHECK3: Advice Lines: 2
2.  Create 5 Vouchers for the same Vendor
3.  Run the Pay Cycle
4.  Payment Inquiry page
Payment Reference ID = 009034 shows all 5 Vouchers/Payments
Payment Reference ID = 009035 does not show any Vouchers/Payments
Payment Reference ID = 009036 does not show any Vouchers/Payments

All Vouchers (including Overflows) are included on only one Payment Reference ID (009034), which is correct.

PS_PAYMENT_TBL
PYMNT_ID     PYMNT_ID_REF     PYMNT_AMT
0000010047      009034                     15000.000
0000010048      009035                     0.000
0000010049      009036                     0.000

PS_PYMNT_ADVICE
PYMNT_ID_REF     PYMNT_OVERFLOW_ID     PAID_AMT     PYMNT_ID
009034                     009034                                   2000.000         0000010047
009034                     009034                                   1000.000         0000010047
009035                     009034                                   4000.000         0000010048
009035                     009034                                   3000.000         0000010048
009036                     009034                                   5000.000         0000010049
 

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