Appointment Slot Request Not Returning All Available Slots (Doc ID 2738211.1)

Last updated on OCTOBER 06, 2022

Applies to:

Symptoms

On : 2.3.0.3.0 version, Scheduling

Appointment Slot Request Not Returning all Available Slots 

This issue in production system where the appointment slot request process is not returning all available slots. concurs that something appears to be broken with this process, but has been unable to determine the cause, my understanding is that development already has the AUTO-ENTIRE1 file that will be uploaded here.

With at least one of our work groups we have seen the appointment booking request fail to bring back what we thought should be available dates. Crew Shift IDs: xxxxxxxxxxx (10/21) and xxxxxxxxxxxx (10/22) should have availability for appointments, however they were not being returned with slot requests. Mysteriously, they started to be returned this morning.
 
As such, ran another test with the same crew for a different time period. Crew Shift IDs: xxxxxxxxxxx (11/10), xxxxxxxxxxx (11/11), xxxxxxxxxxxxxx (11/12) all should have availability, but are not being returned in the slot request process. In the two examples listed below, the first available slot returned is Crew Shift ID xxxxxxxxx for 11/17.
 
At 8:23 AM submitted a slot request for Address 1 with a start date of 11/4. The first available date returned was for 11/17
 
At 8:25 AM submitted a slot request for Address 2 with a start date of 11/5. Again the first available date returned was for 11/17.
 
Again, 11/10 – 11/12 are wide open, and it’s just unclear why these slots are not being returned for this crew: Crew ID: xxxxxxxxx

Cause

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