My Oracle Support Banner

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 FEBRUARY 03, 2019

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

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
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.