Issue Occured On Non-currency Resources While They Were Migrated (Doc ID 1912982.1)

Last updated on NOVEMBER 10, 2015

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

During migration, non-currency resources are migrated with 2 different validity periods:

 Configuration:

  1. Add the below entry in $PIN_HOME/apps/cmt/Infranet.properties infranet.cmt.deleteExistingBalances = false
  2. Restart services
 
  Steps:
  1. Load an account via CMT tool (there are no balances/subbalances at this point)
  2. Load balance, sub-balance with resource_id = 100040 and balance 500
  (correspoding bal_grp_bals_t and bal_grp_sub_bals_t are created successfully)
  3. Load balance, sub-balance with resource_id = 100041 and balance 800
 
  Actual Behavior:
  ===========
  When infranet.cmt.deleteExistingBalances is set to false,
 

SQL> select bg.poid_id0, bg.realtime_cntr, bgsb.rec_id2, bgsb.rec_id from
  bal_grp_t bg, bal_grp_sub_bals_t bgsb where bg.account_obj_id0 = 438516 and
  bg.poid_id0 = bgsb.obj_id0 order by bg.poid_id0, bgsb.rec_id, bgsb.rec_id;
 
   POID_ID0 REALTIME_CNTR    REC_ID2     REC_ID
  ---------- ------------- ---------- ----------
     450036             0     100041          2
     450036             0        978             3
     450036             0     100040          3
     450036             0     100040          4
 
  Expected Behavior:
  ======================
  When infranet.cmt.deleteExistingBalances is set to false,
  SQL> select bg.poid_id0, bg.realtime_cntr, bgsb.rec_id2, bgsb.rec_id from
  bal_grp_t bg, bal_grp_sub_bals_t bgsb where bg.account_obj_id0 = 422412 and
  bg.poid_id0 = bgsb.obj_id0 order by bg.poid_id0,bgsb.rec_id, bgsb.rec_id;
 
   POID_ID0 REALTIME_CNTR    REC_ID2     REC_ID
  ---------- ------------- ---------- ----------
     433932             6     100041          2
     433932             6     100040          4
     433932             6        978             6

 

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