Incorrect Refund Generated After Closing Products And Discounts (Doc ID 1985768.1)

Last updated on NOVEMBER 25, 2015

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On :  BRM 7.5.0.5.0 version, Subscription Management

In a customer business use case, it is seen that after cancellation of products and discount on an account, there is an additional refund that is created.


Setup:

Scenario:

  1. 20.10.2014: Create /account with DOM 1 and /service
  2. 20.10.2014: Purchase /product P1 with cycle forward monthly charge with start date 1.11.2014
  3. 20.10.2014: Purchase /discount D1 with -100% discount on P1, and buy another /product P2 with cycle forward monthly charge, both with start date 1.11.2014
  4. 20.10.2014: Change billing day (using opcode PCM_OP_CUST_SET_BILLINFO) to 14 and set suppression cycles left to 1 (PCM_OP_BILL_SET_BILL_SUPPRESSION). This step is done as per a custom business requirement, so the next biling will not close the bill, and to avoid short cycle 1.11 - 14.11
  5. 01.11.2014: Execute Billing. This should trigger event (start_t 01.11.2014, end_t 14.11.2014) with two balance impacts, which sums to 0, eg. 27.83 and -27.83
  6. 05.11.2014: Purchase -100% discount D2 with lower priority than D1 with starting date 14.11.2014. This triggers two events (start_t 05.11.2014, end_t 14.11.2014) with balance impacts, which sums to 0, eg. 19.27 and -19.27.
  7. 08.11.2014: Close all products(p1 and p2) and discount D1 (D2 is left activated) with end_t in past 01.11.2014 (start of the current cycle). This means that in this cycle, there are no active products which could charge customer. Instead what is observed is that, after closing products P1, P2 and discount D1, there is another event with only one impact of -27.83. This is the issue.

BUSINESS IMPACT:

This issue results in negative amount on customer's bills which in turn causes lower company's income.

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