EAP: Duplicate Payment Reference generated for the same Bank, Bank Account and Payment Method when creating Payment through Create Manual Payment > Update Payment Worksheet page (Doc ID 1939554.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

Duplicate Payment Reference generated for the same Bank, Bank Account and Payment Method when creating a Payment through the Create Manual Payment > Update Payment Worksheet page.

STEPS
1) External Accounts > Payment Methods page setup
Bank Account: CHCK
Payment Method: Manual Check
Last Ref Number: 0000009095

2) On the Create Manual Payment > Update Payment Worksheet page, create 1st Manual Payment
Bank Account: CHCK
Payment Ref: 009096 -- Which is entered manually

3) External Accounts > Payment Methods page
Bank Account: CHCK
Payment Method: Manual Check
Last Ref Number: 0000009095 -- The system did not update the Last Ref Number

4) On the Create Manual Payment > Update Payment Worksheet page, create 2nd Manual Payment
Bank Account: CHCK
Payment Ref: NEXT

Once the page is saved, Payment Ref assigned is 009096, which is a duplicate reference of the 1st Manual Payment

5) External Accounts > Payment Methods page
Bank Account: CHCK
Payment Method: Manual Check
Last Ref Number: 0000009096 -- Last Ref Number is updated

6) Payment Inquiry and PS_PAYMENT_TBL
Have the same Payment Reference ID for the same Bank, the same Bank Account and the same Payment Method, which is wrong

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