Excess Balance Impacts When Sequential Discounting is Enabled (Doc ID 1566794.1)

Last updated on SEPTEMBER 21, 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.

Symptoms

BRM incorrectly rates events while closing shared discounts.

Scenario :

  1. Create account
  2. Create services
    1. Create service S1
    2. Create service S2
    3. Create service S3
    4. Create service S4
  3. Purchase discounts D1 D2 D3 on service S4
  4. Purchase products GP1, GP2 on service S4
  5. Purchase date:  (1348437600) Mon Sep 24 00:00:00 2012  ( purchase_deal opcode date)
  6. Effective date: (1347919200) Tue Sep 18 00:00:00 2012 ( start_t for  discounts/products)
  7. Create /group/sharing with service S4 as owner and D1 D2 D3 discounts,  with S3 S2 S1 as group members and :
    1. Create ordered balance group with opcode PCM_OP_SUBSCRIPTION_ORDERED_BALGRP for service S1, with S4 sharing group
    2. Create ordered balance group with opcode PCM_OP_SUBSCRIPTION_ORDERED_BALGRP for service S2, with S4 sharing group
    3. Create ordered balance group with opcode PCM_OP_SUBSCRIPTION_ORDERED_BALGRP for service S3, with S4 sharing group 
  8. Perform following purchases:
    1. Purchase product P3 on service S1, with cycle fee (discounted on -100% by discount D1 from service S4)
         Purchase date:  (1348437600) Mon Sep 24 00:00:00 2012  ( purchase_deal opcode date)
         Effective date: (1347919200) Tue Sep 18 00:00:00 2012  ( start_t for product)
    2. Purchase product P4 on service S2 , with cycle fee (discounted on -100% by discount D2 from service S4)
         Purchase date:  (1348437600) Mon Sep 24 00:00:00 2012  ( purchase_deal opcode date)
         Effective date: (1347919200) Tue Sep 18 00:00:00 2012  ( start_t for product)
    3.  Purchase product P5 on service S3 , with cycle fee (discounted on -100% by discount D3 from service S4)
         Purchase date:  (1348437600) Mon Sep 24 00:00:00 2012  ( purchase_deal  opcode date)
         Effective date: (1347919200) Tue Sep 18 00:00:00 2012  ( start_t for  product)
  9. Change end_t of product P3 on service S1
       Event date:     (1349992800) Fri Oct 12 00:00:00 2012  ( op_subscription_set_prodinfo opcode date)
       Effective date: (1350079200) Sat Oct 13 00:00:00 2012  (end_t for product)
  10. Change end_t of discounts D1, D2, D3 on service S4
       Event date:     (1349992800) Fri Oct 12 00:00:00 2012  (op_subscription_set_discinfo opcode date)
       Effective date: (1350079200) Sat Oct 13 00:00:00 2012  (end_t for discounts)
  11. Perform following purchases:
    1. Purchase discounts D1' D2' D3' on service S4 (other names, but they are configured exactly the same as D1 D2 D3)
         Purchase date:  (1349992800) Fri Oct 12 00:00:00 2012  ( purchase_deal opcode date)
         Effective date: (1350079200) Sat Oct 13 00:00:00 2012  ( start_t for new discounts)
    2. Purchase product GP3 on service S4
  12. Create /group/sharing with service S4 as owner and D1' D2' D3' discounts, with S3 S2 S1 as group members and:
    1. Add created sharing group to service S1 ordered balance group
    2. Add created sharing group to service S2 ordered balance group
    3. Add created sharing group to service S3 ordered balance group
    4. Change priority for sharing discounts in service S1 ordered balance group (swith place of two PIN_FLD_ORDERED_BALGROUPS)
    5. Change priority for sharing discounts in service S2 ordered balance group (swith place of two PIN_FLD_ORDERED_BALGROUPS)
    6. Change priority for sharing discounts in service S3 ordered balance group (swith place of two PIN_FLD_ORDERED_BALGROUPS)
  13. Purchase product P3 on service S1 , with cycle fee (discounted on -100% by discount D1' from service S4)
       Purchase date:  (1349992800) Fri Oct 12 00:00:00 2012  ( purchase_deal opcode date)
       Effective date: (1350079200) Sat Oct 13 00:00:00 2012  ( start_t for new product)
  14. Close products GP1,GP2 on service S4
       Event date: (1350252000) Mon Oct 15 00:00:00 2012 (change products status to closed with PCM_OP_SUBSCRIPTION_CANCEL_PRODUCT)
  15. Close discounts D1 D2 D3 on service S4
       Event date: (1350252000) Mon Oct 15 00:00:00 2012 (change discounts status to closed with PCM_OP_SUBSCRIPTION_CANCEL_DISCOUNT)
  16. Close product P3 on service S1
       Event date: (1350252000) Mon Oct 15 00:00:00 2012 (change product status to  closed with PCM_OP_SUBSCRIPTION_CANCEL_PRODUCT)

 

Expected Result :

BRM should correctly rate events while closing shared discounts.

Actual Result :

When one closes the 3 discounts on a discount sharing  before  closing the product, the 3 discounts' refunds  are not reflecting the correct amount

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