Incorrect Recurring Charges For "Last Day of Month" Schedule (Doc ID 1394452.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

In the customer environment, when generating recurring charges for an agreement line item, the charged amount is different from the expected amount.

Test results:
- Start = 01.06.2011 | End = 31.08.2011 -> Passed
- Start = 15.05.2011 | End = 25.08.2011 -> Passed: Partial calculation occurred as expected, seems to be working when start and end months have 31 days
- Start later in June | End = 31.08.2011 or End in mid-July -> Failed: Full charge for June while partial calculation for June was expected
- Start in September | End = 30.09.2011 or End in mid-October -> Failed: Full charge for September while partial calculation for September was expected
- Start = 30.06.2011 | End = 31.08.2011 -> Failed: No charge for June while partial calculation for June was expected
- Start in July or August | End in August -> Failed: Partial calculation for the first month missing 1 day
- Start in mid-August | End in mid-September -> Failed: Partial calculation for August missing 1 day
- Start in September | End in September -> Failed: Partial calculation for September missing 1 day


This can be reproduced in a standard Siebel environment as follows:
Siebel Public Sector v8.1.1.4 [21225] ENU, connected to Sample DB as SADMIN.

Administration - Contracts > Contract Schedule
=> Create the following schedule:
"Last day of every month", Details:
Monthly By Day, Day: Last Day of Month, Every Number of Months: 1

Agreements > Agreement List > Line Items > Charge Plan
Create agreement "HB Test RC Charges 4" with Effective = Start = 01.11.2010, End = 01.11.2020.
Create agreement item for simple product "Xerco1100".
Define RC Schedule:
> RC Schedule: Last day of every month
> RC Start: 15.07.2011
> Recurring: $100.00
> RC Adjust: 1
> RC Adjust U/M: Per Day
Save Record.
Set Advance To: 10.08.2011, then click on Charge.
=> The application goes to the Agreements > Line Items > Charges view and shows the following charge:
Date | Amount
31.07.2011 | $16.00 (Partial charge correct for July 2011, 15.7. to 30.7. = 16 days)

Agreements > Agreement List > Line Items > Charge Plan
Create agreement "HB Test RC Charges 5" with Effective = Start = 01.11.2010, End = 01.11.2020.
Create agreement item for simple product "Xerco1100".
Define RC Schedule:
> RC Schedule: Last day of every month
> RC Start: 15.06.2011
> Recurring: $100.00
> RC Adjust: 1
> RC Adjust U/M: Per Day
Save Record.
Set Advance To: 10.07.2011, then click on Charge.
=> The application goes to the Agreements > Line Items > Charges view and shows the following charge:
Date | Amount
30.06.2011 | $100.00 (Full instead of partial charge for June 2011, 15.6. to 29.6. = 15 days)

=== > In this test on Sample DB, recurring charges for the Last day of every month are
- generated correctly for the Last Day of Month in July.
- NOT generated correctly for the Last Day of Month in June.

Cause

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