My Oracle Support Banner

Unable To Remove Primary Function (Service Class) From Existing Shift Templates (Doc ID 2372650.1)

Last updated on MARCH 16, 2018

Applies to:

Oracle Mobile Workforce Cloud Service - Version NA and later
Oracle Utilities Mobile Workforce Management - Version 2.3.0.0.0 to 2.3.0.2.0 [Release 2.3]
Oracle Real-Time Scheduler - Version 2.3.0.0.0 to 2.3.0.2.0 [Release 2.3]
Information in this document applies to any platform.

Symptoms

Whenever a user attempts to remove the Primary Function (Service Class) from an existing Shift Template, the following error occurs:

ERROR
-----------------------
"Input request field Service Class has an invalid value. Referenced FK M1-SEVCL Service Class preferredServiceClass by table Service Class does not exist."

Removing the Primary Function from an individual Crew Shift works fine.  Creating a brand new Shift Weekly Template without a Primary Function also works without issue. It is only when you are trying to remove it from an existing Template that it fails with the above error.  If you attempt to remove the Primary Function where you have at least one "Not Allowed" service class then the changes is made properly.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Edit existing Crew Shift to remove Primary Function
2. Works fine, individual Crew Shift is updated to no Primary Function
3. Create new Shift Weekly Template without a Primary Function, successful
4. Edit to add a Primary Function
5. Edit to remove Primary Function
6. Unable to remove Primary Function from Shift Templates

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


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