My Oracle Support Banner

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 2.8.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 2.8.0.0.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)
  Category: 11
  Number: 251
  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.
  Table: CI_PAY_EVT_EXCP
  Field:
 

Solution

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