Payment Txns Processing More Than Once Aka Duplicate Payment Postings (Doc ID 2985658.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Payment Transactions Processing more than once aka Duplicate Payment Postings - PMT_REFERENCE

User noticed that OFSLL is processing/posting the Payment Txns more than once especially for those payments that came in during the EOD window.

E.g.: On 08/03/2023 Paymentus sent a Payment for 16.25$ and received a timeout exception twice and on the 3rd attempt they got successful 201 code.
But in OFSLL this payment got posted 3 times as opposed to once.


EXPECTED BEHAVIOR
-----------------------
Need to avoid duplicate posting, so user like to restrict the payment based on the PMT_REFERENCE. If the PMT_REFERENCE is not null, then check if there is already a Payment with that reference and error out the transaction.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an account
2. Post payment on the account through Account payment posting web service
3. Verify that payment posted successfully
4. Post same payment on the account through Account payment posting web service
5. Verify that payment not posted on the account as already a combination of pmt_acc_nbr, pmt_dt, pmt_amt, pmt_reference and pmt_cur_currency_code is present in payments table.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have the payment posting duplicate check and payment will get posted multiple times for the payment received during EOD window from paymentus.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.