Issue Occured On Non-currency Resources While They Were Migrated
(Doc ID 1912982.1)
Last updated on SEPTEMBER 20, 2023
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 Conversion Management Tool (CMT) (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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |