EAP: Payment Creation creates Duplicate Check Numbers (PYMNT_ID_REF) in PS_PAYMENT_TBL for a Zero Amount Payment (Doc ID 1600940.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

Payment Creation creates Duplicate Check Numbers (PYMNT_ID_REF) in PS_PAYMENT_TBL for a Zero Amount Payment.

STEPS
1) PS_PAYMENT_TBL (1 row):
  PYMNT_ID = 0000000001   PYMNT_ID_REF = 000001

2) External Account
 Change Check# Len form 6 to 10
 Change the Last Ref Number from 0000000001 to 0000000002

3) Create new Voucher and pay it (Express Payment)

4) PS_PAYMENT_TBL (2 rows):
  PYMNT_ID = 0000000002   PYMNT_ID_REF = 0000000003
  PYMNT_ID = 0000000001   PYMNT_ID_REF = 000001
5) Create two Vouchers for the same Vendor -- 1st Voucher +1000 USD, 2nd Voucher -1000 USD

6) Create a Pay Cycle with 'Suppress Zero Amount Check' checked

7) Run the Pay Cycle and pay the Vouchers

8) PS_PAYMENT_TBL (3 rows):
  PYMNT_ID = 0000000003   PYMNT_ID_REF = 0000000003 *** The Payment created is assigned the PYMNT_ID as its Check Payment Reference (PYMNT_ID_REF).
  PYMNT_ID = 0000000002   PYMNT_ID_REF = 0000000003
  PYMNT_ID = 0000000001   PYMNT_ID_REF = 000001

8)Payment inquiry
  Reference 0000000003 shows Payments by Express Payment (Step 3) and the Pay Cycle (Step 7)

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