Workforce Scheduling — Requirement & Auto-Assign Issue

Business Requirement

• We manage a pool of cabin crew resources.
• Resources work predefined operating shifts:
  • 09:00–17:00
  • 17:00–01:00
  • 01:00–09:00
• Flights occur at different times during the day.
• Each flight creates a workload requirement for a specific time window.

Example

Flight	Workload Window	Required Resources
Flight A	07:45–09:00	6 resources

This workload overlaps two shifts:

• Shift 3 (01:00–09:00)
• Shift 1 (09:00–17:00)

Actual Behavior Observed

Auto Assign:

• Selects only one operating shift
• Does not split workload coverage across shifts
• Leaves coverage gap / variance

Result:

• Requirement partially uncovered even though resources exist.

Issue Description

Oracle Workforce Scheduling Auto Assign appears to be:

👉 Shift-selection based, not time-coverage optimization based.

The engine:

• Picks a single best shift