EAP: Consolidated Solution for Overflow and Payment Advice issues in Payables Release 9.1 (Doc ID 1473186.1)

Last updated on OCTOBER 17, 2016

Applies to:

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

Symptoms

For Release 9.1, merging of all the Overflow and Payment Advice issues below into one resolution for existing Customers who do not want to apply bundles.

Customer will need to be at least up to Bundle #9 or later in order to apply this resolution.

NOTE:  The majority of the issues listed deal with the Overflow and Payment Advice issue.  However, there are 2 fixes that were included in the merged fix that are not Overflow and Payment Advice issues, which are as follows:

6 - Crystal/XMLP Check prints blank when EFT Payment Advice prints first
10 -Pay Cycle abends at step AP_APY2015.P_INSPAY.STEP25


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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

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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

2 - Payment Advice Line Overflow Is Not Working

Payment advices are not printed correctly.

Advice location = Same Report as Check
Overflow location = Separate Advice Report
Advice Lines = 1

The issue is that the check is printed and the Voucher #1 total is printed.  On the Advice, Voucher #1 and Voucher #2 is printed.  It should only print Voucher #2.

If using Crystal Check, sometimes the results will be both Voucher #1 and Voucher #2 appear on the first advice and second advice.

Voucher #1 should be on first advice with the check and Voucher #2 should be on the advice.


STEPS
1. Create 2 vouchers for the same vendor with 5 invoice lines each.
2. Pay the vouchers so that overflow is created.
3. Run Check Printing process.
4. The amount on the check includes overflow amount however, the overflows are not printed correctly.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

3 - Payment Overflow ID Incorrect For Vouchers Created With Separate Payment

The Payment Overflow ID is assigned incorrectly for Vouchers that have the same Vendor ID with the Separate Payment box checked on the Voucher > Payments page and are processed together during the Pay Cycle. Due to this, the Payment Inquiry page is showing incorrect results when displaying the Vouchers associated to each Check. All of the Vouchers are appearing underneath the 1st Check Number instead of their own respective Check Numbers.


STEPS

1.Setup external bank account and payment method EFT with Form ID EFT1
2. Create 2 vouchers for the same vendor and check Separate Payment on both vouchers
3. Run pay cycle and pay the vouchers separately
4. Check on Payment Inquiry page and both vouchers will be showed under the first payment reference and no voucher under the second payment reference
5. Payment Overflow ID from PYMNT_ADVICE record is incorrectly populated with the Reference ID of the first payment processed.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

4 - Overflow Reference Number is incorrect when new Reference Numbers are created

Overflow Reference Number is incorrect when new Reference Numbers are created on Check Restart.
 
STEPS
1. Payment Form CHECK3 has Advice Overflow line of 1
2. External Bank uses CHECK3 for System Check
3. Create 2 vouchers for the same Vendor.
4. Run Pay Cycle Manager to pay both Vouchers
5. XMLP/Crystal Check shows Check AA and Overflow Advice BB
6. Overflow Advice BB references an Overflow Reference for AA
7. Do a Check Restart with new Reference Numbers
8. XMLP/Crystal Check shows Check CC and Overflow Advice DD
9. Overflow Advice DD references the Overflow Reference for AA (the old reference).

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

5 - Payment Overflow ID is not assigned correctly for Vouchers with multiple Business Units

The Payment Overflow ID is assigned incorrectly for Vouchers that have the same Vendor ID but are created for multiple Business Units and are processed together during the Pay Cycle. Due to this, the Payment Inquiry page is showing incorrect results when displaying the Vouchers associated to each Check. All of the Vouchers are appearing underneath the 1st Check Number instead of their own respective Check Numbers.

STEPS

1. Go to Accounts Payable > Vouchers > Add/Update > Regular Entry and create few Vouchers for Business Unit 1
2. Create few Vouchers for Business unit 2 for the same Vendor.
3. Go to Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager and run the Pay Cycle
4. 2 Checks are printed
5. Inquiry on both Payment Reference ID's through Payment Inquiry
6. For the 1st Payment, the Vouchers For a Payment page displays both Vouchers, which is incorrect. It should display the 1st Voucher
7. For the 2nd Payment, the Vouchers For a Payment page displays no Vouchers, which is incorrect. It should display the 2nd Voucher

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

6 - Crystal/XMLP Check prints blank when EFT Payment Advice prints first

Crystal/XMLP Check prints blank when EFT Payment Advice prints first

STEPS
1. EFT Payment on External Bank is with EFT Payment Advice (EFT2)
2. Enter a Voucher for system check
3. Enter a Voucher for EFT payment
4. Enter a Payment Selection Criteria for EFT and System Check
5. Run Pay Cycle Manager and both Vouchers are selected
6. Print the EFT Payment advice first
7. Print the System Check second
8. Crystal Check prints out blank

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

7 - Incorrect Payment Overflow ID Assigned during Pay Cycle where Different Payment Methods Are Used

The Payment Overflow ID is getting assigned incorrectly for Vouchers which have different Payment Methods for the same Vendor and processed together. Due to this, the Payment Inquiry page is not showing correct results.

STEPS

1. Create two new Vouchers for the same Vendor. One is for Payment Method CHK and one for EFT
2. Run the Pay Cycle and pay the Vouchers
3. The Payment Overflow ID of the check is the Payment Reference ID of the EFT payment

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

8 - PYMNT_ADVICE.PYMNT_OVERFLOW_ID field is populated as 'ADVICE' when it should be the Check Number

PYMNT_ADVICE.PYMNT_OVERFLOW_ID field is populated as 'ADVICE' for the advice lines that do not overflow for payment form CHECK1.

STEPS
1.  Set up external bank account with CHECK1 as the form ID for payment method='System Check'.
2.  Payment form CHECK1 is setup to have 5 advice lines, Overflow Location as 'Separate Advice report' and Advice Location as 'Same Report as Check'.
3.  Create two vouchers with payment methods 'CHCK' and 'WIRE'.
4.  Run Pay Cycle for make the payment for the above two vouchers.
5.  PYMNT_OVERFLOW_ID in PYMNT_ADVICE table for payment method='chck' is populated as 'ADVICE'.


EXPECTED BEHAVIOR
Since the lines are not overflow lines, PYMNT_OVERFLOW_ID should be same as the check number.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

9 - Vouchers for Payment Inquiry Displaying Incorrect Results when using different Addresses

When inquiring on a Payment for a vendor and the next payment for the same vendor was paid to a different Remit Address, the Vouchers for Payment inquiry list the vouchers for both Payments.

STEPS
1. On Vendors > Vendor Information > Add/Update > Vendor, add a new address to an existing vendor.
2. Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry and add two vouchers.
3. First voucher with the remit address as seq 1.
4. Second voucher with the remit address as seq 2.
5. Pay these two vouchers.
6. Go to payment inquiry page - the two payments will shows up. (Accounts Payable > Review Accounts Payable Info > Payments > Payment)
7. Then click on the first check no - it will show two vouchers.
8. When clicked on the second check no - nothing shows up.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

10 - Pay Cycle abends at step AP_APY2015.P_INSPAY.STEP25

Pay Cycle abends at step AP_APY2015.P_INSPAY.STEP25

STEPS
1. Enter a Voucher with Payment Method of Customer Initied EFT Draft (BEF)
2. Run Express Payment (or Pay Cycle) to pay the Voucher
3. Pay Cycle abends at step AP_APY2015.P_INSPAY.Step25

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

11 - Payment Reference missing Voucher Details for Vouchers created with different Locations

When creating two Vouchers for the same vendor, having two locations with same vendor bank account and payment method EFT, the generated file shows two payments, but in the Payment Inquiry page it is only under the 1st reference which is not correct and the second payment shows empty.

STEPS
1. Create Vendor with two Locations having the same vendor bank information
2. Create two Vouchers each with different Locations and payment method EFT
3. Pay the Vouchers
4. Navigate to Accounts Payable> Review Accounts Payable Info > Payments> Payment and search for the 1st reference you will find the two payments under it
5. Search for the 2nd payment reference and no payment shown under this reference

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

12 - Payment Overflow ID Incorrect For Vouchers Created With Different Handling Codes

The Payment Overflow ID is assigned incorrectly for Vouchers that have the same Vendor ID but use different Handling Codes and are processed together during the Pay Cycle. Due to this, the Payment Inquiry page is showing incorrect results when displaying the Vouchers associated to each Check. All of the Vouchers are appearing underneath the 1st Check Number instead of their own respective Check Numbers.
 
STEPS
1. Create 1st Voucher with Handling = RE on the Voucher > Payments page
2. Create 2nd Voucher for the same Vendor from Step 1 with Handling = HD on the Voucher > Payments page
3. Pay the Vouchers through Pay Cycle Manager
4. 2 Checks are printed
5. Inquiry on both Payment Reference ID's through Payment Inquiry
6. For the 1st Payment, the Vouchers For a Payment page displays both Vouchers, which is incorrect. It should display the 1st Voucher.
7. For the 2nd Payment, the Vouchers For a Payment page displays no Vouchers, which is incorrect. It should display the 2nd Voucher.

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