Payment Freeze Validation Issue In Multi-thread
(Doc ID 2761927.1)
Last updated on MARCH 22, 2021
Applies to:Oracle Financial Services Revenue Management and Billing - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On : 184.108.40.206.0 version
Payment Freeze validation issue in multi-thread
Scenario is one payment event - 1000s of payments - each payment multiple pay segment. To improve performance, we did multi thread by payment but there is a base payment freeze check on every payment freeze. It checks total frozen payments with total tender amount, if is mismatches it inserts a record in pay event exception table i.e. CI_PAY_EVT_EXCP which has payment event as it’s primary key. So when multiple threads throwing this error everything trying to insert into pay event exceptions for same payment event leading to dead lock. And it throws below error:
com.splwg.shared.common.ApplicationError: (Server Message)
Call Sequence: ;CIPPXCER;CIPPEVTV;CIPPPAYF;CIPPPAYO
Program Name: CIPPXCER
Text: Payment Event ID 502595765699 duplicate key error
Description: This field is a key field on a database table. The value as it currently stands is a duplicate of an existing value.
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