Duplicate Transaction ID for Payment

(Doc ID 2371740.1)

Last updated on MARCH 29, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Goal

The user noticed duplicated Trans_ID present in payment authorization event (event_billing_payment_t table command =2).
The trans_id duplicates occurred only when there was a payment that could not complete so pin_recover picked it, and at same time, someone did the payment via front end. Somehow the trans_id generated was the same for both payments.
The user only noticed a few records with duplicated trans_id for payment a year, and issue is not reproducible in a test environment. 

Solution

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