My Oracle Support Banner

Rounding Changes Entered Amounts Or Causes Negative Amount In Service Contracts Billing Schedule (Doc ID 1136673.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Service Contracts - Version and later
Information in this document applies to any platform.


Negative amounts are getting automatically created in the billing schedule when using Level=Equal Amount . This happens after using Cascade Service Price to split an amount equally over sublines and the amount does not divide exactly (e.g. splitting 4000 equally over 3 sublines) and streams are entered so that there is a stream with 0 amount entered.  If streams with non-zero amounts are entered, then there is no negative value generated, but the user-entered amounts are still changed when creating the billing streams with the Schedule button.  This appears to be a rounding error.

Expected Functionality:
The amounts entered by the user in the billing schedule should not be changed.

Steps to Reproduce:
1. Go to (R) Service Contracts Manager (N) Launch Contracts
- author a service agreement contract
- contract start date is 04-MAR-2008 end date is 03-MAR-2011
- this service contract has 1 Service line and 3 sublines, all have 3 Year duration
2. Go to Actions > Cascade Service Price
- enter a new price of 4000 and saved
- the three sublines have prices of:
3. Click Billing button on service line and enter line billing streams as follows:
Level = Equal Amount
Stream Level
1 04-MAR-2008 to 04-APR-2008 Duration 32 Day Amount 2000
2 05-APR-2008 to 03-MAR-2011 Duration 1063 Day Amount 2000
4. Click the Schedule button
- the Total Amount fields for the above streams are populated with 2000.01 and 1999.99 respectively
- the schedule created is as follows:
1 Bill from 04-MAR-2008 Bill to 04-APR-2008 Amount 2000.01
2 Bill from 05-APR-2008 Bill to 03-MAR-2011 Amount 1999.99
- so the billing amounts are not what has been entered by the user
5. Amend the billing streams to the following:
1 04-MAR-2008 to 04-APR-2008 Duration 32 Day Amount 2000
2 05-APR-2008 to 10-MAR-2010 Duration 705 Day Amount 2000
3.11-MAR-2010 to 03-MAR-2011 Duration 358 Day Amount 0
- click the schedule button
- notice that the Total amounts then change to 2000.01, 2000.01 and -0.02 (a negative amount for the last line)
- the billing schedule matches the above




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

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