My Oracle Support Banner

Event is Included In Incorrect Bill (Doc ID 1633315.1)

Last updated on MAY 11, 2021

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


On : version, Core Billing

Problem :

Product purchased (during billing delay) at 00:00 Hrs generates event that is assigned to next bill rather than previous bill.

Setup :

Scenario :

  1. Create account with billing dom (day of month) 1, on 01 Jan.  Bill cycle  is 01 Jan to 01 Feb. Let us associate bill B1 for this.
  2. Purchase service S1.
  3. Purchase product P1 on service S1.
  4. Perform billing (partial billing) on billing day (day X), right after midnight, that is on On 01 Feb, say 00:15 Hrs.  Next bill cycle is 01 Feb to 01 March. Lets associate bill B2 for this cycle.
  5. Purchase product P2 and discount D1 on service S1. D1 discounts product P1. Both P2 and D1 have start dates equal to day X, at midnight sharp. start_t and end_t dates on events generated have the same date as product's and discount's start_t (day X, midnight sharp).
  6. Perform billing (final billing).

Actual behavior :

In step 5, event for P2 is included in different bill (B2) than event for D1 (B1) despite having the same dates, that is:

Event for P1 is in bill B1.
Event for D1 is in bill B1.
Event for P2 is in bill B2.

Expected behavior :

Both events should be included in the same bill (B1), that is:

Event for P1 is in bill B1.
Event for D1 is in bill B1.
Event for P2 is in bill B1.

Additional Notes :

1) Rationale behind the expectation : Both events have the same dates, end_t in particular. Furthermore, the documentation describes event.end_t date as:

        "The time when event ended. This field is used to determine the billing cycle where the event should be included."

2) Additionally, the behavior is correct, if product P2 and discount D1 are purchased before performing the partial billing. The dates on product, discount and events are the same as before, but they are included in correct bills. This discrepancy seems to be invalid.


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.