Adjusted Taxes Counted Twice, Once During Corrective Billing, Once During Final Billing

(Doc ID 1637086.1)

Last updated on AUGUST 24, 2016

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

This problem happens with Billing and Revenue Management (BRM) 7.5 PS4 + patch 17543970.

When Rerating happens, followed by Corrective Billing, the taxes are adjusted twice, once during the Corrective Billing, and another time during Final Billing.

The scenario is :

  1. 01/Jan: Create account

  2. 01/Jan: Purchase a cycle arrear product with bill time tax and a cycle arrear discount

  3. 01/Feb: Run partial bill

  4. 06/Feb: Run final bill (Assuming delay billing period is 5 days)

  5. 07/Feb: Update product rate

  6. 07/Feb: Rerate RC (cycle arrear) event for this account

  7. 07/Feb: Run invoice

  8. 07/Feb: Run corrective bill

  9. 01/Mar: Run partial bill

  10. 06/Mar: Run final bill


It is expected that :


But instead :


T1 and T2 are calculated once more when the March bill is generated. Note that they are allocated to the Feb bill, increasing the total due of Feb bill.

Ex :


  1. On Feb 6th final billing : 100 (CA fees) -10 (discount) + 9 (tax) = 99
  Balance = $99

  2. Rate changed from 100 to 200
  Rerating will result in : -100 +10 -9 + 200 -20 +18 = 198
  Balance = $198

  It is expected that the ARCHIVE_STATUS is set so that these amounts are not picked up in the next Final billing defer taxation calculation.

  3. On March 6th Billing
  $200 -20 +18 = $198

Changes

This problem happens with BRM 7.5 PS4 + patch 17543970

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