When CLOSED, Future Shared Subscription is Creating Extra Free Resources Bucket. (Doc ID 760757.1)

Last updated on JANUARY 26, 2009

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.0.0.0
This problem can occur on any platform.

Symptoms

-- Problem Statement:
Future shared subscription with cycle fee product is creating extra sub balance bucket with
ZERO amount for free resources when CLOSED.

-- Steps To Reproduce:

NOTE: Date format is used for all the steps is MM/DD/YYYY

1. Create a GSM telephony service account(Acct1) on 09/05/2009.
2. Create a sharing service to the above account,
This should have a product with purchase fee, cycle fee with -200 resources per cycle

PS: time_stamp_rounding is disabled.
3. Create two members accounts for same type GSM service.
4. Add the above member accounts to the above shared service created in Step 2.
5. Pass the CDR's for Parent account(Acct1)to consume all the above free resources on 9/25/2009.
6. Set the future end dates to sharing service purchased_product(purchase/cycle/usage end_t) on
10/01/2009 to 10/03/2009 23:59:59 by calling set_prodinfo opcode
7. Close the sharing service(status=10103) on 10/04/2009,It is chaging the status of
purchased_product active to closed and again refunding the cycle fee from 10/03/2009 23:59:59 to 10/03/2009 23:59:59 with scale as ZERO.

This should not refund the cycle fee since already refunded in step 6. It should change only the status of purchased_product to closed(3).  Due to the new cycle fee refund it is creating extra ZERO amount sub balance bucket for the free resource.

This step is creating extra balance bucket from 10/03/2009 23:59:59 to 10/05/2009 00:00:00
Please find the details below.

0 PIN_FLD_BALANCES ARRAY [2000005] 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 [8] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 1680
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 211373 1
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 1073807360
2 PIN_FLD_VALID_FROM TSTAMP [0] (1220565841) Fri Sep 5 00:04:01 2009
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 1
2 PIN_FLD_VALID_TO TSTAMP [0] (1223071199) Fri Oct 3 23:59:59 2009
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0
1 PIN_FLD_SUB_BALANCES ARRAY [10] allocated 20, used 10
2 PIN_FLD_CONTRIBUTOR_STR STR [0] ""
2 PIN_FLD_CURRENT_BAL DECIMAL [0] 0
2 PIN_FLD_DELAYED_BAL DECIMAL [0] 0
2 PIN_FLD_GRANTOR_OBJ POID [0] 0.0.0.1 /purchased_product 211373 3
2 PIN_FLD_NEXT_BAL DECIMAL [0] 0
2 PIN_FLD_ROLLOVER_DATA INT [0] 0
2 PIN_FLD_VALID_FROM TSTAMP [0] (1223071199) Fri Oct 3 23:59:59 2009
2 PIN_FLD_VALID_FROM_DETAILS INT [0] 1
2 PIN_FLD_VALID_TO TSTAMP [0] (1223157600) Sun Oct 5 00:00:00 2009
2 PIN_FLD_VALID_TO_DETAILS INT [0] 0


An extra sub balance bucket is not required with ZERO amount from 10/03/2009 23:59:59 to 10/05/2009 00:00:00. Step 7 of changing the status to closed should suffice.

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