My Oracle Support Banner

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

Last updated on JANUARY 03, 2023

Applies to:

Siebel Field Service - Version 8.1.1.6 SIA [21233] and later
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution
References


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