End Relative Billing Cycles Does Not Work (Doc ID 863887.1)

Last updated on NOVEMBER 11, 2013

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.1 [Release 7.3.0]
Information in this document applies to any platform.
Checked for relevance on 26-Mar-2012


Symptoms

When configuring pipeline discount for balance impact on a resource at the end of two relative Billing Cycles, system does not set the expiration date of the granted resource correctly  after 2 billing cycles.

The problem is that the resource is impacted with the valid_to date valid to infinity only and not with an expiration date in 2 billing cycles.

Steps To Reproduce:

1. Create a simple GSM TEL plan with free second (ResourceID = 1000095) = 36
2. Create a billing time discount deal "Dropped Call Transfer - OOB" with Discount Model = "DrCallBTD":
    - Discount Trigger is Alway True (e.g. 1 > 0)
    - Discount Rule:
         Drum Expression = 1
         Rule Type = Tiered
         Drum Type = Quantity
    - Discount Step:
         Threshold From = 0
         Threshold To (Expression) = Bal(1000095)
    - Impact/Consume:
         Impact/Consume = 1000001
         Applied To: Event Owner
         Percentage = -100%
         Impact - Start: Immediately
         End: Relative 2 Billling Cycles
3. Restart Infranet/pipeline services
4. Create an account with the GSM TEL plan
5. Purchase the discount deal "Dropped Call Transfer - OOB" for the account
6. Verifiy the balance group from cm.pinlog:

    op_bal_get_balances return flist
# number of field entries allocated 20, used 7
0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 3095069 2
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 3094509 0
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 3094557 0
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1244624418) Wed Jun 10 02:00:18 2009
0 PIN_FLD_BALANCES ARRAY [978] allocated 20, used 7
1   PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1   PIN_FLD_NEXT_BAL DECIMAL [0] 0
1   PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1   PIN_FLD_CURRENT_BAL DECIMAL [0] 10
1   PIN_FLD_CREDIT_LIMIT DECIMAL [0] NULL
1   PIN_FLD_CREDIT_FLOOR DECIMAL [0] NULL
1   PIN_FLD_CREDIT_THRESHOLDS INT [0] 0
0 PIN_FLD_REALTIME_CNTR INT [0] 2
0 PIN_FLD_BALANCES ARRAY [1000095] allocated 20, used 7
1   PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1   PIN_FLD_NEXT_BAL DECIMAL [0] 0
1   PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1   PIN_FLD_CURRENT_BAL DECIMAL [0] 36
1   PIN_FLD_CREDIT_LIMIT DECIMAL [0] 0
1   PIN_FLD_CREDIT_FLOOR DECIMAL [0] NULL
1   PIN_FLD_CREDIT_THRESHOLDS INT [0] 0

7. Advance one month and run billing, and verify that the resource 1000001 has PIN_FLD_VALID_TO set to null.

nap(29002)> robj - 0.0.0.1 /balance_group 3095069
# number of field entries allocated 20, used 15
0 PIN_FLD_POID POID [0] 0.0.0.1 /balance_group 3095069 5
0 PIN_FLD_CREATED_T TSTAMP [0] (1244624418) Wed Jun 10 02:00:18 2009
0 PIN_FLD_MOD_T TSTAMP [0] (1247212808) Fri Jul 10 01:00:08 2009
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 3094509 0
0 PIN_FLD_BATCH_CNTR INT [0] 0
0 PIN_FLD_BILLINFO_OBJ POID [0] 0.0.0.1 /billinfo 3094557 0
0 PIN_FLD_EFFECTIVE_T TSTAMP [0] (1244624418) Wed Jun 10 02:00:18 2009
0 PIN_FLD_NAME STR [0] "Balance Group<Account>"
0 PIN_FLD_OBJECT_CACHE_TYPE ENUM [0] 0
0 PIN_FLD_REALTIME_CNTR INT [0] 6
0 PIN_FLD_BALANCES ARRAY [978] allocated 20, used 5
1   PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1   PIN_FLD_CREDIT_PROFILE INT [0] 0
1   PIN_FLD_NEXT_BAL DECIMAL [0] 0
1   PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1   PIN_FLD_SUB_BALANCES ARRAY [0] allocated 20, used 10
2     PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2     PIN_FLD_CURRENT_BAL DECIMAL [0] 20
2     PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2     PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 3093277 0
2     PIN_FLD_NEXT_BAL DECIMAL [0] 0
2     PIN_FLD_ROLLOVER_DATA INT [0] 0
2     PIN_FLD_VALID_FROM TSTAMP [0] (1244617200) Wed Jun 10 00:00:00 2009
2     PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2     PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
2     PIN_FLD_VALID_TO_DETAILS INT [0] 0
0 PIN_FLD_BALANCES ARRAY [1000001] allocated 20, used 5
1   PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1   PIN_FLD_CREDIT_PROFILE INT [0] 2
1   PIN_FLD_NEXT_BAL DECIMAL [0] 0
1   PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1   PIN_FLD_SUB_BALANCES ARRAY [6] allocated 20, used 10
2     PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2     PIN_FLD_CURRENT_BAL DECIMAL [0] -36
2     PIN_FLD_DELAYED_BAL DECIMAL [0] 36
2     PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_discount 3097294 0
2     PIN_FLD_NEXT_BAL DECIMAL [0] 0
2     PIN_FLD_ROLLOVER_DATA INT [0] 0
2     PIN_FLD_VALID_FROM TSTAMP [0] (1247209199) Thu Jul 9 23:59:59 2009
2     PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2     PIN_FLD_VALID_TO TSTAMP [0] (0) <null>
2     PIN_FLD_VALID_TO_DETAILS INT [0] 0
0 PIN_FLD_BALANCES ARRAY [1000095] allocated 20, used 6
1   PIN_FLD_CONSUMPTION_RULE ENUM [0] 0
1   PIN_FLD_CREDIT_PROFILE INT [0] 2
1   PIN_FLD_NEXT_BAL DECIMAL [0] 0
1   PIN_FLD_RESERVED_AMOUNT DECIMAL [0] 0
1   PIN_FLD_SUB_BALANCES ARRAY [2] allocated 20, used 10
2     PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2     PIN_FLD_CURRENT_BAL DECIMAL [0] 36
2     PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2     PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 3093277 0
2     PIN_FLD_NEXT_BAL DECIMAL [0] 0
2     PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2     PIN_FLD_VALID_FROM TSTAMP [0] (1244617200) Wed Jun 10 00:00:00 2009
2     PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2     PIN_FLD_VALID_TO TSTAMP [0] (1247209200) Fri Jul 10 00:00:00 2009
2     PIN_FLD_VALID_TO_DETAILS INT [0] 0
1   PIN_FLD_SUB_BALANCES ARRAY [4] allocated 20, used 10
2     PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2     PIN_FLD_CURRENT_BAL DECIMAL [0] 36
2     PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2     PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 3093277 1
2     PIN_FLD_NEXT_BAL DECIMAL [0] 0
2     PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2     PIN_FLD_VALID_FROM TSTAMP [0] (1247209200) Fri Jul 10 00:00:00 2009
2     PIN_FLD_VALID_FROM_DETAILS INT [0] 0
2     PIN_FLD_VALID_TO TSTAMP [0] (1249887600) Mon Aug 10 00:00:00 2009
2     PIN_FLD_VALID_TO_DETAILS INT [0] 0


Expected Result:
ResourceID 1000001 should have PIN_FLD_VALID_TO set to two billing cycle

Actual Result:
ResourceID 1000001 have PIN_FLD_VALID_TO set to null


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