CMT Generated Duplicate Rec_id Combinations for Bal_grp_sub_bals_t
Last updated on JULY 28, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 7.5.0]
Information in this document applies to any platform.
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:-
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