My Oracle Support Banner

Adjustment To A Bill In Progress Does Not Affect Balance (Doc ID 1586930.1)

Last updated on JUNE 03, 2022

Applies to:

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


On : BRM 7.4 PS13

The amount in BILL_T is wrong when doing an item adjustment with full amount on an item that belongs to a bill in progress.

After billing, if calculate the Due according to the below formula based on 7.4 document:
  Due = Total - adjusted - disputed - recvd + or - transferred
The due would not be the next cycle charge. The actual Due = next cycle charge which is correct, but not sure how it is calculated.

Due = next cycle charge and it can be calculated using the above formula.

The issue can be reproduced at will with the following steps:
1) Create a product with a monthly cycle forward event:
    $29250 ( with proration, no tax)
    Make a deal and a plan associate with the product.
 2) On Dec 22nd (12/22), create an account, purchase this plan. DOM = 15.
 3) Verify the account has balance $22645.16 in "Billing in progress"
 4) Run following queries:

You will see for the BILL_T,
  current_total =29250
  adjusted = -22645.16
  total_due = 29250
  due = 29250

If we calculate DUE according to the formula
  Due = Total - adjusted - disputed - recvd + or - transferred
The Due for the bill will not equal to 29250.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.