My Oracle Support Banner

The Work Calendar Application Program Interface (API) Is Not Calculating the Business Days Correctly (Doc ID 2859303.1)

Last updated on MARCH 31, 2022

Applies to:

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


The Work Calendar API is not calculating the business days correctly.

When calculating the number of business days between the start and end dates, the Work Calendar API is excluding the end date.

For example:

Billable Charge Start Date : 01-Mar-2021
Billable Charge End Date : 31-Mar-2021
Holidays in March -0

The number of business days between start date and end date, i.e between 01-Mar-2021 and 31-Mar-2021 should be 23 days

But when using workCalendar.numberBusinessDaysBetween(startDate, endDate)
where startDate = 01-Mar-2021
and endDate = 31-Mar-2021


When calculating the number of business days, it is returning 22 days.




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.