Siebel Is Not Generating RC Charge For Last Day Of Month

(Doc ID 1950379.1)

Last updated on JANUARY 27, 2017

Applies to:

Siebel Field Service - Version 8.1.1.11.1 [IP2013] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.11.1 SIA [23030] version, Siebel Field Service

THE DESIRED BEHAVIOR

Charge is generated for the last day of the month when Charge End is the end
of the month such as 9/30/2014 and is not the first of the month such as
10/1/2014. That is, charge is the full month charge:
9/30/2014 11:59:59 PM 1466.67

"FS Agreement Charge" Business Service Method "GenerateRCCharge" is working
as expectedly when we have a schedule that is 1st of cycle (1st of Month, 1st
of Annual, 1st of Quarter, 1st of Semiannual), for example, 1st of Month.

THE ACTUAL OR UNEXPECTED BEHAVIOR

Charge is not generated for the last day of the month when Charge End is the
end of the month such as 9/30/2014 and is not the first of the month such as
10/1/2014. That is, charge is one day short of the full month charge:
9/30/2014 11:59:59 PM 1417.52

"FS Agreement Charge" Business Service Method "GenerateRCCharge" is working
as expectedly when we have a schedule that is 1st of cycle (1st of Month, 1st
of Annual, 1st of Quarter, 1st of Semiannual), for example, 1st of Month.

Error

There is no error.


REPRO_STEPS

1. Create a product in Administration - Product:

Name; GE Product 4
Price Type: One-Time
Orderable: checked
Track as Asset: checked
Sales Product: checked
Service Product: checked
Serializable: checked

Create a Service Information for the Product in Administration - Product >

Service Information

Type: Usage Meter
Name: GE Usage Measurement 4
Usage Billing Method: Incremental
Frequency: Monthly

Release the product


2. Create a Use Plan in Administration - Contracts > Use Plans:

Name: GE Usage Measurement 4

Plan Details:

Product: GE Product 4

Pricing:

Measurement Type: Usage Meter
Name: GE Usage Measurement 4

From: 0
To: blank
Amount: $1,466.67
Units: Per Count


3. Create a Contract Schedule in Administration - Contracts > Contract
Schedule

Name: GE Schedule 1
Repeat Type: Monthly By Day
Day: 1st of Month
of Every Number of Months: 1

After fill in the above, check the 'Release Flag'.

Save the Schedule's ROW_ID, Menu > About Record. It is: 1-2COQ4


4. Activating workflow processes needed (if you get some workflow errors when associating products) to associate product to an agreement in Agreements > Agreement List > Line Items.
After activating the workflow processes, reload runtime events.


5. Create an Account:

Name: test account

Save the account's ROW_ID, Menu > About Record. It is: 1-2CQVP


6. Create an agreement in Agreements > Agreement List

Name: Test GE Agreement 4
Type: Contract
Status: Current
Account: test account
Effective Date: 1/1/2013 00:00:00 AM
Start: 1/1/2013 00:00:00 AM
End: blank

7. Create a line item for the agreement in Create an agreement in Agreements > Agreement List > Line Items

Product: GE Product 4
Qty: 1 (default)
Start price: $0.00 (default)
Net Price: $0.00 (default)
Extended Net Price: $0.00 (default)
Extended Qty: 1 (default)
Sub total: $0.00 (default)

Save the line item's ROW_ID, Menu > About Record. It is: 1-2CQWC


8. Create a Charge Plan for the line item in Agreements > Agreement List > Line Items > Charge Plan

In Invoice Plan:

RC Schedule: GE Schedule 1
RC Start: 7/1/2014 00:00:00 AM
Recurring: $1466.77
RC Adjust: $48.88
RC Adjust U/M: Per Day
Commit: checked (default)
Charge End: 9/30/2014 11:59:59 PM
Charge Basis: Schedule


9. Use business service simulator to execute the business service 'FS Agreement Charge', method 'GenerateRCCharge'.


EscapeNames="true"?> ScheduleId="1-2COQ4"
 EndDate="2014-09-30 23:59:59"
 Amount="1466.67"
 CurrencyCode="USD"
 AdjustAmount="48.88"
 AdvanceTo="2014-10-01 00:00:00"
 AccountId="1-2CQVP"
 LastChargeDate="0000-00-00 00:00:00"
 ExchangeDate="2019-07-20 00:00:00"
 AgreeItemId="1-2CQWC"
 StartDate="2014-07-01 00:00:00"
 AdjustUM="Per Day"
>>

ScheduleID, AccountId, AgreeItemId are from the steps 3,5, 7.



Results:

3 charges generated:

8/01/2014 12:00:00 AM 1466.67
9/01/2014 12:00:00 AM 1466.67
9/30/2014 11:59:59 PM 1417.52

Business Impact

Missing one day charge for the bill.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms