Montly Cycle Arrear Not Discounted When There Are Several Steps (Doc ID 1267738.1)

Last updated on JANUARY 07, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Information in this document applies to any platform.
Checked for relevance on 06-Feb-2013

Symptoms

If using monthly cycle arrear event to trigger the discount at billing, then discount is getting triggered but the base expression is not getting evaluated and hence no balance impact is happening . See trace below :

Setup :

Products:

P1 - purchase fee 30000Euro
P2 - MCA(montly cycle arrear) of 30000Euro
(Note: The Override Credit Limit check box in the rate plan of P2 should be left UNCHECKED. )
Discounts:

D1 - containing :
purchase fee mapped to discount model DM1

MCA mapped to discount model DM1

D2 - containing :

MCA mapped to discount model DM2
(Note : D1 has higher priority than D2)

Discount Models :
DM1 setup :
Discount Trigger: CONDITION expr: 1.0 > 0
Discount rule configuration :
DRUM expr: 1.0
Tier Type: THRESHOLD
DRUM Type: Charge
Impact/Consume: 1000092
Applied to: Event Owner
Percentage: -100
BASE expr: TOTALC
THRESHOLD_TO expr: Infinity
THRESHOLD_From expr: 0

DM2 setup :
Trigger: CONDITION expr: 1.0 > 0
Discount rule :
DRUM expr: 0-BAL(1000092)
Tier Type: THRESHOLD
DRUM Type: Quantity (mTotalQ)

Tier1

Impact/Consume: 978 - Euro
Applied to: Event Owner
Percentage: -100
BASE expr: Bal(1000092)
THRESHOLD_TO expr: 15000
THRESHOLD_From expr: 0

Tier2

Impact/Consume: 978 - Euro
Applied to: Event Owner
Percentage: -100
BASE expr: (0-(Bal(1000092)+15000))*0.02
THRESHOLD_TO expr: 25000
THRESHOLD_From expr: 15000

Tier3

Impact/Consume: 978 - Euro
Applied to: Event Owner
Percentage: -100
BASE expr: (0-(Bal(1000092)+25000))*0.03-200
THRESHOLD_TO expr: 40000
THRESHOLD_From expr: 25000

Tier4

Impact/Consume: 978 - Euro
Applied to: Event Owner
Percentage: -100
BASE expr: (0-(Bal(1000092)+40000))*0.06-650
THRESHOLD_TO expr: 70000
THRESHOLD_From expr: 40000

Tier5

Impact/Consume: 978 - Euro
Applied to: Event Owner
Percentage: -100
BASE expr: (0-(Bal(1000092)+70000))*0.09-2450
THRESHOLD_TO expr: 100000
THRESHOLD_From expr: 70000


Scenario :

  1. create deal_1 with P1 and P2 and deal_2 with D1 and D2, and commit to database
  2. create account purchasing the above 2 deals
  3. check balance of 1000092, it is -30000
  4. goto billing date and run billing for this account
  5. now check the discount trace, the discount is not applied as per the configuration in DM2:

 

evalDiscountObjs: discount model: (DM2)
Discount Object Mode: 801 Discount Object: 4470169

evalConfigurations() obj/type:4470169/2, config:100060,
DM2/DM2, master: 100001, discountMode 0
mTotalC = 30000.000, mTotalQ = 1.00000000
INFO: UTC offset in seconds is 0
CONDITION expr: BAL(1000092), result: -30000.000
evalRule(): Rule Id: 100060, Code: DM2
INFO: UTC offset in seconds is 0
DRUM expr: 0-BAL(1000092), result: 30000.000
evalRule(): step Id: 100066 Tier Type: THRESHOLD
THRESHOLD_TO expr: 15000, result: 15000
evalRule(): step Id: 100065 Tier Type: THRESHOLD
THRESHOLD_TO expr: 25000, result: 25000
evalRule(): step Id: 100064 Tier Type: THRESHOLD
THRESHOLD_TO expr: 40000, result: 40000  <-- it is supposed to provide discount here
looping on packet id: 1
looping on packet id: 2
Ignored! Same object type
----- FINAL EDR Pckts-----
Type/valid/Index/srcIndex/From/To/C/Q/isSplit:
1/1/1/0/0/1.00000000/30000.000/1.00000000/0
Type/valid/Index/srcIndex/From/To/C/Q/isSplit:
2/1/2/1/0/1.00000000/30000.000/-30000.000/0



Note : If one enables the 'override credit limit' flag in the rate plan of the MCA, then the base expression in the discount tier gets evaluated correctly and impacts the balance as expected. However, this is only a workaround.

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