Billing Batch Performance Issue When To Rebill Cancelled Bills (Doc ID 3078809.1)

Last updated on APRIL 02, 2025

Applies to:

Symptoms

On RMB v2.9.0.0.0, Billing batch takes long time when we rebill for cancelled bill segments.

The business has a large population of customers for which they perform retro transactions (eg: Add Dependent, Terminate Dependent etc) with few years old effective dates. This cancels the Bills and Bill Segments going back to those old dates. Following the Billing batch runs, it takes a long time to rebill all of the Bill Segments on the member accounts.
Another observation was the same behavior of base Billing process irrespective of whether the batch was submitted through Scheduler or batch job submission for those member accounts.
Also the same behavior was observed when creating a Bill online from UI, it never completes.

STEPS
------------
1. Create Open Ended Membership (2021-2099).
2. Generate billable charges from 2021 Jan to 2022 Dec.
3. Process Inbound by adding Dependent.
4. Again, generate billable charges for 2023, which also had new charges for dependents.
    - Bill Generated picked all the above-mentioned charges.
5. Terminate the Membership with end date 06/30/2022 and run repricing to update the billable charges.
7. Again, generate the bill which has adjustments created from billable charges post termination end date.
    - Batch never completes.

Cause

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