BRM Upgrade: Item Level Adjustment Doesnt Impact The Monitor Balance For Subscription Level Crtlimit (Doc ID 1359679.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.5.0.0.0 [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.
Checked for relevance on 15 Aug 2014

Symptoms

Item level adjustment does not impact the "/balance_group/monitor" for subscription level credit limit.

Created account and attached subscription and services. Set the credit limit at the subscription level by creating "/balance_group/monitor" at subscription level. Performed item level adjustment, and the "monitor_queue" is not created for the adjustment event. It is not impacting the /balance_group/monitor balance.

Steps to Reproduce
1. Create account with a subscription.
    The subscription should have some services with it.
2. Set the credit limit at the subscription level.
    This means /balance_group/monitor should be attached with subscription level.
3. Do the item level adjustment.
4. Run the pin_monitor_balance.
5. Check whether the adjustment amount is added or not to the monitor balance.

(Note: the scenario works fine if set the credit limit at account level, but only failed if set the credit limit at the subscription level.)

Below is the group and ordered_balgrp objects:

nap(14873)> robj - 0.0.0.1 /group 11003266
# number of field entries allocated 24, used 23
0 PIN_FLD_POID POID [0] 0.0.0.1 /group/sharing/monitor 11003266 2
0 PIN_FLD_CREATED_T TSTAMP [0] (1358774571) Tue Jan 22 00:22:51 2013
0 PIN_FLD_MOD_T TSTAMP [0] (1358774576) Tue Jan 22 00:22:56 2013
0 PIN_FLD_READ_ACCESS STR [0] "S"
0 PIN_FLD_WRITE_ACCESS STR [0] "S"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
0 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group/monitor 11003522 0
0 PIN_FLD_COUNT INT [0] 8
0 PIN_FLD_DESCR STR [0] ""
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1358774575) Tue Jan 22 00:22:55 2013
0 PIN_FLD_NAME STR [0] "Monitor Group - SUB_CE - 11068477"
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_PARENT POID [0] 0.0.0.1 /service/subscription 11068477 0
0 PIN_FLD_STATUS ENUM [0] 10100
0 PIN_FLD_TYPE_STR STR [0] "SUB_CE"
0 PIN_FLD_MEMBERS ARRAY [0] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
1     PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/outroam 11069059 9
0 PIN_FLD_MEMBERS ARRAY [1] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
1     PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/data 11068579 9
0 PIN_FLD_MEMBERS ARRAY [2] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
1     PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/sms 11067901 9
0 PIN_FLD_MEMBERS ARRAY [3] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
1     PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/fax 11068099 9
0 PIN_FLD_MEMBERS ARRAY [4] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
1     PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/vpn 11067619 9
0 PIN_FLD_MEMBERS ARRAY [5] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
1     PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/mcommerce 11069203 8
0 PIN_FLD_MEMBERS ARRAY [6] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
1     PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 11069117 9
0 PIN_FLD_MEMBERS ARRAY [7] allocated 20, used 2
1     PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
1     PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/subscription 11068477 0

 

nap(16763)> robj - 0.0.0.1 /ordered_balgrp 11001922
# number of field entries allocated 20, used 11
0 PIN_FLD_POID POID [0] 0.0.0.1 /ordered_balgrp 11001922 0
0 PIN_FLD_CREATED_T TSTAMP [0] (1358774577) Tue Jan 22 00:22:57 2013
0 PIN_FLD_MOD_T TSTAMP [0] (1358774577) Tue Jan 22 00:22:57 2013
0 PIN_FLD_READ_ACCESS STR [0] "L"
0 PIN_FLD_WRITE_ACCESS STR [0] "L"
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 11068061 0
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1358774577) Tue Jan 22 00:22:57 2013
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/subscription 11068477 0
0 PIN_FLD_ORDERED_BALGROUPS ARRAY [0] allocated 20, used 1
1     PIN_FLD_GROUP_OBJ POID [0] 0.0.0.1 /group/sharing/discounts -1 0
0 PIN_FLD_ORDERED_BALGROUPS ARRAY [1] allocated 20, used 1
1     PIN_FLD_GROUP_OBJ POID [0] 0.0.0.1 /group/sharing/monitor 11003266 0


Pre patch behavior :

The /balance_group/monitor object shows 45$ as the PIN_FLD_CURRENT_BAL and in Customer Center Running total is 45$.

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