CMT Generated Duplicate Rec_id Combinations for Bal_grp_sub_bals_t (Doc ID 1947304.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On BRM 7.5 PS4, CMT

The issue seemed to be random and occurred very rarely (only 2 cases for 16k records).

BRM pin_cmt (Conversion Manager) generated duplicate rec_id combinations for bal_grp_sub_bals_t , it was causing record rejection due to unique constraint violation (I_BAL_GRP_SUB_BALS__ID).

Steps to reproduce:

a. Running CMT import command using account creation input XML
b. Run CMT import command again for the same account using Balances XML having large number of balances records
c. Records got rejected (not loaded).

Error in bal_grp_sub_bals_t_<xx>.log:-

Changes

 

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