Balance Buckets not created if the Account is Suspended and Unsuspended on the same Day (Doc ID 2887437.1)

Last updated on NOVEMBER 15, 2022

Applies to:

Symptoms

On 12.0.0.3.0 version,  if service is suspended and unsuspended on the same day then balance bucket for the future months does not get created even after running partial billing and the bucket only gets created when the account is suspended and unsuspended again

CURRENT BEHAVIOR:
-----------------------------
Only two buckets are created after partial bill run

Example:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create an account June 16th - Billing Day Of Month(BDOM) June 16th to July 1
2. Purchase addon bundle contains 4 services - buckets created for June month and July month (1 month Advance billing option configured)
3. Move pin_virtual_time (pvt) to 20th June and inactivated the 4 services using PCM_OP_CUS_UPDATE_SERVICES opcode
4. Move pvt to 3 hours later and activated the 4 services using PCM_OP_CUS_UPDATE_SERVICES opcode
5. Move pvt to 1st July and ran pin_bill_accts (partial billing)
  No changes in the sub-bal buckets
  No new buckets created for 4 services which are active now but existing buckets (June and July months) are still valid.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Balance Buckets does not get created if the account is suspended and unsuspended on the same day. Customer gets paying charges even when having unlimited addon creating bill shocks

Cause

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