Invalid Date In Sub_balance_group For Resource After Changing Bill Cycle DOM (Doc ID 1967127.1)

Last updated on APRIL 13, 2023

Applies to:

Symptoms

Test scenario:

1. Create Product P01: grant 10800 units (resource_id = 2000116) with relative_end_offset = 4 bill cycles and valid from 2014-10-01
2. Create account on 2014-10-01 and Bill cycle day-of-month changed from 1 to 10.
3. Purchase product P01 on 15^th Oct 2014,  effective time of purchase (PIN_FLD_START_T) on 1^st Oct 2014

Expected result:

Product P01 should grant 10800 units (resource_id = 2000116) with relative_end_offset = 4 bill cycles and valid from 2014-10-01.
Because of bill cycle DOM change, those 4 cycles should be as follows:
1.10.2014 - 1.11.2014
1.11.2014 - 10.11.2014
10.11.2014 - 10.12.2014
10.12.2014 - 10.01.2015

Expected valid_from/valid_to dates of sub_balance_group for this resource:
1.10.2014 - 10.01.2015

Actually Results:

Bill cycle DOM change got ignored. valid_from/valid_to dates of sub_balance_group for this resource :
1.10.2014 - 01.02.2015

Cause

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