Questions on Work Schedules (Doc ID 458858.1)

Last updated on JULY 23, 2019

Applies to:

Goal

1. Are any employee views available so that an employee can see what shift pattern they have been assigned? If so, please provide the navigation

2. What reporting capabilities are available on shifts/schedules/patterns and resources assigned to such?

3. Is it possible to create a shift that starts in the evening and finishes the next morning?
Eg. Start time of 18:00 and end time of 06:00 for a night shift? Testing this but get errors saying the end time cannot be before the start time.
How would you suggest setting up an evening/night shift using this functionality?

4. Can you please provide the base tables/views that get updated with shift and scheduling information?

Solution

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