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

Last updated on APRIL 03, 2024

Applies to:

Symptoms

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.

ACTUAL BEHAVIOR
-------------------
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.

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

STEPS
-----------------------
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.

Cause

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