My Oracle Support Banner

Date Difference Using Java Function Not Returning The Correct Value (Doc ID 2624575.1)

Last updated on JANUARY 03, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.7.0.1.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.7.0.1.0 version, ENV - Environment

ACTUAL BEHAVIOR
---------------
Date Difference using java function not returning the correct value.


Example :

Half-Yearly charges
Previous Bill Date : 31-May-2019
Current Billing Date : 30-Nov-2019

Difference does not come out to be 6 months. Function returns 5 months 30 days.
01-Dec-2019 is considered as 6 months.

The jave function used is, currentBillingDate.difference(previousBillingDate).getTotalMonths().

Note : currentBillingDate and previousBillingDate are custom variables.


BUSINESS IMPACT
-----------------------
This is creating a problem for the Quarterly and Half-Yearly charges and has a big impact on the merchant billing in terms of revenue.

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.