GetElapsedBusinessTime not Returning Correct Values (Doc ID 2488588.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
GetElapsedBusinessTime method of business service "FS Holiday API Service" does not calculate the Business Time currently


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Navigate to Administration - Service >> Schedules and create a new Schedule. (Make a note of the Row Id of this record)
2) Got to Schedule Hours and create 2 records as below

a) Start Day = Thursday
Start time = 09:00 AM
End Time = 05:00 PM
Type = Normal

b) Start Day = Friday
Start time = 09:00 AM
End Time = 05:00 PM
Type = Normal

3) Got to Administration - Business Service >> Simulator

4) Create a new record with Service Name = FS Holiday API Service and Method Name = GetElapsedBusinessTime

5) Add the below inputs

Calendar id = Row Id captured in step 1

Start Time = 12/20/2018 08:00:00

End Time = 12/20/2018 11:00:00

Unit: minutes

Schedule Time Zone = CST

Run the Simulator 

Expected result = 120 mins
Actual = 60 mins

Now change the inputs as

Calendar id = Row Id captured in step 1

Start Time = 12/20/2018 09:00:00

End Time = 12/20/2018 11:00:00

Unit: minutes

Schedule Time Zone = CST

Expected Result : 120 mins

The output is 0 mins

Cause

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