Inconsistent Rating Behavior When Using Both Custom Impact Categories And * (Asterisk) (Doc ID 754716.1)

Last updated on SEPTEMBER 13, 2012

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 13-Sep-2012

Symptoms

-- Problem Statement:
When using "Quantity discount Bracket -> Based on: Resource Balance" and having only custom impact categories in associated rates, the rating of a CDR overlapping the bundle (starting in the bundle and ending out of the bundle) is correctly done.

With that same configuration, when mixing custom impact categories and * (asterik) in associated rates is done, the rating of a CDR overlapping the bundle (starting in the bundle and ending out of the bundle) is not correctly done.

-- Steps To Reproduce:

Below scenarios should help understand the issue :
Case(1) Using only custom impact categories

(a)created a product for /service/telco/gsm/telephony :

event 1 :
Monthly Cycle Forward ,
resource = 1000007 ,
impact category = *
scaled amount = -4000

event 2 :
Real Time Telco GSM session ,
rate plan selector ,
defined rate plan with Quantity Discount Bracket, based on resource balance of 1000007 .
impact (no min - 0):
resource = 840 , impact category= US_US , some impact per minute
resource = 1000007 , impact category= US_US , scaled amount = 1 per second
resource = 1000008 , impact category= US_US , some impact per minute
impact (0 - no max):
resource = 840 , impact category= US_US , some impact per minute


(b) create account on sep 26

(c) pin_virtual_time to 27 sep

(d) input flist for pcm_op_act_load_session

0 PIN_FLD_POID POID [0] 0.0.0.1 /account 222321 0
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 224113 7
0 PIN_FLD_INHERITED_INFO SUBSTRUCT [0] allocated 20, used 3
1 PIN_FLD_USAGE_TYPE STR [0] "1389"
1 PIN_FLD_TELCO_INFO SUBSTRUCT [0] allocated 20, used 6
2 PIN_FLD_USAGE_CLASS STR [0] "Normal"
2 PIN_FLD_NETWORK_SESSION_ID STR [0] "TRANSIDOCT1111991121"
2 PIN_FLD_SVC_TYPE STR [0] "VOICE"
2 PIN_FLD_CALLED_TO STR [0] "003311"
2 PIN_FLD_SECONDARY_MSID STR [0] "2213499921301"
2 PIN_FLD_PRIMARY_MSID STR [0] "021-20080926-213727-0-20536-1-blrsnts3"
1 PIN_FLD_GSM_INFO SUBSTRUCT [0] allocated 20, used 1
2 PIN_FLD_DIRECTION ENUM [0] 0
0 PIN_FLD_PROGRAM_NAME STR [0] "VOICE  rating"
0 PIN_FLD_START_T TSTAMP [0] (1222497001) Sat Sep 27 12:00:01 2008
0 PIN_FLD_OBJ_TYPE STR [0] "/telco/gsm"
0 PIN_FLD_END_T TSTAMP [0] (1222502001) Sat Sep 27 13:23:21 2008


 

nap(20544)> xop 161 0 1
xop: opcode 161, flags 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 222321 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 12
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 20, used 18
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 222321 8
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 222033 0
2 PIN_FLD_TAX_CODE STR [0] ""
2 PIN_FLD_RATE_OBJ POID [0] 0.0.0.1 /rate 224081 1
2 PIN_FLD_RATE_TAG STR [0] "New Rate"
2 PIN_FLD_IMPACT_CATEGORY STR [0] "US_to_US"
2 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 222449 1
2 PIN_FLD_LINEAGE STR [0] NULL str ptr
2 PIN_FLD_GL_ID INT [0] 0
2 PIN_FLD_QUANTITY DECIMAL [0] 4000.00000000 <---------- this is correct
2 PIN_FLD_IMPACT_TYPE ENUM [0] 1
2 PIN_FLD_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_PERCENT DECIMAL [0] 1
2 PIN_FLD_AMOUNT DECIMAL [0] 6.67
2 PIN_FLD_RESOURCE_ID INT [0] 840
2 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 223601 2
2 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/misc 221425 0
1 PIN_FLD_BAL_IMPACTS ARRAY [1] allocated 20, used 18
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 222321 8
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 222033 0
2 PIN_FLD_TAX_CODE STR [0] ""
2 PIN_FLD_RATE_OBJ POID [0] 0.0.0.1 /rate 224081 1
2 PIN_FLD_RATE_TAG STR [0] "New Rate"
2 PIN_FLD_IMPACT_CATEGORY STR [0] "US_to_US"
2 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 222449 1
2 PIN_FLD_LINEAGE STR [0] NULL str ptr
2 PIN_FLD_GL_ID INT [0] 0
2 PIN_FLD_QUANTITY DECIMAL [0] 4000.00000000
2 PIN_FLD_IMPACT_TYPE ENUM [0] 1
2 PIN_FLD_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_PERCENT DECIMAL [0] 1
2 PIN_FLD_AMOUNT DECIMAL [0] 4000
2 PIN_FLD_RESOURCE_ID INT [0] 1000007
2 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 223601 2
2 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/misc 221425 0
1 PIN_FLD_BAL_IMPACTS ARRAY [2] allocated 20, used 18
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 222321 8
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 222033 0
2 PIN_FLD_TAX_CODE STR [0] ""
2 PIN_FLD_RATE_OBJ POID [0] 0.0.0.1 /rate 224081 1
2 PIN_FLD_RATE_TAG STR [0] "New Rate"
2 PIN_FLD_IMPACT_CATEGORY STR [0] "US_to_US"
2 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 222449 1
2 PIN_FLD_LINEAGE STR [0] NULL str ptr
2 PIN_FLD_GL_ID INT [0] 0
2 PIN_FLD_QUANTITY DECIMAL [0] 4000.00000000
2 PIN_FLD_IMPACT_TYPE ENUM [0] 1
2 PIN_FLD_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_PERCENT DECIMAL [0] 1
2 PIN_FLD_AMOUNT DECIMAL [0] 23.33333
2 PIN_FLD_RESOURCE_ID INT [0] 1000008
2 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 223601 2
2 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/misc 221425 0
1 PIN_FLD_BAL_IMPACTS ARRAY [3] allocated 20, used 18
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 222321 8
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 222033 0
2 PIN_FLD_TAX_CODE STR [0] ""
2 PIN_FLD_RATE_OBJ POID [0] 0.0.0.1 /rate 224081 1
2 PIN_FLD_RATE_TAG STR [0] "New Rate"
2 PIN_FLD_IMPACT_CATEGORY STR [0] "US_to_US"
2 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 222449 1
2 PIN_FLD_LINEAGE STR [0] NULL str ptr
2 PIN_FLD_GL_ID INT [0] 0
2 PIN_FLD_QUANTITY DECIMAL [0] 1000.00000000
2 PIN_FLD_IMPACT_TYPE ENUM [0] 1
2 PIN_FLD_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_PERCENT DECIMAL [0] 1
2 PIN_FLD_AMOUNT DECIMAL [0] 33.33
2 PIN_FLD_RESOURCE_ID INT [0] 840
2 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 223601 2
2 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/misc 221425 0
1 PIN_FLD_SUB_BAL_IMPACTS ARRAY [0] allocated 20, used 3
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 223601 2
2 PIN_FLD_RESOURCE_ID INT [0] 840
2 PIN_FLD_SUB_BALANCES ARRAY [0] allocated 20, used 8
3 PIN_FLD_VALID_FROM TSTAMP [0] (1222497001) Sat Sep 27 12:00:01 2008
3 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
3 PIN_FLD_ROLLOVER_DATA INT [0] 0
3 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
3 PIN_FLD_VALID_TO_DETAILS INT [0] 0
3 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 222449 1
3 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
3 PIN_FLD_AMOUNT DECIMAL [0] 40.00
1 PIN_FLD_SUB_BAL_IMPACTS ARRAY [1] allocated 20, used 3
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 223601 2
2 PIN_FLD_RESOURCE_ID INT [0] 1000007
2 PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 3
3 PIN_FLD_AMOUNT DECIMAL [0] 4000
3 PIN_FLD_VALID_FROM TSTAMP [0] (0) <null>
3 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
1 PIN_FLD_SUB_BAL_IMPACTS ARRAY [2] allocated 20, used 3
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 223601 2
2 PIN_FLD_RESOURCE_ID INT [0] 1000008
2 PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 8
3 PIN_FLD_VALID_FROM TSTAMP [0] (1222497001) Sat Sep 27 12:00:01 2008
3 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
3 PIN_FLD_ROLLOVER_DATA INT [0] 0
3 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
3 PIN_FLD_VALID_TO_DETAILS INT [0] 0
3 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 222449 1
3 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
3 PIN_FLD_AMOUNT DECIMAL [0] 23.33333
1 PIN_FLD_UNRATED_QUANTITY DECIMAL [0] 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 224113 7
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 222321 0
1 PIN_FLD_RATING_STATUS ENUM [0] 0
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/session/telco/gsm 248911840342667249 0
nap(20544)>

 

NOTE :
Total quantity rated is 5000 secs.
Notice that first 4000 secs is rated for (no min - 0) and then 1000 is rated for (0 - no max)



case (2) mixing custom impact category and *

product configuration changes here :

event 2 :
Real Time Telco GSM session ,
rate plan selector ,
defined rate plan with Quantity Discount Bracket, based on resource balance of 1000007 .
impact (no min - 0):
resource = 840 , impact category= * , some impact per minute
resource = 1000007 , impact category= * , scaled amount = 1 per second
resource = 1000008 , impact category= US_US , some impact per minute
impact (0 - no max):
resource = 840 , impact category= US_US , some impact per minute


(a) create account on sep 26
(b) pin_virtual_time to 27 sep
(c) flist for pcm_op_act_load_session

0 PIN_FLD_POID POID [0] 0.0.0.1 /account 221457 0
0 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 224401 7
0 PIN_FLD_INHERITED_INFO SUBSTRUCT [0] allocated 20, used 3
1 PIN_FLD_USAGE_TYPE STR [0] "1389"
1 PIN_FLD_TELCO_INFO SUBSTRUCT [0] allocated 20, used 6
2 PIN_FLD_USAGE_CLASS STR [0] "Normal"
2 PIN_FLD_NETWORK_SESSION_ID STR [0] "TRANSIDOCT1111991121"
2 PIN_FLD_SVC_TYPE STR [0] "VOICE"
2 PIN_FLD_CALLED_TO STR [0] "003311"
2 PIN_FLD_SECONDARY_MSID STR [0] "2213499921301"
2 PIN_FLD_PRIMARY_MSID STR [0] "260-20080926-212343-0-20502-1-blrsnts3"
1 PIN_FLD_GSM_INFO SUBSTRUCT [0] allocated 20, used 1
2 PIN_FLD_DIRECTION ENUM [0] 0
0 PIN_FLD_PROGRAM_NAME STR [0] "VOICE activity rating"
0 PIN_FLD_START_T TSTAMP [0] (1222497001) Sat Sep 27 12:00:01 2008
0 PIN_FLD_OBJ_TYPE STR [0] "/telco/gsm"
0 PIN_FLD_END_T TSTAMP [0] (1222502001) Sat Sep 27 13:23:21 2008


(d) output flist :

op_act_load_session result flist
# number of field entries allocated 20, used 2
0 PIN_FLD_POID POID [0] 0.0.0.1 /account 221457 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 11
1 PIN_FLD_BAL_IMPACTS ARRAY [0] allocated 20, used 18
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 221457 8
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 221473 1
2 PIN_FLD_TAX_CODE STR [0] ""
2 PIN_FLD_RATE_OBJ POID [0] 0.0.0.1 /rate 223521 4
2 PIN_FLD_RATE_TAG STR [0] "New Rate"
2 PIN_FLD_IMPACT_CATEGORY STR [0] "US_to_US"
2 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 221585 1
2 PIN_FLD_LINEAGE STR [0] NULL str ptr
2 PIN_FLD_GL_ID INT [0] 0
2 PIN_FLD_QUANTITY DECIMAL [0] 5000.00000000 <----------- this is wrong
2 PIN_FLD_IMPACT_TYPE ENUM [0] 1
2 PIN_FLD_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_PERCENT DECIMAL [0] 1
2 PIN_FLD_AMOUNT DECIMAL [0] 29.16667
2 PIN_FLD_RESOURCE_ID INT [0] 1000008
2 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 225041 2
2 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/misc 222865 0
1 PIN_FLD_BAL_IMPACTS ARRAY [1] allocated 20, used 18
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 221457 8
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 221473 1
2 PIN_FLD_TAX_CODE STR [0] ""
2 PIN_FLD_RATE_OBJ POID [0] 0.0.0.1 /rate 223521 4
2 PIN_FLD_RATE_TAG STR [0] "New Rate"
2 PIN_FLD_IMPACT_CATEGORY STR [0] "US_to_US"
2 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 221585 1
2 PIN_FLD_LINEAGE STR [0] NULL str ptr
2 PIN_FLD_GL_ID INT [0] 0
2 PIN_FLD_QUANTITY DECIMAL [0] 5000.00000000
2 PIN_FLD_IMPACT_TYPE ENUM [0] 1
2 PIN_FLD_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_PERCENT DECIMAL [0] 1
2 PIN_FLD_AMOUNT DECIMAL [0] 8.33
2 PIN_FLD_RESOURCE_ID INT [0] 840
2 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 225041 2
2 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/misc 222865 0
1 PIN_FLD_BAL_IMPACTS ARRAY [2] allocated 20, used 18
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 221457 8
2 PIN_FLD_PRODUCT_OBJ POID [0] 0.0.0.1 /product 221473 1
2 PIN_FLD_TAX_CODE STR [0] ""
2 PIN_FLD_RATE_OBJ POID [0] 0.0.0.1 /rate 223521 4
2 PIN_FLD_RATE_TAG STR [0] "New Rate"
2 PIN_FLD_IMPACT_CATEGORY STR [0] "US_to_US"
2 PIN_FLD_OFFERING_OBJ POID [0] 0.0.0.1 /purchased_product 221585 1
2 PIN_FLD_LINEAGE STR [0] NULL str ptr
2 PIN_FLD_GL_ID INT [0] 0
2 PIN_FLD_QUANTITY DECIMAL [0] 5000.00000000
2 PIN_FLD_IMPACT_TYPE ENUM [0] 1
2 PIN_FLD_DISCOUNT DECIMAL [0] 0
2 PIN_FLD_PERCENT DECIMAL [0] 1
2 PIN_FLD_AMOUNT DECIMAL [0] 5000
2 PIN_FLD_RESOURCE_ID INT [0] 1000007
2 PIN_FLD_AMOUNT_DEFERRED DECIMAL [0] 0
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 225041 2
2 PIN_FLD_ITEM_OBJ POID [0] 0.0.0.1 /item/misc 222865 0
1 PIN_FLD_SUB_BAL_IMPACTS ARRAY [0] allocated 20, used 3
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 225041 2
2 PIN_FLD_RESOURCE_ID INT [0] 1000008
2 PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 8
3 PIN_FLD_VALID_FROM TSTAMP [0] (1222497001) Sat Sep 27 12:00:01 2008
3 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
3 PIN_FLD_ROLLOVER_DATA INT [0] 0
3 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
3 PIN_FLD_VALID_TO_DETAILS INT [0] 0
3 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 221585 1
3 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
3 PIN_FLD_AMOUNT DECIMAL [0] 29.16667
1 PIN_FLD_SUB_BAL_IMPACTS ARRAY [1] allocated 20, used 3
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 225041 2
2 PIN_FLD_RESOURCE_ID INT [0] 840
2 PIN_FLD_SUB_BALANCES ARRAY [0] allocated 20, used 8
3 PIN_FLD_VALID_FROM TSTAMP [0] (1222497001) Sat Sep 27 12:00:01 2008
3 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
3 PIN_FLD_ROLLOVER_DATA INT [0] 0
3 PIN_FLD_VALID_FROM_DETAILS INT [0] 0
3 PIN_FLD_VALID_TO_DETAILS INT [0] 0
3 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 221585 1
3 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
3 PIN_FLD_AMOUNT DECIMAL [0] 8.33
1 PIN_FLD_SUB_BAL_IMPACTS ARRAY [2] allocated 20, used 3
2 PIN_FLD_BAL_GRP_OBJ POID [0] 0.0.0.1 /balance_group 225041 2
2 PIN_FLD_RESOURCE_ID INT [0] 1000007
2 PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 3
3 PIN_FLD_AMOUNT DECIMAL [0] 5000
3 PIN_FLD_VALID_FROM TSTAMP [0] (0) <null>
3 PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
1 PIN_FLD_UNRATED_QUANTITY DECIMAL [0] 0
1 PIN_FLD_SERVICE_OBJ POID [0] 0.0.0.1 /service/telco/gsm/telephony 224401 7
1 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 221457 0
1 PIN_FLD_RATING_STATUS ENUM [0] 0
1 PIN_FLD_POID POID [0] 0.0.0.1 /event/session/telco/gsm 248911840342665809 0



Notice that quantity of 5000 has been rated, instead of 4000 and 1000.

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