Large Values In Bal_grp_bals_t.Credit_profile Causes The Rating And Billing Failure (Doc ID 1282493.1)

Last updated on OCTOBER 15, 2012

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.1 and later
Information in this document applies to any platform.
Checked for relevance on 15-Oct-2012

Symptoms

There are records in bal_grp_bals_t which have very large values in field credit_profile. These values seem to be part of a sequence: the more recent is the record in bal_grp_bals_t, the high value is:

select min(bb.credit_profile), max (bb.credit_profile)
from PIN02.BAL_GRP_BALS_T bb
where BB.CREDIT_PROFILE not in
(select CP.REC_ID
from PIN01.CFG_CREDIT_PROFILE_T cp
)

MIN(BB.CREDIT_PROFILE),MAX(BB.CREDIT_PROFILE)
---------------------------------------------
305,345733560



Rating and billing for these accounts fail with the following errors:


E Mon Nov 29 15:16:07 2010 pinapp41 cm_csg:7694 fm_bill_utils_bal_utils.cpp:20941:pinapp41:testnap:32050:-1358374729:1291036567:2890
   fm_bill_utils_credit_thresholds_chk error
   <location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_NOT_FOUND:3>
   <field num=PIN_FLD_CREDIT_LIMIT:14,200 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>
E Mon Nov 29 15:16:07 2010 pinapp41 cm_csg:7694 fm_bill_utils_bal_utils.cpp:1553 1:pinapp41:testnap:32050:-1358374729:1291036567:2890
   fm_bill_utils_apply_balances error
   <location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_NOT_FOUND:3>
   <field num=PIN_FLD_CREDIT_LIMIT:14,200 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>

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